Additional
AnyDAC
SimpleIAX
Forums
Welcome, Guest
Please Login or Register to post messages. Lost Password?
SQLite datetime
(1 viewing) 1 Guest
Go to bottom
TOPIC: SQLite datetime
#20058
zsleo
Fresh Boarder
Posts: 17
graphgraph
Karma: 0
User Offline Click here to see the profile of this user
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 Logged
The administrator has disabled public write access.
#20059
Support
Moderator
Posts: 4708
graph
Karma: 68
User Offline Click here to see the profile of this user
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 Logged
Last Edit: 2012/02/03 06:04 By Support.
The administrator has disabled public write access.
Go to top