ADODB_sybase_ase Class Reference

Inheritance diagram for ADODB_sybase_ase:

Public Member Functions
	__construct ()
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	MetaDatabases ()
	MetaColumns ($table, $upper=false)
	getProcedureList ($schema)
	ErrorMsg ()
Public Member Functions inherited from ADODB_sybase
	__construct ()
	_insertid ()
	_affectedrows ()
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	RowLock ($tables, $where, $col='top 1 null as ignore')
	SelectDB ($dbName)
	ErrorMsg ()
	_connect ($argHostname, $argUsername, $argPassword, $argDatabasename)
	_pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
	_query ($sql, $inputarr=false)
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	_close ()
	SQLDate ($fmt, $col=false)
	MetaPrimaryKeys ($table, $owner=false)

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"
Public Attributes inherited from ADODB_sybase
	$databaseType = "sybase"
	$dataProvider = 'sybase'
	$replaceQuote = "''"
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d H:i:s'"
	$hasInsertID = true
	$hasAffectedRows = true
	$metaTablesSQL ="select name from sysobjects where type='U' or type='V'"
	$metaColumnsSQL = "SELECT c.column_name, c.column_type, c.width FROM syscolumn c, systable t WHERE t.table_name='%s' AND c.table_id=t.table_id AND t.table_type='BASE'"
	$concat_operator = '+'
	$arrayClass = 'ADORecordSet_array_sybase'
	$sysDate = 'GetDate()'
	$leftOuter = '*='
	$rightOuter = '=*'
	$port

Additional Inherited Members
Static Public Member Functions inherited from ADODB_sybase
static	UnixDate ($v)
static	UnixTimeStamp ($v)

Detailed Description

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

Constructor & Destructor Documentation

__construct()

ADODB_sybase_ase::__construct

(

)

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

Member Function Documentation

ErrorMsg()

ADODB_sybase_ase::ErrorMsg

(

)

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

getProcedureList()

ADODB_sybase_ase::getProcedureList

(

$schema

)

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

MetaColumns()

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

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

References $rs.

MetaDatabases()

ADODB_sybase_ase::MetaDatabases

(

)

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

References $rs.

MetaTables()

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

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

References $metaTablesSQL, $rs, and $sql.

Member Data Documentation

$databaseType

ADODB_sybase_ase::$databaseType = "sybase_ase"

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

$metaColumnsSQL

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"

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

$metaDatabasesSQL

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"

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

$metaTablesSQL

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

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

Referenced by MetaTables().