You can also just call Prepare and then Insert without opening a dataset.
You would want to close and open eventually to see the records however.

Jason Wharton
CPS - Computer Programming Solutions
Mesa Arizona
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "tickerboo2002" <support@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 14, 2003 4:17 AM
Subject: [IBO] Inserting with a TIB_Query


> A simple one this:
>
> In the IDE, I normally use the query editor to set the SQL, Key
> Links, Generator Links and the IUD SQL.
>
> I then Prepare, Open and test for Eof. i.e. I normally select some
> records before I do an insert.
>
> How would I insert using a TIB_Query without first calling the SQL?
> It's likely I'd want to insert, update and then delete the same row
> before I commit or rollback.
>
> Do I just call Prepare, Open and then Insert?