>> > Hello,
>> >
>> > I have a problem in Informix that I need to solve.
>> >
>> > I have table
>> >
>> > Table ABC
>> > {
>> > Field1 integer,
>> > Field2 char(5),
>> > Insdate integer
>> > }
>> >
>> > What I want now is when an insert occurs on this table on the fields
>> > (Field1 and Field2) that afterwards the fields Insdate is filled
> with
>> > the date of today but stored as a number in the format YYYYMMDD.

Why? Why not just keep the fricking date?

>> > Example:
>> >
>> > Insert into ABC (Field1, Field2)
>> > values (1, "Wim");
>> >
>> > then should the query
>> >
>> > Select * from ABC;
>> >
>> > return:
>> >
>> > Field1 Field2 Insdate
>> > 1 Wim 20051027
>> >
>> > My collegue found how to do it in Oracle and now I want to prove it
> also
>>
>> > can be done in Informix. I hope. Else me and my big mouth :-)
>> >
>> > So help me please.
>> >
>> > Thanks,
>> >
>> > Wim
>> sending to informix-list
> sending to informix-list
>


--
Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule"
- Coluche

"You are an index and a prologue to the history of lust and foul thoughts."
- William Shakespeare
sending to informix-list