ADODB_sybase_ase Class Reference
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 16 of file adodb-sybase_ase.inc.php.
Member Function Documentation
| ADODB_sybase_ase.ADODB_sybase_ase | ( | ) |
Definition at line 23 of file adodb-sybase_ase.inc.php.
- 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 28 of file adodb-sybase_ase.inc.php.
References $arr, ADOConnection.$false, $key, $rs, $sql, $value, 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 57 of file adodb-sybase_ase.inc.php.
References $arr, $rs, and ADOConnection.Execute().
| & ADODB_sybase_ase.MetaColumns | ( | $ | table, | |
| $ | normalize = 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 74 of file adodb-sybase_ase.inc.php.
References ADOConnection.$false, $rs, and ADOConnection.Execute().
| ADODB_sybase_ase.getProcedureList | ( | $ | schema | ) |
Definition at line 97 of file adodb-sybase_ase.inc.php.
| ADODB_sybase_ase.ErrorMsg | ( | ) |
- Returns:
- the last error message
Reimplemented from ADODB_sybase.
Definition at line 102 of file adodb-sybase_ase.inc.php.
References ErrorMsg().
Member Data Documentation
| ADODB_sybase_ase.$databaseType = "sybase_ase" |
| ADODB_sybase_ase.$metaTablesSQL = "SELECT sysobjects.name FROM sysobjects, sysusers WHERE sysobjects.type='U' AND sysobjects.uid = sysusers.uid" |
| ADODB_sybase_ase.$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" |
| ADODB_sybase_ase.$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
Reimplemented from ADOConnection.
Definition at line 21 of file adodb-sybase_ase.inc.php.
The documentation for this class was generated from the following file:
- typo3/sysext/adodb/adodb/drivers/adodb-sybase_ase.inc.php
