Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty Date Value
Message
De
17/11/1999 14:32:33
 
 
À
17/11/1999 10:58:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00291919
Message ID:
00292066
Vues:
62
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform