Subject RE: [IBO] Default value X Query Insert
Author Norman Dunbar

you have been 'gotchad' by the client - not the server.

To fix it, do this :

in the IDE, double clik on the query
in the property editor that comes up, click on the columnattributes tab.
You should see that 'Required' is ticked - clear it.

Recompile and try gain.

The problem is that the Client has been 'told' that the field is required,
so expects you to put a value in it. The default will be applied at the
server after a post, but because the post never gets there - due to the
required flag - it cannot be applied.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
Tel: 0113 289 6265
Fax: 0113 289 3146

-----Original Message-----
From: emgfyah2002 [mailto:edison@...]
Sent: Tuesday, April 09, 2002 1:49 PM
Subject: [IBO] Default value X Query Insert

Using Firebird and IBO 4Gc. If I try to make a IB_Query insert in a
table that have fields like that:
field1 integer default 10 not null,
and do not use a specific instruction like:
table1.fieldbyname('field1').value := 10;
to send a value to this field am I getting an error, informing that
field1 needs a value!
It apears that the default value are not working or something else is
missing. Where are my error ?
Thank you

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to

This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.