Subject TIBOQuery.insert() without open() ?
Author sugi
Dear All,

Is there a way to insert a record into a TIBOQuery without having to
call 'open()' first? I'm asking because I'm trying to decouple a 'data
browsing' form and a 'data entry' form in delphi.

For a standard order table, for example, the 'data browsing' form will
need some data from other tables, i.e. customer name, customer address,
etc, so the sql will involve a join. OTOH, a 'data entry' form's sql is
usually only 'select * from table', so I'm thinking of separating the
sql into two TIBOQuery.

Now imagine a 'data entry' form connected to a 'select * from table'
query. To do any inserts using data aware components I have (?) to call
open() first, and then proceed with calling append() and post() later.
The problem is that the 'data entry' form doesn't need to actually
'fetch' any data from the select statement, I'm just using the 'select'
to let the TDataset sort out the metadata. I think this is a waste,
hence my question above.

Thanks in advance,
sugi.