Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty Date Value
Message
From
17/11/1999 14:32:33
 
 
To
17/11/1999 10:58:01
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00291919
Message ID:
00292066
Views:
64
Dan,

>What is the proper syntax to specify an empty date value for a default value for SQL Server 7.0 datetime fields?

SQL Server doesn't support an empty datetime in same sense that VFP does. If you set a SQL Server datetime datatype to "empty" you'll end up with a Jan 1, 1900 value. If it truly has to be unknown, you're best bet is to use NULLs.

>Why can't I edit the values on my VFP forms if the SQL Server values are NULL? BTW, this problem occurs with ALL of my field types.

That's a good question. Are you using remote views? Can you create a test using the VFP base form and edit the data?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform