Documentation TYPO3 par Ameos |
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 |
Definition at line 16 of file adodb-sybase_ase.inc.php.
& ADODB_sybase_ase::MetaTables | ( | $ | ttype = false , |
|
$ | showSchema = false , |
|||
$ | mask = false | |||
) |
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 |
Reimplemented from ADOConnection.
Definition at line 28 of file adodb-sybase_ase.inc.php.
References ADOConnection::$false, ADOConnection::Execute(), and ADOConnection::GetArray().
ADODB_sybase_ase::MetaDatabases | ( | ) |
return the databases that the driver can connect to. Some databases will return an empty array.
Reimplemented from ADOConnection.
Definition at line 57 of file adodb-sybase_ase.inc.php.
References ADOConnection::Execute().
& 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.
$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. |
Reimplemented from ADOConnection.
Definition at line 74 of file adodb-sybase_ase.inc.php.
References ADOConnection::$false, and ADOConnection::Execute().
ADODB_sybase_ase::ErrorMsg | ( | ) |
Reimplemented from ADODB_sybase.
Definition at line 102 of file adodb-sybase_ase.inc.php.