Your Statement is incorrect syntax:
insert into MYTABLE (item1,item2,item3) VALUES (Var1,Var2,Var3);
----- Original Message -----
From: "Yong Zhou" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 15, 2000 3:49 PM
Subject: sql problem
> hello everyone
>
> I used the following sql statement to add new data:
> "INSERT INTO table VALUES ('value1', 'value2', 'value3')"
>
> I get this error message: " Error: "-3035[Microsoft][ODBC Microsoft
> Access Driver] Operation must use an updateable
> query.80"-------------------- SQL failed.
>
> I can't figure out what's going wrong here. Has anyone encountered
> similar problem before?
> I use NT server, ODBC driver and WIN32::ODBC package.
>
> Thanks
> _______________________________________________
> ActivePerl mailing list
> [EMAIL PROTECTED]
> http://listserv.ActiveState.com/mailman/listinfo/activeperl
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
