

Fonctions membres publiques | |
| ADODB_sybase_ase () | |
| & | MetaTables ($ttype=false, $showSchema=false, $mask=false) |
| MetaDatabases () | |
| & | MetaColumns ($table, $upper=false) |
| getProcedureList ($schema) | |
| ErrorMsg () | |
Attributs publics | |
| $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 | |
| ADODB_sybase_ase::ADODB_sybase_ase | ( | ) |
| 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 |
Réimplémentée à partir de ADOConnection.
| ADODB_sybase_ase::MetaDatabases | ( | ) |
return the databases that the driver can connect to. Some databases will return an empty array.
Réimplémentée à partir de ADOConnection.
| & 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.
| $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. |
Réimplémentée à partir de ADOConnection.
| ADODB_sybase_ase::getProcedureList | ( | $ | schema | ) |
| ADODB_sybase_ase::ErrorMsg | ( | ) |
| ADODB_sybase_ase::$databaseType = "sybase_ase" |
Réimplémentée à partir de ADODB_sybase.
| ADODB_sybase_ase::$metaTablesSQL = "SELECT sysobjects.name FROM sysobjects, sysusers WHERE sysobjects.type='U' AND sysobjects.uid = sysusers.uid" |
Réimplémentée à partir de ADODB_sybase.
| 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" |
Réimplémentée à partir de ADODB_sybase.
| 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
Réimplémentée à partir de ADOConnection.
1.5.3