Exception after insert

[FerCastro]

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

[Jackson]

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.

[FerCastro]

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;

----

[Jackson]

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;

[FerCastro]

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