Problem with TSQLQuery
lazarus / 16-Databases

----------------------------------------------------------------------
Soniak · 2006-11-29 18:09

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 · 2006-11-30 07:30

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.  )