Insert date problem.

[RHudgins@GENENCOR.COM]

I am having the following problem.

Table A
      key 1 = 'A'
      Date1   =  Null
      lots of other fields

I want to  create a duplicate record of the record in table A but with a
new key value,  so in my sqr  I do the following

begin-select
key1
date1
from tableA a
end-select

begin-sql
insert into tableA
(key1
,date1
, lots of other fields)
values
('B'
, &a.date1
,&a.lots of other fields)
end-sql

The coding works fine, but when I look at the new record the date1 field is
now =  01-JAN-1899
In the original record the date1 field is a null.

I am using SQR v6.1.4  with an Oracle 8.1.7 database.

Has anyone else had this problem?

I would appreciate any ideas.

Thanks!

Rhonda Hudgins
@}---'----,----
Genencor International, Inc
585/256-5266
rhudgins@genencor.com