It is not strange as mentioned in the subject line. It is the
relational integrity that R:BASE is known for over 25 years and makes
it what it is today.
It is the responsibility of end-user or developer to also fix/correct
View definition when underlying table structure is altered. If
ignored, R:BASE will generate -ERROR- messages.
Very Best R:egards,
Razzak.
Sent from my iPhone
On May 20, 2009, at 1:55 PM, [email protected] wrote:
I'm converting a database to 7.6, and was testing a program that
used a Gateway Import command to bring in an Excel spreadsheet and
insert it into a temporary table.
It loaded the data just fine but I got an error about "Column
Shipper does not exist", which was strange because the column
Shipper isn't in the database. I kept trying a few things and
rerunning the program, and eventually I got a "database files out of
sync" error. Exiting and coming back in fixed it.
Turns out there were 2 old views hanging around that reference a
Shipper column that isn't there anymore. I dropped the views and
now it loads without the error message.
Kind of strange, not sure if Gateway Import is checking the entire
database structure? So just a warning! Check your view definitions!
Karen
