Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date default value in sqlserver
Message
From
07/09/2007 15:26:27
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
07/09/2007 13:02:39
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01253060
Message ID:
01253104
Views:
25
>i use sqlserver 2000 and i noticed that when date is empty, sqlserver fills it with 01/01/1900
>how to have vfp " / / " empty date when receving datas from sqlserver ?

Assuming you're using SPT or readwrite views:

Blank fields mydate where mydate={^1900-01-01}

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform