Öffentliche Methoden | |
ADODB_sybase_ase () | |
MetaTables ($ttype=false, $showSchema=false, $mask=false) | |
MetaDatabases () | |
MetaColumns ($table, $upper=false) | |
getProcedureList ($schema) | |
ErrorMsg () | |
Öffentliche Methoden geerbt von ADODB_sybase | |
ADODB_sybase () | |
_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) | |
Datenfelder | |
$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" | |
Datenfelder geerbt von 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 = '=*' | |
Weitere Geerbte Elemente | |
Öffentliche, statische Methoden geerbt von ADODB_sybase | |
static | UnixDate ($v) |
static | UnixTimeStamp ($v) |
Definiert in Zeile 16 der Datei adodb-sybase_ase.inc.php.
ADODB_sybase_ase | ( | ) |
Definiert in Zeile 23 der Datei adodb-sybase_ase.inc.php.
ErrorMsg | ( | ) |
Definiert in Zeile 102 der Datei adodb-sybase_ase.inc.php.
getProcedureList | ( | $schema) |
Definiert in Zeile 97 der Datei adodb-sybase_ase.inc.php.
MetaColumns | ( | $table, | |
$upper = false |
|||
) |
Definiert in Zeile 74 der Datei adodb-sybase_ase.inc.php.
MetaDatabases | ( | ) |
Definiert in Zeile 57 der Datei adodb-sybase_ase.inc.php.
MetaTables | ( | $ttype = false , |
|
$showSchema = false , |
|||
$mask = false |
|||
) |
Definiert in Zeile 28 der Datei adodb-sybase_ase.inc.php.
Benutzt $metaTablesSQL.
$databaseType = "sybase_ase" |
Definiert in Zeile 17 der Datei adodb-sybase_ase.inc.php.
$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" |
Definiert in Zeile 20 der Datei adodb-sybase_ase.inc.php.
$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" |
Definiert in Zeile 21 der Datei adodb-sybase_ase.inc.php.
$metaTablesSQL ="SELECT sysobjects.name FROM sysobjects, sysusers WHERE sysobjects.type='U' AND sysobjects.uid = sysusers.uid" |
Definiert in Zeile 19 der Datei adodb-sybase_ase.inc.php.
Wird benutzt von MetaTables().