3 V4.22 15 Apr 2004 (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
\r
4 Released under both BSD license and Lesser GPL library license.
\r
5 Whenever there is any discrepancy between the two licenses,
\r
6 the BSD license will take precedence.
\r
7 Set tabs to 4 for best viewing.
\r
9 Latest version is available at http://php.weblogs.com/
\r
11 Microsoft Visual FoxPro data driver. Requires ODBC. Works only on MS Windows.
\r
14 if (!defined('_ADODB_ODBC_LAYER')) {
\r
15 include(ADODB_DIR."/drivers/adodb-odbc.inc.php");
\r
17 if (!defined('ADODB_VFP')){
\r
18 define('ADODB_VFP',1);
\r
19 class ADODB_vfp extends ADODB_odbc {
\r
20 var $databaseType = "vfp";
\r
21 var $fmtDate = "{^Y-m-d}";
\r
22 var $fmtTimeStamp = "{^Y-m-d, h:i:sA}";
\r
23 var $replaceQuote = "'+chr(39)+'" ;
\r
26 var $hasTop = 'top'; // support mssql SELECT TOP 10 * FROM TABLE
\r
27 var $upperCase = 'upper';
\r
28 var $_bindInputArray = false; // strangely enough, setting to true does not work reliably
\r
29 var $sysTimeStamp = 'datetime()';
\r
30 var $sysDate = 'date()';
\r
31 var $ansiOuter = true;
\r
32 var $hasTransactions = false;
\r
33 var $curmode = SQL_CUR_USE_ODBC ; // See sqlext.h, SQL_CUR_DEFAULT == SQL_CUR_USE_DRIVER == 2L
\r
35 function ADODB_vfp()
\r
37 $this->ADODB_odbc();
\r
46 function BeginTrans() { return false;}
\r
48 // quote string to be sent back to database
\r
49 function qstr($s,$nofixquotes=false)
\r
51 if (!$nofixquotes) return "'".str_replace("\r\n","'+chr(13)+'",str_replace("'",$this->replaceQuote,$s))."'";
\r
56 // TOP requires ORDER BY for VFP
\r
57 function &SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$secs2cache=0)
\r
59 $this->hasTop = preg_match('/ORDER[ \t\r\n]+BY/is',$sql) ? 'top' : false;
\r
60 return ADOConnection::SelectLimit($sql,$nrows,$offset,$inputarr,$secs2cache);
\r
68 class ADORecordSet_vfp extends ADORecordSet_odbc {
\r
70 var $databaseType = "vfp";
\r
73 function ADORecordSet_vfp($id,$mode=false)
\r
75 return $this->ADORecordSet_odbc($id,$mode);
\r
78 function MetaType($t,$len=-1)
\r
80 if (is_object($t)) {
\r
82 $t = $fieldobj->type;
\r
83 $len = $fieldobj->max_length;
\r
85 switch (strtoupper($t)) {
\r
87 if ($len <= $this->blobSize) return 'C';
\r
91 case 'D': return 'D';
\r
93 case 'T': return 'T';
\r
95 case 'L': return 'L';
\r
97 case 'I': return 'I';
\r
99 default: return 'N';
\r