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

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

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