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

Have you looked at the values via Enterprise Manager? IIRC, VFP displays

a blank SQL date with that value but it's not really stored that way in

the back end.

Ailsom F. Heringer (Osklen) wrote:

>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?

>

>

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

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

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

On Wed, 27 Apr 2005 23:31:04 +0300, you wrote:

>Hi,

>

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

>accept nulls in that column.

>

>Hope this helps.

Welcome to the list Griggie...

A+

jml