Hi,

There is no "empty date" concept in SQL Server. I would modify the table to

accept nulls in that column.

Hope this helps.

----- Original Message -----

From: "Ailsom F. Heringer (Osklen)" <ailsom@osklen.com.br>

To: <profoxtech@leafe.com>

Sent: Wednesday, April 27, 2005 11:16 PM

Subject: Empty DATETIME column being saved with "1900-01-01 00:00:00"

I have a datetime column in a SQLSERVER table, opened via CursorAdapter in

VFP8. At a form, when I append a record, this column is saved with

"1900-01-01 00:00:00" even if the textbox control is empty.

There is no default value at the design of the column.

Any idea of what is happening?

Ailsom F. Heringer

ailsom@osklen.com.br

Analista de Sistemas

------------------------------------------

Osklen

Departamento de Informática

http://www.osklen.com.br

55 21 22198979

--

No virus found in this outgoing message.

Checked by AVG Anti-Virus.

Version: 7.0.308 / Virus Database: 266.10.3 - Release Date: 25/4/2005