>Kevin,
>
>>Great idea, I've given that a go by placing 7 different folders on my local server.
>
>I wonder if the PRG would give a different result if you did not have the USE statements, but instead included the path/filename (nameexpression) directly in the SQL (or SET PATH differently before the query for each office).
>
>When you said the SQL in the C# app was identical, did you mean that you were also issuing the same USE statements through the OLE-DB driver, or did the SQL statements in the C# app actually include the path/filename (or a SET PATH) for each iteration of the seven offices?
The OLE DB driver was setup on that particular path, so you are right in that it opens the tables automatically.
I tried your suggestion using the SET PATH and it was actually slower in VFP....
Kev
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only