Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fun with SQL Server
Message
From
12/01/1999 15:45:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Fun with SQL Server
Miscellaneous
Thread ID:
00175227
Message ID:
00175227
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform