Vision Duplicate Record Error
I'm recently worked out integration of Visual Basic.net occupying AcuODBC to access cobol data, try insert same record into same vision table with modification to certain field values.
Then it ended up to pop-up Error message as "ERROR [S0000] [AcuCorp, Inc.][AcuODBC Driver][ISAM]Vision duplicate record", but My data is about successive to insert in.
Can anyone tell me why it happened and how to fix this? Thanks in advanced.
RE: Vision Duplicate Record Error
A Vision file or Indexed file has a key or keys, one of them being a primary key. Lets say your file has a primary key of part-number and part-number is 2022 (or something). If you attempt to write data into the data file with part-number 2022 then you'll receive a duplicate error. You'll need to know the primary key of the files you are updating. If you actually need to overwrite the existing data in the file, then you would need to delete the record with part-number 2022 and then write your record. You would need to be cautious about overwriting as the record in the file may contain more data in the record than the data you are using to update it with. It would be best to read the record and then figure out if and how you want to update it.