DataSet batching with multiple tables in query

Posted by vincentf on 14-Jan-2019 18:26


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

All Replies

This thread is closed