Answer the question
In order to leave comments, you need to log in
UniDac + PostgreSQL How to execute several Inserts within one ExecSQL()?
There is TUniConnection, TPostgreSQLUniProvider, TUniQuery
The code is something like this:
Q->SQL->Text = " insert into tbl_A (colum1,column2) values(1,1); \r\n"
" insert into tbl_A (colum1,column2) values(2,2); \r\n"
" insert into tbl_A (colum1,column2) values(3,3); ";
Q->ExecSQL();
Answer the question
In order to leave comments, you need to log in
There is a TUniScript component, it perfectly copes with this task.
You need to work with it in the same way as with TUniQuery.
The code is the following:
UniScript->SQL->Text = " insert into tbl_A (colum1,column2) values(1,1); \r\n"
" insert into tbl_A (colum1,column2) values(2,2); \r\n"
" insert into tbl_A (colum1,column2) values(3,3); ";
UniScript->Execute();
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question