Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPOLEDB Bug or ?
Message
De
22/02/2010 08:00:59
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
21/02/2010 10:09:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01449715
Message ID:
01450192
Vues:
67
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform