We have a need to make numerous modifications to the Registry Table. I am modifying the keyfile so naturally I am using OpenView, Select, and Modify. The problem is not making the modifications it is in the committing part that does not work; sometimes with an error(generic), sometimes not; but always with no changes being made.
Using vbscript, I enumerate through the registry table and then call a function to use Modify. When all the modifications are complete thats when I call Database.Commit. Placing the commit within the Function works but it is extreeeemly slow.
The question is why doesn't commit work after the enumeration and only after Modify?
Here is the function and Call (object setups have been omitted): '~enumerationStart Call MODIFY_DB("`Registry`","`Registry`",,) '~enumerationEnd '>>>Placing Commit here does not work Database.Commit:CheckError
Function MODIFY_DB(sTable,sPrimaryKey,sOldVal,sNewVal) err.Clear Set View = Database.OpenView("SELECT * FROM " & sTable & " WHERE " & sPrimaryKey & " = '" & sOldVal & "'"):CheckError
View.Execute Set Record = View.Fetch Record.StringData(1) = sNewVal err.Clear View.Modify 4, Record:CheckError '>>>Placing commit here allows everyting to work 'Database.Commit:CheckError Set Record = Nothing : View.Close :Set View = Nothing End Function
