I neglected to say how to use the server defined defaults from the schema
cache. You set the IB_Query property GetServerDefaults to true.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of IBO Support List
Sent: 15 November 2012 04:26 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Domain default not being applied in IBOquery, Append, in
IBO 5 beta

There have been some changes in things that will have an influence on server
defined default values. Those values are only applied if the column is not
included in the insert SQL statement. I changed the default behaviour of the
statements that are generated for you automatically. PreparedInserts will
render better overall performance, but it will require all columns be a part
of the prepared INSERT statement, which negates the possibility of the
server defined defaults from being applied.

I suggest you not make server defined defaults something to rely upon for
client interfaces where you are not 100% in control of the INSERT statement.

You can also have IBO put the server defined defaults in the SchemaCache and
they will get applied on the client when the record is taken into insert
mode, which obviously will have it included when the value is posted to the
server.

Jason