General information
Title:
Building a Repor Based on MULTIPLE JOIN
Wich is the best way to construct a report based on multiple join Query between VFP Tables and obtain good performance. The Tables have aprox. 1GB of physical size. Actually we are using ODBC Connection, I have tried with OLEDB.. the performance is not good. Wich one do you recommend???. Do I have to build a query cursor and then copy to fox2 table??... that means I have to create a table with same structure as cursor in some place to construct and design the report... and make changes in report, cursor, and table each time when I add or remove fields to display in the report?
Any suggestion?... Thanks,
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