Re: Cannot Insert into Paradox Tables...
| From: | Chris Hounsell | Date: | Wed, 10 Jul 2002 17:57:55 +0000 |
| Subject: | Re: Cannot Insert into Paradox Tables... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-106901@lists.php.net to get a copy of this message | ||
You ask a lot of questions! Doh!!!
"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
>
> 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
>
>