"TYPO3 4.0.1: ADODB_sybase_ase Class Reference", "datetime" => "Sat Dec 2 19:24:02 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

ADODB_sybase_ase Class Reference

Inheritance diagram for ADODB_sybase_ase:

Inheritance graph
[legend]
Collaboration diagram for ADODB_sybase_ase:

Collaboration graph
[legend]
List of all members.

Public Member Functions

 ADODB_sybase_ase ()
& MetaTables ($ttype=false, $showSchema=false, $mask=false)
 MetaDatabases ()
& MetaColumns ($table, $upper=false)
 getProcedureList ($schema)
 ErrorMsg ()

Public Attributes

 $databaseType = "sybase_ase"
 $metaTablesSQL = "SELECT sysobjects.name FROM sysobjects, sysusers WHERE sysobjects.type='U' AND sysobjects.uid = sysusers.uid"
 $metaColumnsSQL = "SELECT syscolumns.name AS field_name, systypes.name AS type, systypes.length AS width FROM sysobjects, syscolumns, systypes WHERE sysobjects.name='%s' AND syscolumns.id = sysobjects.id AND systypes.type=syscolumns.type"
 $metaDatabasesSQL = "SELECT a.name FROM master.dbo.sysdatabases a, master.dbo.syslogins b WHERE a.suid = b.suid and a.name like '%' and a.name != 'tempdb' and a.status3 != 256 order by 1"
 character set to use - only for interbase, postgres and oci8

Detailed Description

Definition at line 12 of file adodb-sybase_ase.inc.php.

Member Function Documentation

ADODB_sybase_ase::ErrorMsg (   ) 
 

Returns:
the last error message

Reimplemented from ADODB_sybase.

Definition at line 98 of file adodb-sybase_ase.inc.php.

& ADODB_sybase_ase::MetaColumns (  $  table,
$  upper = false
) 
 

List columns in a database as an array of ADOFieldObjects. See top of file for definition of object.

Parameters:
$table table name to query
$normalize makes table name case-insensitive (required by some databases) is optional database schema to use - not supported by all databases.
Returns:
array of ADOFieldObjects for current table.

Reimplemented from ADOConnection.

Definition at line 70 of file adodb-sybase_ase.inc.php.

References ADOConnection::$false, and ADOConnection::Execute().

ADODB_sybase_ase::MetaDatabases (   ) 
 

return the databases that the driver can connect to. Some databases will return an empty array.

Returns:
an array of database names.

Reimplemented from ADOConnection.

Definition at line 53 of file adodb-sybase_ase.inc.php.

References ADOConnection::Execute().

& ADODB_sybase_ase::MetaTables (  $  ttype = false,
$  showSchema = false,
$  mask = false
) 
 

Parameters:
ttype can either be 'VIEW' or 'TABLE' or false. If false, both views and tables are returned. "VIEW" returns only views "TABLE" returns only tables
showSchema returns the schema/user with the table name, eg. USER.TABLE
mask is the input mask - only supported by oci8 and postgresql
Returns:
array of tables for current database.

Reimplemented from ADOConnection.

Definition at line 24 of file adodb-sybase_ase.inc.php.

References ADOConnection::$false, ADOConnection::Execute(), and ADOConnection::GetArray().

The documentation for this class was generated from the following file: