This issue may also be Database Transaction related. Depending on how your app
is structured you need to be aware of which transaction(s) things are running
within. For example (and somewhat simplified) the record-add you did may have
happened in a different transaction to the one QToDo is assigned to, if the
record-add transaction wasn’t committed then the new record would not be
visible to other transactions, hence QToDo did not see this record. In this
example closing your app may have automatically triggered the commit of the
add-record transaction.
From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On
Behalf Of Marshland Engineering
Sent: Friday, 14 January 2011 12:50 p.m.
To: delphi@delphi.org.nz
Subject: [DUG] Sql query
I'm viewing a SQL query in a dbgrid. When I add a record to the source db and I
run QToDo.Refresh it does not include the new record in the dbgrid. If I close
the application and re-run it, the record is displayed.
Is refresh the correct property or is there something else.
Thanks Wallace
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject:
unsubscribe
