Jump to content

query cannot be updated because it contains no searchable columns to use as a key


boylesg

Recommended Posts

Trying to update the columns in my excel data source with code like below and I get this error message on this line: objRS.MoveNext();It appears cursor type has something to do with it. I was originally using static but got the same error with dynamic.function WriteInvBillingDetails(objRS){ // If open then close it. if (objRS.state == 1) objRS.Close(); objRS.Source = "Select * from " + "BILLING"; objRS.Open(); objRS.Fields.Item(0).Value = String(Request("given_names")) + " " + String(Request("surname")); objRS.Fields.Item(1).Value = String(Request("address1")) + " " + String(Request("address2")); objRS.Fields.Item(3).Value = String(Request("phone")); objRS.Fields.Item(4).Value = String(Request("mobile")); objRS.Fields.Item(6).Value = String(Request("email")); objRS.MoveNext(); objRS.Close();}

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...