Devart Forums

I have three syntaxes for create table.

For example,

CREATE TABLE TestTable1(
SHEET_IDX1 integer,
TIMEZONEIDX1 integer, SYNC_CARGO_PORT text );
CREATE TABLE TestTable2(
SHEET_IDX2 integer,
TIMEZONEIDX2 integer, SYNC_CARGO_PORT2 text );
CREATE TABLE TestTable3(
SHEET_IDX3 integer,
TIMEZONEIDX3 integer, SYNC_CARGO_PORT2 text );

When I input like below, only one table is created.

Uniquery.SQL.Add('CREATE TABLE TestTable1(
SHEET_IDX1 integer,
TIMEZONEIDX1 integer, SYNC_CARGO_PORT text ); ');
Uniquery.SQL.Add('CREATE TABLE TestTable2(
SHEET_IDX2 integer,
TIMEZONEIDX2 integer, SYNC_CARGO_PORT text ); ');
Uniquery.SQL.Add('CREATE TABLE TestTable3(
SHEET_IDX3 integer,
TIMEZONEIDX3 integer, SYNC_CARGO_PORT text ); ');

Uniquery.Execute;

How can I create these tables by calling execute method one time?

Hello.

To execute several SQL statements, you should use the TUniScript component. The detailed information about TUniScript can be found here: http://www.devart.com/unidac/docs/devar ... script.htm