Subject | Inserting into an empty dataset |
---|---|
Author | tickerboo2002 |
Post date | 2002-11-14T17:41:11Z |
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
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