Subject Inserting into an empty dataset
Author tickerboo2002
My TIB_Query component has the following SQL

Select *
from table
where id=:id

and the UpdateSQL has the usual Insert/Update/Delete sql.

I want to have a dialog box with just the one TIB_Query component to
handle retrieving/updating an existing record and allowing the user
to insert a new record.

Do I have to execute the above sql to get an empty dataset so that I
can do an Insert? Or, can I somehow call the Insert SQL to create a
dataset containing the new row? Or, (nearly finished) should I just
have another component handle the insertion?

TIA

David