Edit ACCOUNT_REF fields within a few tables
Posted: 27 Apr 2023, 15:10
Long story short, we have a company which has a blank ACCOUNT_REF.
There's some rows in AUDIT_SPLIT which have ACCOUNT_REF as the blank record.
Sage crashes if we enter the record. We identified the problem by using the ODBC driver and exporting all the tables to CSV, but as you know, the ODBC driver is read only, cannot use
Is there a way that I could write to the database to insert this ACCOUNT_REF?
There's some rows in AUDIT_SPLIT which have ACCOUNT_REF as the blank record.
Sage crashes if we enter the record. We identified the problem by using the ODBC driver and exporting all the tables to CSV, but as you know, the ODBC driver is read only, cannot use
Code: Select all
UPDATE