Ghias Ahmad
|
Posted: 03/09/2005, 11:09 PM |
|
I made a simple access DB with one table and every time I tries to insert a
record it gives me eroor that" use the updateable query". Im using ASP 3 for
my project. I tries with both jet and odbc connection strings. It can not
handel the insert quesry. If you guys kno any other method plz do inform me.
Previously I was doing the insert method in other ASP pages
RS.AddNew
RS.Fields("Catagory") = Catagory
RS.Fields("Discription") = Discription
RS.Update
My current version of code charge studio is 2.3.2.24 and uses the insert
query is as below.
Cmd.SQL = "INSERT INTO Catagory(" & _
"Catagory, " & _
"Discription" & _
") VALUES (" & _
Connection.ToSQL(IIf(TypeName(Cmd.Parameters.getParamByID(1)) =
"clsSQLParameter", Cmd.Parameters.getParamByID(1),
Cmd.Parameters.getParamByID(1).SQLText),
Cmd.Parameters.getParamByID(1).DataType) & ", " & _
"?" & _
")"
URGENT HELP WANTED IN THIS REGARDS.
|
|
|
E43509
Posts: 283
|
Posted: 03/10/2005, 8:14 AM |
|
Try this: http://support.yessoftware.com/kb_article.asp?s_keyword...=&article_id=72
Also try posting in the other forums as this is for jobs
|
|
|
|