Subject Re: default values of "Table" not used when field is present in your IBO insert Query
Author Ryan Nilsson-Harding <nilsson@bigpond.ne
--- In IBObjects@yahoogroups.com, "wayne" <waynef@w...> wrote:
> I have found the following to be strange , to me it is a "GOTCHA".
>
> I have default values in my "table" that are not geting there
default
> value when I insert values via IBO. I noticed that I had to remove
the
> field from my IBO queries ("insert") to be able to make use
> of the "table" definition of default values.
>
> Is this supposed to be like this.

Hi Wayne.
Yes,

There are two options.
Either enter the default value you want under the 'Field Properties'
page of the TIB_Query properties for the relevant field, or set the
property GetServerDefaults to true in the query properties.

-Ryan