[Lazarus] SQLDb ApplyUpdates

[Joost van der Sluis]

Op vrijdag 07-08-2009 om 18:05 uur [tijdzone +0200], schreef JoshyFun:
> Hello,
> 
> Lazarus: SVN a week ago.
> fpc: 2.2.3, 2.2.4
> Database: Firebird 1.5 and 2.1
> 
> Does anybody known a reason why this code will crash:
> 
> SQLQuery1.Delete;
> SQLQuery1.ApplyUpdates;
> SQLTransaction1.CommitRetaining;
> SQLQuery1.Next;
> SQLQuery1.Delete;
> SQLQuery1.ApplyUpdates;
> SQLTransaction1.CommitRetaining;

Can you make a bug-report for this? (Maybe you could even re-format the
code above in a testcase for the db-testsuite in fcl-db/tests)

> The crash happends in the second ApplyUpdates. This is a simplified
> copy of the original code which crashes when trying to delete a second
> record in a dbgrid, no matter the order or the position of both
> deleted records. This code was working fine in 2.2.2 fpc version but
> no more using fcp 2.2.3 or 2.2.4.
> 
> The error is quite strange:
> 
> -----------------------------------------
> IBConnection1: PrepareStatement
> -Dynamic SQL error
> -SQL Error code = @1
> -Token unknown - line @1, column @2
> - at 1
> -----------------------------------------

Probably some old handle is used, which becme invalid after the
commitretaining.