I'm using ODBC to connect to a DBF under Windows ME.
$conn_dbf = odbc_connect($dbf_host,$dbf_user,$dbf_pass);
$query = "INSERT INTO farm(FARMID,NAMEID,X_COORD,Y_COORD)values('$mix','$idf','$X','$Y')";
It's work for INSERT !!! but why I can not use UPDATE & DELETE like:
$conn_dbf = odbc_connect($dbf_host,$dbf_user,$dbf_pass);
$query = "UPDATE farm SET X_COORD=$X,Y_COORD=$Y WHERE FARMID=$id";
and I got this error message
SQL error: [Microsoft][ODBC dBase Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in
Veryyy Thanx in advance
