can't insert into MS-access
| From: | Penockio | Date: | Tue, 12 Feb 2002 17:42:57 +0000 |
| Subject: | can't insert into MS-access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16892@lists.php.net to get a copy of this message | ||
I can't use sql command "insert into " but I can use "select" and it
condition.I use DSN that provide by ODBC and use MS-Access as source file.
I found Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
Operation must use an updateable query., SQL state S1000 in
and my code is " insert into order_trans_detail
(order_id,cus_id,order_place) values
('02120200007','0071577722451188','548/12 payatai Road Patumwan')
;" all
field is text field for database MS-Access .and I connect it through ODBC by
ms access driver use (DSN)c