N
N
NirumVS2013-11-18 22:57:03
Delphi
NirumVS, 2013-11-18 22:57:03

SQLite+delphi how to execute a batch query?

Please help me with the solution of the following problem:
I create a bundle in Delphi XE5:
sqlConnection-SQLQuey-DataSetProvider-ClientDataSet-DataSource-DbGrid
I write a query in SqlQuery

select 1;
select 2;


As a result, I get the answer: 1
Why can't I get the answer: 2?
Why does sqlite ignore the second select?
Although the same SQLite Expert can correctly perform two selects in a row.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Skahin, 2013-11-19
@pihel

Can write UNION between requests? Or wrap in BEGIN ... END; ?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question