This may answer your question:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q157424&However it may depend on your gnSatHandle details.
>Hi All,
>
>I am trying to do the following query:
>
>lcSqlStatement = "SELECT PROJ_SEQ_WO.proj_no, " + ;
> " PROJ_SEQ_WO.proj_cat_no, " + ;
> " PROJ_SEQ_WO.wo_no, " + ;
> " PROJ_SEQ_WO.seg_no, " + ;
> " PROJ_SEQ_WO.seq_no, " + ;
> " {} AS close_dt, " + ;
> " {} AS po_dt, " + ;
> " 1 AS travel_ctg " + ;
> "FROM main_one!PROJ_SEQ_WO " + ;
> "WHERE ALLT(PROJ_SEQ_WO.user_wo_no) = '" + lcUserProjNo + "' "
>
>lnConHndl = sqlexec(gnSatHandle, lcSqlStatement, 'temp_cursor')
>
>I get 12/30/1899 for both date fields I am creating. What I'd like is NULL instead of an empty date. But I can't seem to create the fields as NULL.
>
>I am using VFP6 SP5. The database is a standard VFP '.dbc'
>
>TIA
>Mike