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

Reply via email to