Recent

Author Topic: [solved] TSQLQuery, DBNavigator and AfterScroll/AfterPost questions  (Read 5935 times)

thierrybo

  • Full Member
  • ***
  • Posts: 146
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 ...
« Last Edit: March 18, 2010, 02:40:59 pm by thierrybo »

Lacak2

  • Guest
Re: TSQLQuery, DBNavigator and AfterScroll/AfterPost questions
« Reply #1 on: March 18, 2010, 01:37:40 pm »
Use AfterPost (for Insert,Append and Edit) and AfterDelete (for Delete)

thierrybo

  • Full Member
  • ***
  • Posts: 146
Re: TSQLQuery, DBNavigator and AfterScroll/AfterPost questions
« Reply #2 on: March 18, 2010, 02:40:26 pm »
Thanks,

it was so simple  :-[

 

TinyPortal © 2005-2018