How dows TSQLScript operate?

[egsuh]

Does it send sqlstatements one by one, or at once?
I found that Firebird supports EXECUTE BLOCK, for example in the case of inserting multiple records.
It can be done with TSQLQuery with SQL statement like:

Code: SQL  [Select][+][-]

1.      EXECUTE BLOCK AS BEGIN
2.         INSERT INTO table1 (f1, f2) VALUES (1, 2);
3.         INSERT INTO table1 (f1, f2) VALUES (11, 12);        
4.         INSERT INTO table1 (f1, f2) VALUES (21, 22);
5.         ....
6.      END;
7.  

But with TSQLQuery I have to drop EXECUTE BLOCK statement itself. So, TSQLScript.Script would be

Code: SQL  [Select][+][-]

1.         INSERT INTO table1 (f1, f2) VALUES (1, 2);
2.         INSERT INTO table1 (f1, f2) VALUES (11, 12);        
3.         INSERT INTO table1 (f1, f2) VALUES (21, 22);
4.         ....
5.  

without EXECUTE BLOCK AS BEGIN and END.


If TSQLQuery sends each statement one by one, TSQLQuery using Execute Block would have merit in performance.

[Zvoni]

?!?!??!
One shot instead of three....

Code: SQL  [Select][+][-]

1. INSERT INTO table1 (f1, f2)
2.         VALUES  (1, 2),
3.                 (11, 12),
4.                 (21, 22);
5.  
6.  

[egsuh]

I've shown multiple insertions as an example, but there could be mixed statements of insert, delete, etc.

[Leledumbo]

The wiki is your friend.

[Zvoni]

I've shown multiple insertions as an example, but there could be mixed statements of insert, delete, etc.

Don't!!!
Don't mix Statements. Period.
You might start a nuclear rocket in North Korea......

[egsuh]

The wiki is your friend

That means it is sent to DB server at once. Good news.

You might start a nuclear rocket in North Korea......

I may find out how to control them

[rvk]

The wiki is your friend

That means it is sent to DB server at once. Good news.

What makes you think that?

Look at the source (procedure TCustomSQLScript.ProcessStatement in fcl-db/src/base/sqlscript.pp).

https://gitlab.com/freepascal.org/fpc/source/-/blob/main/packages/fcl-db/src/base/sqlscript.pp

https://www.freepascal.org/docs-html/fcl/sqldb/tsqlscript.html

[egsuh]

So it executes statements one by one using TSQLQuery. EXECUTE BLOCK in TSQLQuery is better option.