Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOLEDB Bug or ?
Message
From
22/02/2010 08:00:59
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
21/02/2010 10:09:31
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01449715
Message ID:
01450192
Views:
66
>Cetin,
>
>The datetime value is passed as a double
>If you assign eg 123.45 to loParm.Value and then print loParm.Value, you will see a datetime
>
>Where does it go wrong ? Maybe the format of the double - such that adob thinks that the fractional part ( the seconds ) is invalid en hence zero

Hi Gregory,
I know that internally it is a double but setting it to a double or datetime set the value with time portion, still dropping the time portion in update/inserting into VFP:

loParm.Value = Datetime()
? '1',loParm.Value
loParm.Value = (DATE()-DATE(1899,12,30))+((DATETIME()-CAST(DATE() as datetime))/86400)
? '2',loParm.Value

Both print the same datetime value and both end up with time portion dropped in VFP.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform