"limit" in sql query causes server errors

[wht244]

i use line:

Code: [Select]

frmMain.sql.SQL.Text := 'select listasprzedaz.* from listasprzedaz where datasprzedazy = "2009-12-20" and idklienta = 0';to get info from table.
when i use "limit" command - i get server errors. full query:

Code: [Select]

frmMain.sql.SQL.Text := 'select listasprzedaz.* from listasprzedaz where datasprzedazy = "2009-12-20" and idklienta = 0 limit 128';this query causes error like:

Code: [Select]

Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 128)' at line 1.
the weird thing is that in that error there is a ")" on the end. i don't know where it came from and i don't know how to delete that.

can anyone help?
lazarus v0.9.28.2

[wht244]

as i see, there are problems with mysql. programs compiled by lazarus sometimes transform query strings into strings that can cause many other errors. can anyone help?

[Loesje]

Set parsesql to false, and submit a fpc-bug report with the particular sql-statement giving this problem

[wht244]

setting parsesql to false does not help. how to submit a fpc bug report?

[wht244]

i submitted a fpc bug report. but how long i can wait?