Recent

Author Topic: [ask]SQLDB how to execute multiple statement?  (Read 2509 times)

kodok_buncit

  • New Member
  • *
  • Posts: 33
    • fajardelphiscript
[ask]SQLDB how to execute multiple statement?
« on: September 19, 2011, 09:49:21 am »
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 ";" .
 :-X
« Last Edit: September 19, 2011, 09:52:40 am by kodok_buncit »
Peace and blessings be upon you all

kodok_buncit

  • New Member
  • *
  • Posts: 33
    • fajardelphiscript
Re: [ask]SQLDB how to execute multiple statement?
« Reply #1 on: September 19, 2011, 10:51:02 am »
solved i use TSQLScript  :D
Peace and blessings be upon you all

 

TinyPortal © 2005-2018