On 10/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


On Mon, 9 Oct 2006, Adrian Maier wrote:

> On 10/9/06, Christian Ulrich <[EMAIL PROTECTED]> wrote:
> >
> > > - deleting rows doesn't work for any of the tables.  The user is asked
> > > to confirm, but the row is not deleted.
> >
> > maybe its deleted and not drawn in the dbgrid ??
>
> Nope.  I am monitoring all the commands that are sent to the database,
> and I haven't seen any DELETE.
> Also, after restarting the program the row is still there. I'm pretty sure
> that
> for some reason the delete command is not executed at all.

Did you call applyupdates ?
I think SQLQuery does some buffering of commands ?

Yes:  I have a "save" button that does:
   query1.ApplyUpdates;
   Ftransaction.CommitRetaining;


--
Adrian Maier

_________________________________________________________________
    To unsubscribe: mail [EMAIL PROTECTED] with
               "unsubscribe" as the Subject
  archives at http://www.lazarus.freepascal.org/mailarchives

Reply via email to