1. I have had this happen once or twice. It is just one of those things,
until you attempted to work on the form without reloading. In that case,
I have had saved forms not working properly. The saved version was not
the one that was called.
2. Incorrect number of values for this table is a statement that data is
being attempted to be loaded into computed columns, or that there are
two many data items for the number of columns in the table.
3. This tends to indicate a broken pointer or that your autonumber is
somehow corrupted.
The solution for all of these is to unload the database and input the
resulting file. Check out the R:Base site for the exact preferred method
under 9.1
On 06/09/2011 8:45 AM, Tom Frederick wrote:
Did a complete rebuild over the weekend and have consistently received
3 messages I am not sure how to fix:
1.‘Values for rows in Sys_Forms3 must be unique’ - I assume this means
duplicate form names exist, but I do not see any.
2.For the Audit table – ‘Incorrect number of values for this table’ -
Number of rows is 10,096 and the next autonumber for AuditID is
10,097. Moved table to Excel, all the numbers match up and no dups.
3.For the Audit table – ‘Column AuditID must be a valid integer’ –
Column AuditID is set as an Integer, is a PK, autonumbers every time,
and acts like an Integer in Excel. I dropped all rows, redesigned
AuditID as an Integer again, and started over. Same results.
