Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
ODBC
 |
- !!NEWSFLASH!!
- 1437 or 3437 Extender Load Error
- 3132 error when using DAO
- 521 Attribute string too long
- Access SQL Update
- An SQL Tutorial
- Automated ODBC Data Source creation
- Calling a MS SQL Server 2000 Stored Procedure
- Change database then Update then count rows
- Compact an Access Database
- COMPACT_DB and Password MDB Files
- Continue a SQL Query after a Warning Message from Driver
- Create a System DSN for a TXT File Problem
- Create an SQL DSN with User name and Password
- DSN Connection Strings
- Execute an Oracle stored procedure
- Explanation of ODBC Usage
- Get Installed Driver Information
- Get Parameters from a Stored Procedure
- How Does qBindCol Work
- How to Do a Simple Sql Query
- Invalid Cursor State Error
- MDAC Invalid Object
- Microsoft SQL Server ODBC driver Info
- More on How ODBC Works
- ODBC and Services
- ODBC and SQL
- ODBC DSN Maker
- ODBC DSN Port Configuration
- ODBC Extender with WebBatch problems
- ODBC on 64 bit System
- ODBC SQLDescribeCol Example
- ODBC WHERE Syntax Blank Data
- Pervasive SQL Syntax Error
- Problem Adding System DSN for SQL Server
- Problem Using qConfigData with the Oracle ODBC Driver
- qConnect Crashes with Exit Code -1073741571
- qExecDirect and SQL Questions
- QExecDirect Second handle issue with SQL Server Drivers
- qFetch with Empty Cell
- qFetch with qBindCol and qGetData
- qGetData 50 columns limit
- qLastCode to Check these SQL Return Codes
- Read Information from Lotus Notes
- Retrieving data after a SQL JOIN
- Return Codes in ODBC Extender
- s0022 error from SQL Server Driver
- Specify SQL Server Password in qConfigData
- SQL Server SELECT SUM Statement
- SQL SUCCESS WITH INFO
- Syntax for Insert Into Access
- Updating ODBC.INI File over the Network
- Using WildCards in an ODBC SQL Statement
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
ODBC SQLDescribeCol Example
Keywords: ODBC SQLDescribeCol Example
#DefineFunction udfBinary32Parameter(value) x=BinaryAlloc(32) ; Get some space BinaryEODSet(x,32) ; Set EndOfBuffer BinaryPoke4 (x,0,value) ; Poke the wanted value at the first place Return x ; Return with Bufferaddress #EndFunction #DefineFunction odbcColNames(hstmt) ; Gets the names of all Columns of an Sql-Statement as a Tab-seperated List. ResultList="" numcols = qNumRsltCol(hstmt) ;How many Columns do we have cDLL = qSpecial(1,0,0,0,0) For ColNr=1 to numCols ;Look at every Col handle = qSpecial(2,hstmt,0,0,0) ;long:handle, = true statement handle ; ColNr by for-loop ;long:nCol, = column number cColName = BinaryAlloc(128) ;lpbinary:cColName, = string to return Column Name ; fix 128 ;long:128, = Maximum length of Column Name nLength =udfBinary32Parameter(0) ;lpbinary:nLength, = Actual length returned nColType =udfBinary32Parameter(0) ;lpbinary:nColType, = Column Type, i.e. 1=SQL_CHAR nColDef =udfBinary32Parameter(0) ;lpbinary:nColDef, = Precision or Size of Data nColScale=udfBinary32Parameter(0) ;lpbinary:nColScale, = Scale nColNull =udfBinary32Parameter(2) ;lpbinary:nColNull) = can column contain Null Values BinaryEODSet(cColName,128) ;Set End of NameBuffer x= DllCall(cDLL, long:"SQLDescribeCol",long:handle,long:ColNr,lpbinary:cColName,long:128,lpbinary:nLength,lpbinary:nColType,lpbinary:nColDef,lpbinary:nColScale,lpbinary:nColNull) name=BinaryPeekStr(cColName,0,BinaryEodGet(cColName)) ResultList = StrCat(ResultList,Name,@Tab) ; Put the Name at the end of the Liste cColName = BinaryFree(cColName) ;Free all Buffers nColScale = BinaryFree(nColScale) nLength = BinaryFree(nLength) nColNull = BinaryFree(nColNull) nColType = BinaryFree(nColType) nColDef = BinaryFree(nColDef) Next ColNr Return ResultList ;Return with List of Columnnames #EndFunction
Article ID: W15410
File Created: 2003:05:13:11:27:32
Last Updated: 2003:05:13:11:27:32