[vtkusers] vtkODBCQuery::NextRow() does not supported SQL_DECIMAL/SQL_NUMERIC column types in VTK 5.8.0

[Dorum Henry (Nokia-LC/Chicago)]

VTK version: 5.8.0
Language: C++
Platform: Windows 7, 32 bit

I'm trying to access numeric data from an Oracle database using vtkODBCQuery (with the DRIVER={Microsoft ODBC for Oracle}). However for columns with data type NUMBER(10,0) i.e. of type SQL_DECIMAL, the returned vtkVariant object is invalid for NUMBER(10,0) column types from the query->NextRow()call. Stepping though the VTK code I discovered that while caching the row, for the SQL_DECIMAL column types (and same behavior for CacheNumericColumn, CacheTimeColumn, CacheIntervalColumn) the vtkODBCQuery instantiates an empty vtkVariant object without any code body to call SQLGetData to retrieve data:

bool
vtkODBCQuery::CacheDecimalColumn(int column)
{
  this->Internals->CurrentRow->SetValue(column, vtkVariant());
  this->SetLastErrorText(NULL);
  return true;
}

Any solutions or help in resolving this quickly is appreciated, thanks!

-Henry





________________________________
The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender and delete/destroy the original message and any copy of it from your computer or paper files.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.vtk.org/pipermail/vtkusers/attachments/20120315/dd607db5/attachment.htm>