Member Avatar for vn412
vn412 0 Light Poster

Hi,

I've a problem handling dataset. I have 3 tables in access database. In loop i am firing query to select values

for i=1 to 3 
sql= "  SELECT field FROM tbl where some condition"

Now i execute the query to get dataset(ds) as output.

next

I want to get the code help fore.g I get 2 records from first table, 1 record from second table and 2 rec from third table they all get appended in dataset ds so that i get values from it by counting. I hope I put my issue clearly. Pls Help.

Thanks

  • 1 Contributor
  • 0 Replies
  • 51 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.