Devart Forums

Hi there

I have a question. Maybe it's a dumb one but I'm just not sure if it's possible without causing trouble...

Is is possible to use multiple statements for the SQLUpdate property in TMyQuery ?

Somethin like this:

MyQuery.SQLUpdate.Clear;
MyQuery.SQLUpdate.Add('UPDATE terminals SET terminal_machineid = :terminal_machineid, terminal_requiresnewregistration = 0 WHERE terminal_id = :OLD_terminal_id;');
MyQuery.SQLUpdate.Add('UPDATE terminals SET terminal_requiresnewregistration = 1 WHERE (terminal_machineid = :terminal_machineid) AND (terminal_id :OLD_terminal_id);');

It seems to work flawlessly on a MySQL server 5.0.41. I'm just not sure if there are any side effects which I should be aware of...

Thx in advance

Bernd

Yes it is possible. But you should set TMyQuery.Options.StrictUpdate to
False.

i used to execute multiple UPDATE or INSERT queries without StrictUpdate and have no problems. why?

ben wrote:i used to execute multiple UPDATE or INSERT queries without StrictUpdate and have no problems. why?

If StrictUpdate is on and the last insert/update statement affects more than ONE row (RowsAffected > 1) you will get an exception.

Setting StrictUpdate=False disables this "more-than-one-row-affected" check.

You are right, but I should add that StrictUpdate mode checks whether the affected rows count equals to one. You have missed the case when the affected rows count is less than one.