<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">VTK version: 5.8.0<o:p></o:p></p>
<p class="MsoNormal">Language: C++<o:p></o:p></p>
<p class="MsoNormal">Platform: Windows 7, 32 bit<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m trying to access numeric data from an Oracle database using
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">vtkODBCQuery</span> (with the
<span style="font-size:10.0pt;font-family:"Courier New"">DRIVER={Microsoft ODBC for Oracle}</span>). However for columns with data type NUMBER(10,0) i.e. of type SQL_DECIMAL, the returned
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">vtkVariant</span> object is invalid for NUMBER(10,0) column types from the
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">query</span><span style="font-size:10.0pt;font-family:"Courier New"">-><span style="color:#010001">NextRow</span>(<span style="color:#010001">)</span></span>call. Stepping though the VTK
code I discovered that while caching the row, for the SQL_DECIMAL column types (and same behavior for
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">CacheNumericColumn, CacheTimeColumn, CacheIntervalColumn</span>) the
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">vtkODBCQuery</span> instantiates an empty
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">vtkVariant</span> object without any code body to call
<span style="font-size:10.0pt;font-family:"Courier New";color:#010001">SQLGetData</span> to retrieve data:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:blue">bool<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:#010001">vtkODBCQuery</span><span style="font-size:10.0pt;font-family:"Courier New"">::<span style="color:#010001">CacheDecimalColumn</span>(<span style="color:blue">int</span>
<span style="color:#010001">column</span>)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">{<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">
<span style="color:blue">this</span>-><span style="color:#010001">Internals</span>-><span style="color:#010001">CurrentRow</span>-><span style="color:#010001">SetValue</span>(<span style="color:#010001">column</span>,
<span style="color:#010001">vtkVariant</span>());<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">
<span style="color:blue">this</span>-><span style="color:#010001">SetLastErrorText</span>(<span style="color:#010001">NULL</span>);<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">
<span style="color:blue">return</span> <span style="color:blue">true</span>;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">}<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><o:p> </o:p></span></p>
<p class="MsoNormal">Any solutions or help in resolving this quickly is appreciated, thanks!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Henry<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">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.<br>
</font>
</body>
</html>