>In Ms Sql Server, what is the value to put for empty date?
>
>In VFP, we put UPDATE stock SET receivedOn = {}
>
>But in Ms Sql, it seem did not work.
>
>TIA.

There is no "Empty Date" concept in MS SQL Server. There is DATETIME and SMALLDATETIME, storage type of 2-byte and 4-byte integers respectively.

They can either have value or not (NULL or Valid date).

As far as Mapping to FoxPro is concerned, they always map to DATETIME FoxPro type and if you update RemoteView column with {} you will end up with date value of "01/01/1900" or "31/12/1899" (depends on other vfp and SQL settings)


Cheers,

Zoran