[SOLVED] SQLite Can't UPDATE

[pcurtis]

Why doesn't this give any errors? (Can't find Param1 ...)

Code: Pascal  [Select][+][-]

1. procedure TForm1.Button1Click(Sender: TObject);
2. var
3.   sSQL : string;
4. begin
5.   sSQL := ' UPDATE tnTEST' +
6.           ' SET' +
7.           ' fnTEST = :Param1' +
8.           ' WHERE fnIDX = :Param2';
9.  
10.   SQLQuery1.DataBase := SQLConnector1;
11.   SQLQuery1.SQL.Clear;
12.   SQLQuery1.SQL.Add(sSQL);
13.  
14.   SQLQuery1.ExecSQL; <* Should throw an error here
15. end;  
16.  

[six1]

You've to define the Parameters i.e.:
SQLQuery1.SQL.Parambyname('Param1').asstring:= .....
SQLQuery1.SQL.Parambyname('Param2').asstring:= .....

[PascalDragon]

You've to define the Parameters i.e.:
SQLQuery1.SQL.Parambyname('Param1').asstring:= .....
SQLQuery1.SQL.Parambyname('Param2').asstring:= .....

pcurtis seems to know what the problem is. Their question was why there is no error if no parameters are set.

[pcurtis]

Yes "Why there is NO error"

Or the main problem is when I specify the correct parameters

SQLQuery1.SQL.Parambyname('Param1').asinteger:= 100
SQLQuery1.SQL.Parambyname('Param2').asinteger:= 1

 the table isn't updated.

(And yes there is a row where fnIDX = 1)

[shadow]

I guess Param1 and Param2 are being interpreted as NULL if you don't assign an explicit value.

[pcurtis]

See above comment

(And ParamCheck := true)

[korba812]

ParamCheck property does not mean that the parameters will be checked for null value.
https://www.freepascal.org/docs-html/current/fcl/sqldb/tsqlquery.paramcheck.html
Besides, null value is also a valid value for the parameter.
You probably aren't committing the transaction after execution and therefore the data isn't updated in the table.

[pcurtis]

Problem solved - the database was corrupt, and needed repairing.
But I still think it should throw an error when a parameter is missing (Take ZEOS for example)