DataSet.Delete? ----- Original Message ----- From: "Mark Howard" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 11:24 AM Subject: [DUG]: Deleting from Live Query dataset
> 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/
