Home
News
Blogs
Jobs
About Us
Contact Us
Products
AnyDAC
SimpleIAX
Discontinued
FreeDAC
NCOCI8
Shop
AnyDAC
SimpleIAX
Services
Download
AnyDAC
SimpleIAX
Other
Discontinued
FreeDAC
NCOCI8
Support
Forums
FAQ
AnyDAC
NCOCI8
Search
Map
Customers
Additional
AnyDAC
SimpleIAX
Forums
Categories
Rules
Welcome,
Guest
Please
Login
or
Register
to post messages.
Lost Password?
Forums
AnyDAC
AnyDAC General English
SQLite datetime
(1 viewing) 1 Guest
TOPIC:
SQLite datetime
Forum Tools
Post New Topic
Pdf
Show latest posts
Rules
#20058
zsleo
Fresh Boarder
Posts: 17
Karma:
0
SQLite datetime
2012/02/03 03:16 (3 Months, 2 Weeks ago)
IN a SQLite DB I have a field with data type of real that will store a datetime value.
I need to copy data from MS SQL datetime field but some times the value may be null.
I also want to display the SQLite field in an InfoPower DB DateTimePicker component.
When the InfoPower DB DateTimePicker is displayed at run time I get the following error:
"Cannot access field 'LastConnected' as type dattime"
Please advise a solution...
TIA
Logged
The administrator has disabled public write access.
#20059
Support
Moderator
Posts: 4708
Karma:
68
Re:SQLite datetime
2012/02/03 06:03 (3 Months, 2 Weeks ago)
Hello
You should set connection definition parameter:
Code:
DateTimeFormat=Binary
More about that:
www.da-soft.com/anydac/docu/Connect_to_SQLite_database.html
With best regards,
DA-SOFT Technologies Support Team
Logged
Last Edit: 2012/02/03 06:04 By Support.
The administrator has disabled public write access.
Forum List
AnyDAC
AnyDAC General English
Board Categories
AnyDAC
... AnyDAC Основной Русский
... AnyDAC Beta English
ThinDAC
... ThinDAC General English
... ThinDAC Основной Русский
SimpleIAX
... SimpleIAX General English
... SimpleIAX Основной Русский
FreeDAC
... FreeDAC General English
... FreeDAC Основной Русский
NCOCI8
... NCOCI8 General English
... NCOCI8 Основной Русский
Nontechnical
... Jobs
... Unsorted
Powered by
Kunena