sql statement not set
lazarus / 16-Databases

----------------------------------------------------------------------
ismailzakky · 2016-01-22 14:55

i'm new with pascal and Mysql using TMysql55Connection, TSQLQuery, And
TSQLTransaction, when i tried to selection some data from my table i
got some message "SQL Statement Not Set", already try my sql at my
sqlyog and it's a valid query.

this is my code.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i program
project1; usesmysql55conn,sqldb; var  s : string;  conn :
TMySQL55Connection;  query : TSQLQuery;  transaction :
TSQLTransaction;begin      conn := TMysql55Connection.Create(nil);   
 query := TSQLQuery.Create(nil);     transaction :=
TSQLTransaction.Create(nil);       conn.HostName := '127.0.0.1';   
 conn.UserName := 'root';     conn.Password := '';   
 conn.DatabaseName:= 'db_bsc' ;     conn.Transaction := transaction; 
  conn.Connected := true;     conn.Open;      query.DataBase := conn; 
   query.Active:= true;     query.SQL.Text := 'SELECT * FROM
tb_divisi';     query.Open;     while not query.EOF do     begin     
   writeln('nama divisi
:',query.FieldByName('nama_divisi').AsString);          query.Next;  
 end;     query.Close;     conn.Close();        writeln('asdasd');   
 readln;end. thanks for your attention, and sory for my bad english.

----------------------------------------------------------------------
FTurtle · 2016-01-22 15:31

Quote     query.Active:= true;
     query.SQL.Text := 'SELECT * FROM tb_divisi';
     query.Open;

Replace it by:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i    
 query.SQL.Text := 'SELECT * FROM tb_divisi';     query.Open; 
or:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i    
 query.SQL.Text := 'SELECT * FROM tb_divisi';     query.Active:= true;

----------------------------------------------------------------------
FTurtle · 2016-01-22 15:51

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
conn.Connected := true;  // does the same as:    
conn.Open;  query.Active:= true;  // does the same as:     query.Open;