>Hello Everybody!
>
>I have a strange problem. How to remove a file from a database, if the specified file doesnot exist?
>So the problem more precisely. I have a database with some table in it. I have to "validate" the database programaticaly. I have a table which is deleted by the user accidentally. If I issue VALIDATE DATABASE, it doesnot remove the reference for this table, but REMOVE TABLE cannot remove the reference, because it generates an error, stating that file doesnot exist.
>What is the solution?
>
>TIA
>
>BB

Hi Bela:

I'm working on a solution to that same problem.
If you can afford it there's a tool call SDT (Stonefield Database Tools) which extends the DBC container to solve some limitations including this one. If interested and you can afford it see thread #93014 Message #93189.

I'm pretty close to finish a solution without external tools, I'll let you know how it works.