Datetime data type error

Please post support and help requests here.
Posts: 16
Joined: 09 Jun 2009, 09:06
Location: Kyrgyzstan, Bishkek

Datetime data type error

Postby crioto » 26 Jun 2009, 06:59

Look's like a bug, or i don't know something?
When using Poco::Data::ODBC
I have an Sql Server located table with more them 20 columns.

i use this code

Code: Select all

Poco::Data::Statement mState(mCore->getPool().get());
mState << "SELECT * FROM MyTable";

And it's fail. I have these error bad data format: unsupported data type
When i use native columns name ignoring columns with DATETIME - it's work well, e.g.:

Code: Select all

SELECT notDatetimeCol1, notDatetimeCol2, ..., notDatetimeColN FROM MyTable

Posts: 1375
Joined: 11 Jul 2006, 16:27
Location: United_States

Re: Datetime data type error

Postby alex » 26 Jun 2009, 19:13

1.3.x does not support DateTime binding. The support has been introduced in the current development code. Convert your DateTime to string within SQL to work around it.

Return to “Support”

Who is online

Users browsing this forum: No registered users and 2 guests