TMyQuery Execute vs ExecSQL

[lastminute]

Hi

Would someone help me to understand the main differences between using something like:

TMyQuery *Q = new TMyQuery(Application);
Q->Connection = conn;
Q->SQL->Add(query);
Q->Execute();
Q->Free();

OR
...
Q->ExecSQL();
...

Assuming "query" will be always an Update, or Delete or Insert statement.

I know Execute does an implicit call to Prepare, is that the only difference between ExecSQL and Execute?

Thanks
Javier

[AndreyZ]

Hello,

There is no difference between the TMyQuery->Execute() and TMyQuery->ExecSQL() methods, the TMyQuery->ExecSQL() method internally calls the TMyQuery->Execute() method. The TMyQuery->ExecSQL() method is added for compatibility with the TQuery component.

[Justmade]

Or it is more simple to directly execute the statement with no result dataset using :

conn->ExecSQL('Your statement');

[lastminute]

Thanks a lot for your prompt response