SQLExecute and semicolons

Databases
1

Hi,

How does a SQLExecute command deal with semicolons at the end of sql statements?

Does it add internally a semicolon to the statement if I omit to add it to the statement? Does it hurt if I manually add a semicolon to each statement?

Thank you,
Payam

2

[quote=142793:@Payam Arzani]Hi,

How does a SQLExecute command deal with semicolons at the end of sql statements?

Does it add internally a semicolon to the statement if I omit to add it to the statement? Does it hurt if I manually add a semicolon to each statement?

Thank you,
Payam[/quote]

It is not needed, as long as you do not work within Transactions.
It does not hurt if you add it.

3

What happens then? And why?

4

Never really tried it, but i would assume that the engine can’t separate properly between querries?