I can create a DBC with views that reference free table? I never thought about that. Hmm.... The DBFs have to be free tables because they're used by a legacy application. But that could be very convienient if I could use a DBC...

I'm not a VFP programmer, so I'm not familiar at all with creating and managing a DBC. Can I have references to the free tables in the DBC also? If so, I could set that as the database in the Connection String to the VFP OleDb driver and access the views and the free tables through the DBC. I have VFP, just not familiar with using it. How would I go about creating a DBC and adding the views? Can it reference the DBFs with a relative path (same folder as the DBC), or does it have to be a hard-coded path?

-----
Lee Perkins

>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!