Need to close IDEA database after using the RecordSet commands
Forums
I am in the process of updating my Benford scripts so that all the analysis are in the same script and it is more in line with the look and feel of V9 of IDEA. In one portion of the script I have to use the IDEAScripting RecordSet commands, these commands allow you to make changes directly to the data in the IDEA database. In order to use this you must first unprotect the database or column you want to make changes to and then protect them once you are finish or else they are left as editable fields. The problem I found is that you can make the changes but unless you close and reopen the database you cannot use the changed information. An example in my case was that I had created several columns that I was making direct changes to, I was then performing an extract on that database, the first time I did the extraction none of the changes showed up, it was all the old information. After playing with it a bit I came to realize for the changes to take I had to close the database and then open it up again for an extraction. So anyone playing with the RecordSet might want to keep this in mind. I was creating the script on version 8.5 so I haven't tested if this is also a problem in version 9.0.