Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
  • Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
  • PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.

Differences Between: [Versions 310 and 400] [Versions 311 and 400] [Versions 39 and 400] [Versions 400 and 401] [Versions 400 and 402] [Versions 400 and 403]

MSSQL driver via ODBC

Copyright: 2000-2013 John Lim
Copyright: 2014 Damien Regad, Mark Newnham and the ADOdb community
License: BSD-3-Clause
License: LGPL-2.1-or-later
File Size: 439 lines (13 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 2 classes

ADODB_odbc_mssql:: (16 methods):
  ServerInfo()
  IfNull()
  _insertID()
  MetaForeignKeys()
  MetaTables()
  MetaColumns()
  MetaIndexes()
  _query()
  SetTransactionMode()
  MetaPrimaryKeys()
  SelectLimit()
  SQLDate()
  substr()
  charMax()
  textMax()
  Concat()

ADORecordSet_odbc_mssql:: (0 methods):


Class: ADODB_odbc_mssql  - X-Ref

ServerInfo()   X-Ref
No description

IfNull( $field, $ifNull )   X-Ref
No description

_insertID($table = '', $column = '')   X-Ref
No description

MetaForeignKeys($table, $owner=false, $upper=false)   X-Ref
No description

MetaTables($ttype=false,$showSchema=false,$mask=false)   X-Ref
No description

MetaColumns($table, $normalize=true)   X-Ref
No description

MetaIndexes($table,$primary=false, $owner=false)   X-Ref
No description

_query($sql,$inputarr=false)   X-Ref
No description

SetTransactionMode( $transaction_mode )   X-Ref
No description

MetaPrimaryKeys($table, $owner = false)   X-Ref
No description

SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$secs2cache=0)   X-Ref
No description

SQLDate($fmt, $col=false)   X-Ref
No description

substr($fld,$start,$length=0)   X-Ref
Returns a substring of a varchar type field

The SQL server version varies because the length is mandatory, so
we append a reasonable string length

return: The SQL text
param: string    $fld    The field to sub-string
param: int        $start    The start point
param: int        $length    An optional length

charMax()   X-Ref
Returns the maximum size of a MetaType C field. Because of the
database design, SQL Server places no limits on the size of data inserted
Although the actual limit is 2^31-1 bytes.

return: int

textMax()   X-Ref
Returns the maximum size of a MetaType X field. Because of the
database design, SQL Server places no limits on the size of data inserted
Although the actual limit is 2^31-1 bytes.

return: int

Concat()   X-Ref
No description