At 07:38 AM 07-11-01 -0200, you wrote:

>Hi all,
>
>
>I am using TIBOQuery and would like to know if may use default values in
>IBO. How to do it?
>
>I have some columns that not permit nulls, and I want to initialize then
>automatically on every insertion.

The most efficient way to do it is just to get hold of your database script and then open the DefaultValues stringlist of your TIBODatabase in the Object Inspector. Make entries like this:

TABLEA.FIELD1='T'
TABLEA.FIELD10='GINGERBREAD'
TABLEB.FIELDC=''
TABLEB.FIELDG=NOW
...
...

IOW, cover the whole lot in one hit and never have to worry about them anywhere in the datasets.

Make sure there are no blank spaces either side of the "=" sign.

Regards,
Helen

>[]s,
>
>Adriano
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________