PHP ODBC DBF
Ask the great God.
After installing the ODBC driver, the link dbf file is ok.
When using SQL statements, why use only the most basic SQL syntax, such as select: ORDER: such as like or getdate () This kind of can not? Or is that the wrong form of operation? Or just don't save this function.
[Microsoft] [ODBC Visual FoxPro Driver] File ' GETDATE.PRG ' does not exist.
Function argument value, type, or count is invalid.
I used to use MSSQL and MySQL. Is there much change in syntax when reading SQL statements with ODBC functions?
Ask the great God to help you.
Reply to discussion (solution)
Post your SQL statement
You can't always use non-existent functions, do you?
Well, but I'm using the most basic SQL statement, isn't that OK?
Select
Ifahrzeug,
Ttimestamp,
GETDATE ()
From C:\BATMAN\DATEN\HISTWECH.DBF
where iwechselnr>1
and ifahrzeug>0
and naktion>0
and naktion<4
and Ifahrzeug like ' 87% '
ORDER BY Ttimestamp Desc;
Warning:odbc_exec () [function.odbc-exec]: SQL error: [Microsoft][odbc Visual FoxPro driver]file ' GETDATE.PRG ' does not ex ist., SQL state S0002 in SQLExecDirect in C:\AppServ\www\batman\batmanliste.php on line 54
Warning:odbc_exec () [function.odbc-exec]: SQL error: [microsoft][odbc Visual FoxPro driver]function argument value, type , or count is invalid., SQL state 37000 in SQLExecDirect in C:\AppServ\www\batman\batmanliste.php on line 53
Big God, basic SQL statement or function whether it is in the MSSQL,MYSQL,VFP, is not all can be used ah?
GETDATE () is a function of SQL Server, which is of course not available in VFP.
O.. Amount:
I have now installed ODBC driver, in PHP must follow the specifications of VFP write SQL?
Does that sound like a basic grammar?
You are accessing the database of VFP, of course, to meet the requirements of VFP
Like is supported.
Date (), Time (), DateTime () are supported
Wouldn't it be a database language to learn again?
OK, I'll try again, see if the language of VFP can be used. Amount: