Firebird 2.5 and ubdateSql

[ahmetnurideniz]

Hi,
I am useing Firebird 2.5, Lazarus 0.9.30  and SQLQuery
I can connect db. I can do everything first.
I set parsesql is true.
then I right click SQLQuery and select edit fields. 
I added the all fields but after I add fields parsesql  is not generate update delete and insert sqls.
When I add update sqls from my codes.

Code: [Select]

      UPDATE LISTS SET LISTS_ID=:LISTS_ID, LISTS_FINDS=:LISTS_FINDS, LISTS_REPLACE=:LISTS_REPLACE, LISTS_COMMENT=:LISTS_COMMENT
WHERE LISTS_ID=:Old_LISTS_ID;
                             


But there is error message. Error message is
field not found Old_LISTS_ID

Where is my mistakes ?

[joseme]

LISTS_ID is your key field, it should not be updated.
The SQL text should be as follows:

Code: [Select]

      UPDATE LISTS SET LISTS_FINDS=:LISTS_FINDS, LISTS_REPLACE=:LISTS_REPLACE, LISTS_COMMENT=:LISTS_COMMENT
WHERE LISTS_ID=:OLD_LISTS_ID;
         

[ahmetnurideniz]

thansk it is working.