Hi all
Using D5 and DBISAM and no data aware visual components
I've not used a TQuery before for updating a database table.
I have a live dataset which is the result of opening a Query select statement.
I can navigate the dataset with forward and back arrows and display the cursor
position with "RecNo or RecordCount".
How do I delete the current record, update the record count and return to the
original cursor position in the dataset?
ie is there a better way than:
Save Bookmark,
Close,
clear
Add delete SQL
ExecSQL
Close
Clear
Add original Select SQL
Open
Go to Bookmark
??
TIA
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
