Devart Forums

Hello friends,

After i execute one query for insert i get the next exception message:

"Query must return exactly one result set - use Execute"

Does anybody knows hy this message? What am i doing wrong?

Best Regards

Fernando Castro
México DF

Probably you are trying to use the TDataSet.Open method or the TDataSet.Active property to execute the INSERT statement.
You should use the TCustomDADataSet.Execute method instead.

I show my code,

Please if you see anything wrong let me know. The record is written in the table but i get the error message.

Best regards!

----

DM.QEdita388.SQL := cCadena;
DM.QEdita388.Active:= TRUE;
DM.QEdita388.Execute;

----

There is no need to set TDataSet.Active property to True. Just remove the following code from your example and try again:
DM.QEdita388.Active:= TRUE;

Thanks a lot for your help. I did what you said and after the change the code is working great.

Thanks

Fernando Castro
Mexico DF