"Kondwani Spike Mkandawire" <kondwani@cs.mun.ca> wrote in message
news:20020710173800.9174.qmail@pb1.pair.com...
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
Your problem should be about file permissions. Try to give full permissions to the IIS_USR for the Paradox tabel you want to extract data from.
Let me know if you have any other questions
Regards
Alex
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php