It is a server database. I am buffering a remote view of the remote table.
The field is set to accept nulls in the remote view.
I do need to upgrade to SP3.
>>I don't have SP3 (yet)
>>
>>It only happens when I tableupdate(0) into the server.
>>
>>My program does:
>>mydate = .null.
>>insert into tablea from memvar
>>tableupdate(0)
>>
>>(this is just the relevant commands, there is a lot more to it, but I can throw a C5 error with the above code.)
>
>Hmm. I can't get to the TABLEUPDATE() part. When I issue the INSERT INTO TABLEA FROM MEMVAR, I still get the error message that the field does not accept nulls. You mentioned ODBC. Is this a backend server you're inserting into, or a local table? My testing has been done only on a local table. Otherwise, I'd say that you need to go and upgrade to SP3 ASAP.< g >
--Todd Sherman
-Wake Up! Smell the Coffee!