update temp-table browser

[myilmaz]

Hi;

I have a updatable FreeForm Query browser on a temp-table and
a smart-panel (updsav) ( this panel have smart-link tableIO with this browser).

First for create new record in this browser on smart-panel with add button for enter data and after save button. I not living a problem.

But when click add button and after save button for second record on smart-panel. record not update-end on browser.
so Not enable for add record for next new record on smart-panel.

thank you for all.

 

[Olivier_Desmars]

After your record creation/update try a :

OPEN QUERY {&BROWSE-NAME} FOR EACH {&TT_TABLE} NO-LOCK.

where {&BROWSE-NAME} is the name of your browser , and {&TT_table} is the name of your temp-table.

 

[myilmaz]

After your record creation/update try a :

OPEN QUERY {&BROWSE-NAME} FOR EACH {&TT_TABLE} NO-LOCK.

where {&BROWSE-NAME} is the name of your browser , and {&TT_table} is the name of your temp-table.

its great.
But when after add or update record; not selected current record. Selection first record.
how can select current record after add or update.

 

[vakpal]

its great.
But when after add or update record; not selected current record. Selection first record.
how can select current record after add or update.

Try "REPOSITION"

Example:

"REPOSITION {&QUERY-NAME} TO ROWID ROWID({&TT_TABLE})."

OR

"REPOSITION {&QUERY-NAME} TO RECID RECID({&TT_TABLE})."

OR

Without "OPEN QUERY".

REFRESH()

"{&BROWSE-NAME}:REFRESH()."

This metod update your CURRENT record in Browse.