>>SQL Server does not understand empty dates - make them null.
>>
>yeah. Tried that
>
>SQLPREPARE(gnhandle,"update vizkeys set date_used='.NULL.' where date_used<>'.NULL.' ","real")
>
>with and without quotes around the the .NULL.
>
>both rejected. How are we supposed to do it?
Try no quotes and no periods arount NULL.
Mark McCasland
Midlothian, TX USA