You need a DBC to store the view, but that's all that has to be in the DBC. The tables don't have to be in there. You can even create and destroy the view and DBC in code at runtime.
>I thought you had to have a DBC to store views... Am I mistaken?
>
>-----
>Lee Perkins
>
>>>I'm doing it with ADO.NET in VB.NET. Since I'm pulling the results of the query into an ADO.NET DataSet, and ADO.NET doesn't support doing SQL against a DataSet, I'm afraid I have to do it in one query. And since I'm dealing with VFP Free Tables and not a DBC, I can't even use views. :(
>>>
>>
>>Who says you can't use views against free tables. I do it all the time!