I'm using Delphi 6 and BDE to work against an Oracle or SQL server database (native connection).
During the application, I'm running a select statement that does not return a value in order to create an empty dataset. After filling some data in the recordset I use the post method to save the record. The problem is that after doing the post method, I lose the current record and have an empty dataset, which requires me to re-query the table to retrieve the current record.
Any idea how to solve this problem?