Page 1 of 1

Message: Cannot retrieve ResulSet Data

Posted: 16.01.2006, 16:38
by 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

Posted: 17.01.2006, 18:09
by tygrys
Maybe you should use ExecSQL intead of an Open in the "Insert...." Query.

tygrys

Posted: 18.01.2006, 11:22
by chuckie
so easy?
thank you tygrys, you were right.
works!

:oops: