<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body>
<div dir="ltr">
<div>
<div dir="ltr">Although i don’t know that package well<span> enough to say how to do it, i can tell you the correct way to fetch column information is to call
<span id="ms-outlook-ios-cursor"></span>SQLColumns (<a rel="noreferrer noopener" href="https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlcolumns-function?view=sql-server-ver16">https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlcolumns-function?view=sql-server-ver16</a>).
Note that current Cuis odbc package is very old and maybe uses the v1 calls. I'm not sure how or if that would affect things. <span></span></span></div>
</div>
<div dir="ltr"><span><br>
</span></div>
<div dir="ltr"><span>Jon </span></div>
<div dir="ltr" id="ms-outlook-mobile-signature">
<div dir="ltr"></div>
</div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Cuis-dev <cuis-dev-bounces@lists.cuis.st> on behalf of Mark Volkmann via Cuis-dev <cuis-dev@lists.cuis.st><br>
<b>Sent:</b> Monday, November 4, 2024 8:17:42 PM<br>
<b>To:</b> Discussion of Cuis Smalltalk <cuis-dev@lists.cuis.st><br>
<b>Cc:</b> Mark Volkmann <r.mark.volkmann@gmail.com><br>
<b>Subject:</b> [Cuis-dev] DatabaseSupport ODBC and getting table schema info</font>
<div> </div>
</div>
<div>
<div dir="ltr">I've been searching the code for the ODBC package and haven't found a way to get information about the columns in a given table including their names and data types. I can get that from a row from a result set, but I don't see a way to do it
for an empty table. Am I overlooking it?<br clear="all">
<div><br>
</div>
<span class="x_gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="x_gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div><font face="arial, helvetica, sans-serif">R. Mark Volkmann</font></div>
<div><span style="font-size:12.8000001907349px"><font face="arial, helvetica, sans-serif">Object Computing, Inc.</font></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>