RecordSet.update throwing invalid argument

[the_louv]

I am modifying existing code from a previous project designed to split an oracle database. When running an existing modules I get an 'invalid argument' when it executes the myRecordSet.Update.

I have placed myRecordSet in AddWatch, and found the record it blows up on. It contains a / character. As a test I ran a delete query to delete all records containing / in that particular table, and re-ran the module. The module works as expected.

However, this does not fix my problem, as moving forward I will need this data. I can refresh the database to begin at square one, so the deleted records are easily recovered. Are there special characters that the RecordSet object's update method will have problems with, and is there a work around?

 

[Insane_ai]

Try a find and repace routine in your code. This requires processing each record individually. Look for the "/" in the field and replace it if exists.