Concept Framework 1.0 documentation Contents | Index

ADOConnection.ListColumns

Name Type Access Version Deprecated
ListColumns function public version 1.0 no

Prototype:
array ListColumns(string table="",string columns="")

Parameters:
table      the table name
columns      the column name (optional)

Description:
List columns in a table.

Example:
pragma warnings off


include DataBases.con

class Main {
function Main() {
var Connection=new ADOConnection();
var DataSet=new ADODataSet(Connection);

Connection.Open("Driver={SQL Server};Server=(local);Database=iadc;Uid=iadc;Pwd=iadc;");
echo Connection.ListTables();

echo Connection.ListColumns("sysobjects");

Connection.Close();
echo Connection.LastError();
}
}

Returns:
Returns an array of arrays describing the columns in the given table. If it fails, it returns null.

Documented by Eduard Suica, generation time: Thu Oct 15 20:01:57 2009 GMT(c)2009 RadGs Software