At 10:37 PM 4/5/2005, Dennis Fleming wrote:
It wasn't hard to fix but a customer sent me their data base and a table had become a view. Same name. They lost about 400 rows of data but we were able to recreate them.
This is in 6.5, but I was wondering if anyone has seen this or how it might happen.
Dennis,
I would check the code which maintains the database maintenance routines, if any.
It might be possible to type CREATE VIEW instead of CREATE TABLE, etc.
Very Best R:egards,
Razzak.

