PHP ODBC is not a table when accessing VFP9 tables
The table code for accessing VFP using ODBC is as follows
Header ("content-type:text/html; charset=gb2312 ");
$myconn =odbc_connect ("Vfp1", "", "" ");
$STRSQL = "SELECT * from ' xxku1 '";
$result =odbc_do ($myconn, $STRSQL);
?>
{?>
|
|
|
}odbc_close ($myconn);? >
The table used to manipulate the VFP6 everything is ok but the VFP9 table is not a table. Because VFP9 's table has more than one field that is automatically incremental, it can be accessed by removing the field.
What should I do if I want to access a table with an AutoIncrement field?
Someone on the web said that using OLE DB I also downloaded olddb VFP, but did not know how to use PHP ODBC VFP9
Share to:
------Solution--------------------
The self-increment field is only valid in the library (DBC)
So your ODBC source should be the library (DBC) instead of the free table (DBF)