Sure. If you simple want to save changes you can use DatabaseUpdate statement. DatabaseUpdate will update database with changes made in the buffer since last DatabaseRetrieve, DatabaseImport, or DatabaseUpdate. To save contents of entire buffer in a different table or a different database you can do DatabaseExport to temporarily save the buffer contents, then make a new connect using dummy retrieve from the new table (for instance you can put WHERE 1=0 in the SQL so the buffer can be built but no data will be fetched). Then you would do DatabaseImport from the saved file following by the DatabaseUpdate : Is there a way to Fetch Information from the Primary Buffer
: into a table. : thanks : Leslie G
|
