Re: MULTI4 Update Problem [message #2167 is a reply to message #2166] |
Thu, 25 June 2009 04:58 |
AJM
Messages: 2371 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
I'm glad your problem is sorted. If it has disappeared it might prove difficult to debug in the future as you may not be able to recreate the conditions which caused this problem.
One thing that you have to remember after modifying a database table is that you must import the new schema into the data dictionary so that it is in sync, then you must export the changed tables so that the application has access to the latest <table>.dict.inc files. If, for example, you change a table to add a second column to the primary key but forget to import/export the changes, then the framework does not know that the 2nd column is part of the key. Similarly if you change the size of a column - unless you import/export the change the framework will work with the old values.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|