ADODB_sybase_ase Class Reference

Inheritance diagram for ADODB_sybase_ase:

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.

---

Constructor & Destructor Documentation

ADODB_sybase_ase.ADODB_sybase_ase (   )

Definition at line 19 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.getProcedureList (  $  schema  )

Definition at line 93 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.

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.

& 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.

---

Member Data Documentation

ADODB_sybase_ase.$databaseType = "sybase_ase"

Reimplemented from ADODB_sybase. Definition at line 13 of file adodb-sybase_ase.inc.php.

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"

Reimplemented from ADODB_sybase. Definition at line 16 of file adodb-sybase_ase.inc.php.

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 17 of file adodb-sybase_ase.inc.php.

ADODB_sybase_ase.$metaTablesSQL = "SELECT sysobjects.name FROM sysobjects, sysusers WHERE sysobjects.type='U' AND sysobjects.uid = sysusers.uid"

Reimplemented from ADODB_sybase. Definition at line 15 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

---