[sqlite] simple query - error

[wht244]

i have a problem with a simple query:

Code: [Select]

SELECT nazwisko FROM handlowcy WHERE id = 1 LIMIT 0, 1in sqlite database browser this query returns what i want, but if i try to execute that query with lazarus:

Code: [Select]

query.SQL.Text := 'SELECT nazwisko FROM handlowcy WHERE id = 1 LIMIT 0, 1';
try
  query.Open;
finally
  query.Close;
end;i get an error:

Code: [Select]

near: LIMIT syntax erroror something like this.
any suggestions how to deal with it?
i'm using components from SQLdb tab (built-in)

[gastonx]

Which database?
MSSQL or mySQL?
MSSQL has no LIMIT function. Only TOP.

[Lacak2]

Which version of FPC ?
There was patch 5 months ago, which adds handling of LIMIT keyword into SQLParser see http://bugs.freepascal.org/view.php?id=15456

[wht244]

how to install this patch?

[xenblaise]

try that;
query.SQL.Text := 'SELECT nazwisko FROM handlowcy WHERE id = 1 LIMIT 1';

[Lacak2]

how to install this patch?

You can download daily snapshot of Lazarus with FPC 2.5.1 from ftp://www.hu.freepascal.org/pub/lazarus/snapshots/

[wht244]

i set field ParseSQL of TSQLQuery to false and that helped me a lot.
but i encountered other problem. query:

Code: [Select]

UPDATE handlowcy SET nazwisko = 'test' WHERE id = 1 LIMIT 1is also interpreted as it has error with syntax near LIMIT.

[Lacak2]

Do you use Filter or ServerFilter properties of SQLQuery component ?
Is SQLQuery in master-detail relationship with another component ?

[wht244]

Filter and ServerFilter are not used.
Only relationships are TSQLTransaction and TSQLite3Connection.

[xenblaise]

UPDATE handlowcy SET nazwisko = 'test' WHERE id = 1 LIMIT 1

just no limit while id = 1
UPDATE handlowcy SET nazwisko = 'test' WHERE id = 1

Filter and ServerFilter are not used.
Only relationships are TSQLTransaction and TSQLite3Connection.

yes