[solved] TSQLQuery, DBNavigator and AfterScroll/AfterPost questions
lazarus / 16-Databases

----------------------------------------------------------------------
thierrybo · 2010-03-18 07:49

Hi,

following my previous post, I try to handle Delete/Insert/Update
events with DBNavigator.

I read fcl db unit doc and set SQLQuery1.ApplyUpdates in
SQLQuery.AfterPost event.
This way I can Add and edit records but I can't delete, since Post
does not occurs on Delete.

Then I uses AfterScroll instead of AfterPost. This way I can delete
records but I can't Add new records neither edit. fcl docs says
AfterScroll occurs after Delete And Insert (and says Append raises the
sames events as Insert).

So I tried to use BOTH AfterScroll and AfterPost events, but I always
can't add new
records. So what is the proper way to to this ...

----------------------------------------------------------------------
Lacak2 · 2010-03-18 12:37

Use AfterPost (for Insert,Append and Edit) and AfterDelete (for
Delete)

----------------------------------------------------------------------
thierrybo · 2010-03-18 13:40

Thanks,

it was so simple