I am working on a huge, messy, old and very ugly legacy system. We have created a remote application and are using UltraLIte as our DB there. Several of the forms in our system use INSERT statements without a list of columns. Now that SQL Anywhere has added this new column to the tables I am getting a mismatched columns error (ORA-009947).
So for example we have:
INSERT INTIO table (SELECT col1, col2, col3 FROM table2)
We should have:
INSERT INTO table (cola, colb, colc) (SELECT col1, col2, col3 from table2)
One solution to the problem will be to modify the INSERT statements in the forms to have the list of columns, but if we do that it adds a lot more work and testing to the project.
Is there a way to create the SQLAnywhere system without having the LAST_MODIFIED column added to the DB tables?
I assume the