Overview
Features
Download
Documentation
Community
Add-Ons & Services

Datetime data type error

Please post support and help requests here.
crioto
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";
mState.execute();

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

alex
Posts: 1212
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