3 V4.22 15 Apr 2004 (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
4 Released under both BSD license and Lesser GPL library license.
5 Whenever there is any discrepancy between the two licenses,
6 the BSD license will take precedence.
7 Set tabs to 4 for best viewing.
9 Latest version is available at http://php.weblogs.com/
11 SAPDB data driver. Requires ODBC.
15 if (!defined('_ADODB_ODBC_LAYER')) {
16 include(ADODB_DIR . "/drivers/adodb-odbc.inc.php");
18 if (!defined('ADODB_SAPDB')) {
19 define('ADODB_SAPDB', 1);
21 class ADODB_SAPDB extends ADODB_odbc
23 var $databaseType = "sapdb";
24 var $concat_operator = '||';
25 var $sysDate = 'DATE';
26 var $sysTimeStamp = 'TIMESTAMP';
27 var $fmtDate = "\\D\\A\\T\\E('Y-m-d')"; /// used by DBDate() as the default date format used by the database
28 var $fmtTimeStamp = "\\T\\I\\M\\E\\S\\T\\A\\M\\P('Y-m-d','H:i:s')"; /// used by DBTimeStamp as the default timestamp fmt.
30 function ADODB_SAPDB()
32 //if (strncmp(PHP_OS,'WIN',3) === 0) $this->curmode = SQL_CUR_USE_ODBC;
37 SelectLimit implementation problems:
39 The following will return random 10 rows as order by performed after "WHERE rowno<10"
42 select * from table where rowno < 10 order by 1
44 This means that we have to use the adoconnection base class SelectLimit when
45 there is an "order by".
47 See http://listserv.sap.com/pipermail/sapdb.general/2002-January/010405.html
54 class ADORecordSet_sapdb extends ADORecordSet_odbc
57 var $databaseType = "sapdb";
59 function ADORecordSet_sapdb($id, $mode = false)
61 $this->ADORecordSet_odbc($id, $mode);