Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data fetching through ODBC
Message
From
04/05/2001 10:02:15
 
 
To
04/05/2001 07:50:59
Rakesh Pahwa
Symco Software P. Ltd.
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00503404
Message ID:
00503471
Views:
20
>If i am fetching data through ODBC from any Back-End including VFP itself, if date field in Back-End table is null or blank , then it should return the cursor having date field blank but it returns with date as 30/12/1899 which is absurd.
>
>Kindly help me.
>
>Regards,
>
>Dilip.

Is that a date coming from an Access database? Most probably yes. You would get the same "empty" date value if you try to pass an uninitialized date var from a VB/VBA app to a VFP app.

It's just another annoyance that you have to deal with when trying to build a generic data access tool.
Previous
Reply
Map
View

Click here to load this message in the networking platform