Will you please send me a working sample app so that I can see your issue
first-hand?

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of ming
Sent: 31 January 2012 04:00 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Default values not defaulting for some field

hi all

my problem for default value still error in ibo even i use the newest ibo,
any sugestion for my problem?

because the trigger can be alternative but i think not eficient for every
table i must add before insert for 1 field only type data varchar.

Need solution, any body help me please...

--- In IBObjects@yahoogroups.com, "ming" <ming2_id@...> wrote:
>
> hi
>
> i have a some field with set default value, like :
> LAST_UPDATE TIMESTAMP_1 DEFAULT current_timestamp NOT NULL
> LAST_USER VARCHAR30 DEFAULT current_user NOT NULL
>
> i test with ib_expert to add new record, the default value field run
corectly.
>
> but when i develop with ibo 4.9.14 36, + delphi 2010
> getserverdefault=true
> the result last_update is corectly
> but the last_user is always null VALUE
>
> Is there another way to get the value of default server ?
>
> i try open dialog ib_query in tab fields says:
> last_update (timestamp) TIMESTAMP /* dv=current_tempstamp */
> last_user (vartext) varchar(30) /*cs=NONE */ /*dv=current_user */
>
> i think the difference cs=NONE. whats its mean cs=None ?
>
> thanks
>
> ming2