Initializing help system before first use

SQLcolumns

Purpose
Get the columns of a given table.
Synopsis
function SQLcolumns(t:string,cname:array(range) of string,cstype:array(range) of string):integer
function SQLcolumns(t:string,cname:array(range) of string,citype:array(range) of integer):integer
function SQLcolumns(t:string,cname:array(range) of string):integer
Arguments
t 
The table name
cname 
An array of strings to return the column names
cstype 
An array of strings to return the column types (textual representation)
citype 
An array of integers to return the column types (type codes)
Return value
Number of columns.
Example
The following example displays the names and types of columns of table 'dtt': 
declarations
 CR:range
 cname:dynamic array(CR) of string
 ctype:dynamic array(CR) of string
end-declarations

nbc:=SQLcolumns("dtt",cname,ctype)
write("Table 'dtt' has columns:")
forall(c in 1..nbc) write(' ',cname(c),'(',ctype(c),')')
writeln
Related topics
SQLtables, SQLprimarykeys, SQLindices.
Module
mmodbc

Parent Topic Procedures and functions

© 2001-2022 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.