Hi,
I've been able to use the batching method to optimize the display of my data in a gridview. I've been able to make it works correctly for a query with only a single table.
Right now, I'm trying to make it works with multiple tables. Here a example of a query that I could have :
FOR EACH order NO-LOCK,
FIRST customer NO-LOCK WHERE customer.custnum = order.custnum.
I found some articles where it seems to explain how to do that but I don't understand how it is supposed to work and what is the best way to do it because every articles seems to do it differently. Some of those articles are not a demo for .Net.
Here's some of the articles that I refer to :
In some of those articles, a query is defined for each table that are in the actual query. Why would you do another query to get the same data that provide the first one ?
Have you any idea how make it works with multiple tables ?
Thank you for your help! :)