Message: Cannot retrieve ResulSet Data

[chuckie]

Hi everybody,
Why does my Delphi7 application,
after a regular append to a table

ZTfoo1.append;
Ztfoo1.FieldByName('text').Value:= EdPN.Text;
ZTfoo1.Post;

and an Insert


INSERT INTO foo2 (id,text) VALUES(LAST_INSERT_ID(),'text');

show the message
Cannot retrieve ResultSet Data, if queries work well and I obtain that I expected?

Thank you in advance
ciaoooo

[tygrys]

Maybe you should use ExecSQL intead of an Open in the "Insert...." Query.

tygrys

[chuckie]

so easy?
thank you tygrys, you were right.
works!