Hi Steve Woah! THAT took half the day to come through!
Yes it IS a live query (only single table) and yes you are right, what you suggest works fine. Somehow this morning it told me the Dataset was not in Edit mode and so I thought there must be something fancy required. As you can see, programming continues to be somewhat of a mystery! Thanks Mark On 9 Oct 2003 at 11:40, Steve Peacocke wrote: > Gidday Mark, > > 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/ > --------------------------------------------------------------------------- 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/
