Temp-table data as fill-ins

[ChrisJRutter]

I have a static temp-table in a browse.

On event 'value-changed' I would like to display (and update if required) the highlighted temp-table record in a frame alongside the browser.

Question is, how do I reference a static temp-table's record in a frame?

I have mucked about with setting up a temp-table under procedure settings and trying to move my temp-table's structure into it's definition but that didn't work at all.

I recall seeing a workaround post for this a long time ago. Can anyone recall how this is done?

Cheers

 

[it@flude.co.uk]

We do this in file maintenance browses and also in browses for certain reports where we need to show calculated values alongside the browse values (V8).

Use iteration-changed rather than value-changed, then store the recid or rowid of the current record.

So, for a browse cust_browser in a frame browsframe on the customer database table, try this:

def var current_rowid as rowid no-undo.

ON ITERATION-CHANGED OF cust_browser in frame browsframe DO:
current_rowid = rowid(customer).

run p_do_whatever_i_want.

/* p_do_whatever_i_want is whatever you want to do*/
END.

Simon