EXECUTE_QUERY - display last record saved or updated
129520Dec 9 2001 — edited Mar 7 2007After saving a new record to the database from a form I use the
following code:
CLEAR_BLOCK(NO_VALIDATE);
EXECUTE_QUERY; -- re-execute the query
The result is the displayed record defaults to the first record
in the table. Is there any way to force it to show the record
that was inserted.. i.e. the last record.
Perhaps more difficult to accomplish: If updating a record... is
there a way to requery and display the record that was just
updated?
Does anyone know a solution?
Kevin