>>If I create a View on the fly in a form how do I add it to the forms DE?
>>
>>Thanks
>

---

Why would you do that.
>You can simple open and close the view in your form.
>But probably addobject() will help you. (Don't know if the cursor object can be added at runtime)

I assumed that adding it to the DE was the thing to do to keep everything in sync...

When I try

dodefault()
CREATE SQL VIEW Test1 AS;
SELECT * FROM Equip

in the load, or init, or activate I get an error
no database is loaded or set as default...