Filemaker 7 ODBC Select

Hi all,

After getting my code working with FM 6 and ODBC, i'm now trying to
update my database code to talk to FM 7. I'm having a weird problem
with a date field though.

I can insert a date using a query like so:

INSERT INTO FMTable( Text1, Amount, Time1, Date1, Text2 ) VALUES( 'text
235', 235.325, { T '11:23:22' }, { D '2005-04-03' }, NULL )

Time1 being a Time, and Date1 being a date field..

The problem is when i attemp to update Date1; it updates, but when its
read back, it comes as a null.

any ideas?

Thanks
Andy

.