There are several ways to go about this but I tend to avoid using live queries at all.
If it truly is live then calling the Delete method of the query will delete it - refresh the query afterwards. Returning to the record you want is a matter of using the FIND method.
Steve Peacocke Free DBISAM Query tool - http://trader.co.nz/tools
At 11:24 a.m. 9/10/2003, you wrote:
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/
---------------------------------------------------------------------------
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/
