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