[firebird-support] how to call 'commit' after you exit the cell being edited?

2013-04-19 Thread dice_in_trouble
i had this experience earlier in which i need to close the app for the db grid 
to update even

i have these components:

1 zconnection
1 ztable
1 datasource
1 dbgrid
1 navigation bar

if i press refresh on the nav bar, the entry on the other computer wont appear. 
i would like the dbgrid to update when i click the refresh button whenever 
someone edit it's contents.

i also think that the database might overlap the entries from 2 or more users.

some users say i need to call commit, how do i do that and do i need to put it 
on every db grid i have on the application?

btw i am using delphi 7 and zeoslib 7.0.3

thanks



Re: [firebird-support] how to call 'commit' after you exit the cell being edited?

2013-04-19 Thread Mark Rotteveel
On Fri, 19 Apr 2013 15:44:57 -, dice_in_trouble
dice_in_trou...@yahoo.com wrote:
 i had this experience earlier in which i need to close the app for the
db
 grid to update even
 
 i have these components:
 
 1 zconnection
 1 ztable
 1 datasource
 1 dbgrid
 1 navigation bar
 
 if i press refresh on the nav bar, the entry on the other computer wont
 appear. i would like the dbgrid to update when i click the refresh
button
 whenever someone edit it's contents.
 
 i also think that the database might overlap the entries from 2 or
more
 users.
 
 some users say i need to call commit, how do i do that and do i need to
 put it on every db grid i have on the application?
 
 btw i am using delphi 7 and zeoslib 7.0.3

I have never used Zeoslib, but the ZConnection has a Commit method. Be
aware though that the writer needs to commit, but also the reader
(otherwise the reader will not see the updates!)

Mark