[SOLVED] SQLite SQL error

[dodgebros]

Hi all, I get this error with the following code: SQLiteConnection1: near 'INSERT': syntax error

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

1. DataModule1.SQLQry_RptData.SQL.Add('INSERT INTO rpt_data (colx, coly, info) VALUES (:colx, :coly, :info)');
2. DataModule1.SQLQry_RptData.Params.ParamByName('colx').AsString:= 'X';
3. DataModule1.SQLQry_RptData.Params.ParamByName('coly').AsString:= 'Y';
4. DataModule1.SQLQry_RptData.Params.ParamByName('info').AsString:= 'test info';
5. DataModule1.SQLQry_RptData.ExecSQL;
6. DataModule1.SQLTransaction1.Commit;
7.  

What am I doing wrong?
TD

[Zvoni]

Don't use the Add-Method.
Clear the SQL.Text beforehand and assign directly to SQL.Text

[dodgebros]

That solved the problem, thank you very much!
TD

[paweld]

Why not?
Just remember to clear SQL

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

1. SQLQuery1.SQL.Clear;
2. SQLQuery1.SQL.Add(' ... ');

[Zvoni]

Why not?
Just remember to clear SQL

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

1. SQLQuery1.SQL.Clear;
2. SQLQuery1.SQL.Add(' ... ');

pawel,
yeah, but it's the reason i rather use the Text-Property than the Add-Method.
If i "forget" to "clear" the SQL, then it still gets its job done

The SQL-Property is a TStrings: https://www.freepascal.org/docs-html/rtl/classes/tstrings.text.html

When this property is set, the string will be cut into smaller strings, based on the positions of end-of-line markers in the string. Any previous content of the stringlist will be lost.