Problem with TSQLQuery

[Soniak]

Hello
Problem beguile with TSQLQuery after interrogation query:

      SQLQuery1.SQL.Clear;
      SQLQuery1.SQL.Add( '"SELECT * FROM TEST;"' );
      SQLQuery1.Open;

Application reports error  :

SQLQuery1 : Cannot open a non-select statement

In inspector of object SQLQuery1 I can not change parameter StatementType it returns after change on other always for stNone

It thanks from mountain for assistance

(On configuration : WinXP, MYSql 5, Lazarus 0.9.18Beta )

Soniak

[matthijs]

I presume you have SQLQuery properly connect to SQLConnection and SQLDatabase. Then the follwoing code should work:

Code: [Select]


 SQLQuery1.SQL.Clear;
 SQLQuery1.SQL.Add('select * from test');
 // Other possibility  SQLQuery1.Text := 'select * from test';
 SQLQuery1.Open

Your error might be in the number of quotes, because in your sample the SQL text which is parsed starts and ends with a quote. So the parser things you are sendign some string to database.

(Maybe an other error message would be more clear. )