Devart Forums

how can i execute the Insert statement and update statement in the same datesat simultaneously.

the code like----------
insert into XX() values();

update XX set y = :y
where xxx;
------------------------

You can set the UnpreparedExecute option of TPgQuery to True to use several statements in one query.

UnpreparedExecute is set to true.
this time the result only process the last statement if it is true else
error occurred....like that
"Update failed. Found 0 records" .

means that the first statement is not processed.

any other suggestion that can process all statement in the dataset?

The error "Update failed. Found 0 records" is generated by PgDAC. This error does not mean that the first statement is not processed.

PgDAC raises this error if RowsAffected = 0 after executing your query. You should check your database to learn if a row was inserted. RowsAffected can be zero because your query contains several statemens but query is executed successfully. In this case you can set the StrictUpdate option of TPgQuery to False to disable checking for RowsAffected.

Thx guy.