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.

my code :

$connect =  odbc_connect("sosdb","","") or die ("can not connect")
; ->successfult

$order_trans_detail_sql = "insert into order_trans_detail
(order_id,cus_id,order_place) values
('02120200007','0071577722451188','548/12 123 Road Patumwan') ; " ;

$exec = odbc_exec($connect,$order_trans_detail_sql )  or die ("cannot insert
order trans detail<br>") ; -> warning as below

all field is text field for database MS-Access .and I connect it through
ODBC by ms access driver use (DSN)

I found
  Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation
must use an updateable query., SQL state S1000 in

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to