[Lazarus] SQLDb Query Insert, Update vs SQL

[Joost van der Sluis]

On Wed, 2009-11-04 at 18:25 +0100, JoshyFun wrote:
> Hello Lazarus-List,
> 
> Wednesday, November 4, 2009, 3:35:14 PM, you wrote:
> 
> i> I've added the queries into the InsertSQL nd UpdateSQL however it seems like
> i> it is using the SQL code and make "it's own" update and insert (I know this
> i> because the index is set to not null, and in the select statement I retrieve
> i> it, but on Update and Insert it raises an exception that the ID is mandatory
> i> and is null).
> 
> Update and Insert SQL (custom) requires a quite recent patch, or a fpc
> 2.0.x (if my memory serves me).

That's true. But as a workaround you can set them in code. 

Joost.