Cannot Insert into Paradox Tables...

From: Date: Wed, 10 Jul 2002 17:31:58 +0000
Subject: Cannot Insert into Paradox Tables...
Groups: php.general 
Request: Send a blank email to php-general+get-106891@lists.php.net to get a copy of this message
I am trying to insert info. into a paradox table but receive the following message after inputting the data into the approriate fields... Warning: SQL error: [Microsoft][ODBC Paradox Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\coopstudent.php on line 47 I am able to retrieve info. from the table but when I write some Insertion Code I receive the above message... This is what the code looks like... Please help... $db = odbc_connect("MyDNS", "who", "null"); $dreq = "INSERT INTO myTablet.db (field1, field2, field3...) VALUES ('$field1', '$field2', '$field3'...)"; odbc_exec($db, $dreq); Thanks in advance... Kondwani

« previous php.general (#106891) next »