Hi, I’m using ASP to put a web interface to Navision Financials 2.60e version. And I’m trying to insert new records. First I’m using: objRS.AddNew to add a new record in which to insert. objRS is a recordset But this gives me the error: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Is this a problem with Navision? Can anyone help? Thank you.
Hi. Adding, updating or deleting recordset through that way may be difficult. The recordset must have a certain set of properties to allow this operations. Personally, I don’t use .AddNew or any other command, because I was unable to create a recordset that would allow this (just like you). Instead I use plain SQL through the C/ODBC connection - and it works fine - using the command conn.execute . If you must use this commands, the only thing I can say is to try to use the C/ODBC 2.60F. I hope this help.