<div>
How would you do a numeric value? &nbsp;I understand the char but not quite sure about the number.<br />
. <br />
SQLBindCol( hStmt, 2, SQL_LONG, &amp;nCount, 0, NULL ); <br />
SQLFetch( ... ); <br />
<br />
Thanks<br />

</div>


How would you do a numeric value?  I understand the char but not quite sure about the number.
.
SQLBindCol( hStmt, 2, SQL_LONG, &nCount, 0, NULL );
SQLFetch( ... );

Thanks


<div>
<div class="content wysiwyg-content">
I would like to create a function like this which works on sql api:<br />
<br />
char szName[10];<br />
int nCount;<br />
<br />
...<br />
SQLBindCol( hStmt, 1, SQL_C_CHAR, szName, sizeof( szName ), NULL );<br />
SQLBindCol( hStmt, 2, SQL_LONG, &amp;nCount, 0, NULL );<br />
SQLFetch( ... );<br />
<br />
The variables szName &amp;&nbsp;nCount is not assigned until SQLFetch() is called. &nbsp;How is the function able to send this values back to me? &nbsp;Can someone write a small sample for the two on how it does this.<br />
<br />
Thanks
</div>
</div>


I would like to create a function like this which works on sql api:

char szName[10];
int nCount;

...
SQLBindCol( hStmt, 1, SQL_C_CHAR, szName, sizeof( szName ), NULL );
SQLBindCol( hStmt, 2, SQL_LONG, &nCount, 0, NULL );
SQLFetch( ... );

The variables szName & nCount is not assigned until SQLFetch() is called.  How is the function able to send this values back to me?  Can someone write a small sample for the two on how it does this.

Thanks

How to return these variables

C is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations. By design, C provides constructs that map efficiently to typical machine instructions, so it has found lasting use in applications that had formerly been coded in assembly language, including operating systems as well as various application software for computers ranging from supercomputers to embedded systems. It is distinct from C++ (which has its roots in C) and C#, and many later languages have borrowed directly or indirectly from C.