Add-Ons & Services

Datetime data type error

Please post support and help requests here.

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: 16
Joined: 09 Jun 2009, 09:06
Location: Kyrgyzstan, Bishkek

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.
Posts: 1158
Joined: 11 Jul 2006, 16:27
Location: United_States

Return to Support

Who is online

Users browsing this forum: No registered users and 3 guests