Hi All:

I'm working on a routine that creates views on the fly to simulate changing the SQL property. I set up a local database to hold the View. When I try to overwrite the View at runtime it bombs, says I need an END Transcations statement. To get this to work, each time I want to recreate the View, I delete the local database and recreate it, then add the view.

In the command window I can overwirte the view without errors. Why can't I do it at runtime?

What is the best way to do this?

Thanx,
Charlie