Subject Re: [IBO] Insert new record without bringing back others
Author ra8009
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> 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
>

Thank you