[Cuis-dev] DatabaseSupport ODBC and getting table schema info

[Jon Raiford]

Although i don’t know that package well enough to say how to do it, i can tell you the correct way to fetch column information is to call SQLColumns (https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlcolumns-function?view=sql-server-ver16). 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.

Jon
________________________________
From: Cuis-dev <cuis-dev-bounces at lists.cuis.st> on behalf of Mark Volkmann via Cuis-dev <cuis-dev at lists.cuis.st>
Sent: Monday, November 4, 2024 8:17:42 PM
To: Discussion of Cuis Smalltalk <cuis-dev at lists.cuis.st>
Cc: Mark Volkmann <r.mark.volkmann at gmail.com>
Subject: [Cuis-dev] DatabaseSupport ODBC and getting table schema info

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?

--
R. Mark Volkmann
Object Computing, Inc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.cuis.st/mailman/archives/cuis-dev/attachments/20241105/8c3daff7/attachment.htm>