At 04:40 AM 22/10/2006, you wrote:

>Using data aware controls, I want to insert a new record without first
>bringing back the others. What's the best way to accomplish this? I
>thought about using a query with a parameter and setting the parameter
>value to a value that doesn't exist, then calling "insert". Is there a
>better way?

My typical "Load a record" form consists of TIB_ controls and
selectors, while behind the form is a parameterised INSERT statement
or executable SP statement in a TIB_DSQL object. Each control is
linked to the respective parameters via the ParamName property. A
"Go" button executes the statement and a Cancel button clears
everything. That's the only code I have to write. It is lightweight
and lightning fast.

Most of the TIB_ controls have this capability - look up the
ParamName keyword in the help for the comprehensive list.

Helen