[ask]SQLDB how to execute multiple statement?
lazarus / 16-Databases

----------------------------------------------------------------------
kodok_buncit · 2011-09-19 07:49

i've try assigning my multiple sql into SQLQuery.SQL.text and execute
it , but just first statement that inserting to db.
i've also try
Code: [Select]SQLQuery.sql.Append(statement1);
SQLQuery.sql.Append(statement2);
SQLQuery.sql.Append(statement3);

SQlQuery.ExecSQL();
the result are same. i debug it writeLn(SQLQuery.SQL.text)
and produce what i expect.

note : each statement separeted by ";" .

----------------------------------------------------------------------
kodok_buncit · 2011-09-19 08:51

solved i use TSQLScript