Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help, please - OLEDB for ODBC driver error.
Message
From
20/11/2001 03:37:10
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00583562
Message ID:
00583788
Views:
44
>Thanks All for your replies.
>I solve the problem!
>
>The thing was in the date field.
>I create a new field as string in the table and a trigger for update that fills the original date field using CTOT function.

Esteban,
I would come to this point :) CTOT is dangerous IMHO. Instead :

transform(ttoc(ltDateTime,1), '@R 9999/99/99 99:99:99')

or for a date :

transform(ttoc(dtot(ldDate),1), '@R 9999/99/99 99:99:99')

provide needed ODBC canonical format. It's free from any century, set date etc settings which might affect CTOT.
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
Next
Reply
Map
View

Click here to load this message in the networking platform