Re: PHP4 with Access/Paradox tables through ODBC : insert failes
| From: | Thibault Dangr�aux | Date: | Tue, 27 Jun 2000 14:16:58 +0000 |
| Subject: | Re: PHP4 with Access/Paradox tables through ODBC : insert failes | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-660@lists.php.net to get a copy of this message | ||
"Doug Semig" <dougslist@c3net.net> wrote :
>Just a guess...do you have a primary key defined for the table in
>Paradox/Access?
>Though it's been a very long time since I've used ODBC/Access, I remember
>having similar problems when trying to do things with a table that didn't
>have a primary key defined.
>Doug
Yes, I have a primary key : an auto-incremented counter (both featured in
Access and Paradox).
This way, I don't have to bother with the primary key in any INSERT query,
since this is generated by the database. This works fine using my test SQL
program (Borland DB explorator).
Thibault