Cathy Wilbur
Well Known Member
I added a new custom table to the database thru One World with no problems. I then added data to this table thru Oracle. I defined a business view to this table. I then defined a custom window for this business view. It was then noted that we forgot to add some additional fields.
So I went back into this table and added the five new fields and this caused a problem. I DID NOT delete my test data before I added the new fields. When I regenerated the table that deleted the data as expected.
Now I have 5 fields in the table that have the data defined as Double Precision with a size of zero. When I went back into Oracle to readd my test data I came across this problem. This is really strange because the file defn looks fine in One World.
How do I fix the problem WITHOUT DELTETING the custom table. I have a custom window all coded so I don't want to loose the window.
Any ideas. Please see my two attachments.
So I went back into this table and added the five new fields and this caused a problem. I DID NOT delete my test data before I added the new fields. When I regenerated the table that deleted the data as expected.
Now I have 5 fields in the table that have the data defined as Double Precision with a size of zero. When I went back into Oracle to readd my test data I came across this problem. This is really strange because the file defn looks fine in One World.
How do I fix the problem WITHOUT DELTETING the custom table. I have a custom window all coded so I don't want to loose the window.
Any ideas. Please see my two attachments.