Appending records to a dynamic query

[bond007jlv]

I have define a lookup dialog window to display record from a temp-table. The buffer and query handles of the temp-table are passed to the dialog. A 1000 records are initially loaded to the temp-table. How would I use the dynamic query for the temp-table to append another 1000 records to the temp-table.

 

[AndrewSmith]

I'm not sure what mechanism you're using to get the first 1000 records into the temp-table. Perhaps you could post some of the code?

If you have the buffer-handle and query-handle of the TT, there's not much you can do from there really. You need to have some idea of what query was used on the real DB table to populate the TT in the first place.

If you had THAT query handle, and the ROWID of the last record you read, you could use the REPOSITION-TO-ROWID() method to get the query back to record 1000, and then do another 1000 GET-NEXT() method calls, create TT records as you go, then reopen the TT query, causing a refresh of your TT browse.

Hope that makes some sense???