Hi Tek,
ODBC driver don't know convert empty VFP date to .NULL. value
- Field in table must set Allow Null values.
Using with SPT:
ldDate=.NULL.
?SQLEXEC(lihdbc,"UPDATE XXT000 SET Field_Date=?ldDate")
Using with remote view:
SELE remote_view_alias
RELACE field_date with .NULL.
?TABLEUPDATE()
MartinJ
>Hi all
>
>Would greatly appreciate if anyone has a solution to display blank dates correctly in VFP when the date in MSSQL is NULL?
>
>In addition how could we send a NULL date back to MSSQL when a date textbox shows blank date?
>
>Thanks & Best Regards
