Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fun with SQL Server
Message
De
12/01/1999 15:45:05
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Fun with SQL Server
Divers
Thread ID:
00175227
Message ID:
00175227
Vues:
56
Hi All ---

Ran into an interesting problem (I should have known better but that's another story)....if you attempt to post blank dates via a remote view to SQL Server, you get 01/01/1900 as the return date value. Not so nice, eh?

The trick is to set the column in SQL Server to allow Nulls and then post a null instead of a blank...of course, you also have to be prepared to accept nulls for databound controls.

Thought I would share this.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform