V
vincentf
Guest
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 : Progress KB - How to fill a DATASET with an INNER JOIN between tables? Progress KB - How to set the records to batch for a ProDataSet temp-table Prodataset: Add-buffer method. - Forum - OpenEdge Development - Progress Community 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! 
Continue reading...
Continue reading...