Hello ,
I need help !
my problem is that i can't get with an insert option with php3 and ODBC
here is the error, and next the script, could anyone explain me, or resolv it
Thanx
Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access] L'opération doit utiliser une requête qui peut être mise à
jour., SQL state S1000 in SQLExecDirect in c:\inetpub\scripts\modif.php3 on line 20
<?
$user="adminisrateur";
$upasswd="";
$dsn = "bd1";
$i=0;
$vieux="";
//connexion à la base access
$cBD = odbc_connect($dsn,$user,$upasswd);
if (!cBD) {
print "Connection failed\n";
exit;
}
//requete
$query = "INSERT INTO REGROUPEMENT VALUES('$a1',$a2,'$a3','$a4')";
//execution
$result = odbc_exec($cBD, $query);
//deconnexion
odbc_close($cD😎;
?>
