Is there a limit as to the number of multivalued fields one can have?
Here's the problem:
We have 12 MVs in an edit table. The 2nd to the last column is gross and the last column is net. When the gross is entered, that amount is multiplied by a discount rate, which is NOT an MV and the result is the net (a symbolic field).
When we save the record, only the last gross entered is saved, and all other gross amounts are blank/zero. It doesn't matter how many rows we have entered, the last gross is the first gross and all other gross fields are blank when the record is read. It is as if OInsight thinks this is not an MV.
We have checked and re-checked and checked again using table builder to see if there is something there. Gross is marked as an MV. (Before long we will have looked at that as much as the Florida ballots have been recounted. :))
Any ideas anyone?
Thanks
Andy Becker
IL State Lottery
There are also 3-4 other fields that aren't being saved also.
Table fields 6, 7 and 8 for sure, sometimes 9.
At one time I hit save when on a blank row and then retrieved the same record and all fields came back. Added another row to the edit table and it returned only the last gross field (11) in the 1st row of the table.
Solved the problem - I deleted the table and started over. Everything is working the way it should.
Hi Becker
We had a lot of trouble when we had a large number of rows in our tables (got to be around 50 rows, with 16 columns). I think the total data we were loading had become more than 32K (not 64K like most things) and it would eat any extra rows we entered. The problem was most noticable when we added extra columns for tax and gross(total) amounts. Ie there were more columns and more data so stuff that fitted before, now did not (even though the columns were "empty" it still takes some of the 32K to write $0.00). And if the user saved one of these tables where the data was not all fitted into the table, the abbreivated data is what got saved back.
There is a setting under more in the table properties. We found out (here I think) that setting row limit to -1 gives you more rows (I have forgotten why). For these tables though, I am going through the system and unbinding them from the database and writing code to load the tables up and buttons to page through the data, then unload save the data back in table record. It would be really nice if this happened automatically, but it doesn't.
Scott