Could LiteDAC support multi sqls?

[Eden0928]

I want used mulit SQLs, below:

Code: Select all

Create Table tmpTable(AA int);
Insert Into tmpTable(1);
Insert Into tmpTable(2);
Insert Into tmpTable(3);
...

Now, my delphi code is:

Code: Select all

LiteQuery1.SQL.Text := 'Create...';
LiteQuery1.ExecSQL();
LiteQuery1.SQL.Text := 'Insert Into...';
LiteQuery1.ExecSQL();
...

Could I to use TLiteQuery.SQL.TEXT := SQLs; and ExecSQL(); run once it?

[AlexP]

Hello,

You can run several SQL commands in the TLiteSQL and TLiteScript components, for example:

Code: Select all

  LiteSQL1.SQL.Text := 'Create Table tmpTable(AA int);'#13#10 +
                       'Insert Into tmpTable(1), (2), (3)';
  LiteSQL1.Execute;

[Eden0928]

Hi,
I try the code, below:

Code: Select all

    _Command := TLiteSQL.Create(Self);
    _Command.Connection := LiteConnection1;
    _Command.SQL.Text := ''
      +'CREATE TABLE DEPT '
      +'( '
      +'   DEPTNO INTEGER NOT NULL, '
      +'   DNAME  VARCHAR(14), '
      +'   LOC    VARCHAR(13), '
      +'   PRIMARY KEY (DEPTNO) '
      +'); '
      + #13#10
      +'INSERT INTO DEPT '
      +'VALUES      (10, '
      +'             ''ACCOUNTING'', '
      +'             ''NEW YORK''); '
      + #13#10
      +'INSERT INTO DEPT '
      +'VALUES      (20, '
      +'             ''RESEARCH'', '
      +'             ''DALLAS''); '
      + #13#10
      +'INSERT INTO DEPT '
      +'VALUES      (30, '
      +'             ''SALES'', '
      +'             ''CHICAGO''); '
      + #13#10
      +'INSERT INTO DEPT '
      +'VALUES      (40, '
      +'             ''OPERATIONS'', '
      +'             ''BOSTON''); ';
    _Command.Execute();

  LiteQuery1.Open();
  ShowMessage(IntToStr(LiteQuery1.RecordCount));

It report "0"!!!

Why?

[ZEuS]

Thank you for the information.
We have reproduced the problem with executing multiple SQL statements using TLiteSQL and will include the fix in the next LiteDAC build.
For now you can use the TLiteScript component instead of TLiteSQL to execute a sequence of SQL statements. More information about the TLiteScript component you can find in the LiteDAC documentation at our web-site: http://www.devart.com/litedac/docs/deva ... script.htm .