Firebird 2.5 and ubdateSql
lazarus / 16-Databases

----------------------------------------------------------------------
ahmetnurideniz · 2011-11-30 21:08

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 · 2011-11-30 23:34

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 · 2011-12-01 11:16

thansk it is working.