In ACC2007:
I have an application where one of the tables can have a variable structure. I have been successful up til now using DROP COLUMN for all the fields, then using ADD COLUMN to create the new structure. (There are procedures elsewhere that deal with the changed structure. The application needs to combine results from external sources where the fields in one source need to map to the records in another source.) Today I got an error 2190, too many fields after all fields had been dropped and the first new field was being added. The db is set to compact on close.
Any insight into why this occurs?
Thanks.
George
I have an application where one of the tables can have a variable structure. I have been successful up til now using DROP COLUMN for all the fields, then using ADD COLUMN to create the new structure. (There are procedures elsewhere that deal with the changed structure. The application needs to combine results from external sources where the fields in one source need to map to the records in another source.) Today I got an error 2190, too many fields after all fields had been dropped and the first new field was being added. The db is set to compact on close.
Any insight into why this occurs?
Thanks.
George