Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Arjun/Sangeeta Yadav
  Where is Arjun/Sangeeta Yadav?
 kolkata
 India
 Arjun/Sangeeta Yadav
 Tags
Subject: how to get multiple record set
Thread ID: 396237 Message ID: 396237 # Views: 42 # Ratings: 0
Version: Visual FoxPro 9 Category: Projects and Design
Date: Thursday, January 23, 2014 10:12:06 PM         
   


Hi, Experts

I need a method to get multiple recordset from remote mysql database using a single SQLEXEC()

like
? SQLEXEC(nConnectionHandle,'select * from register where deedno='009' ;
select * from moujamast where moujacode='010' ;
select * from agents where active="ye" ;
select * from agentlevel where levelcode >3 and <=5)

i try out with some examples but fail to acheive the result.

Please help

Thanks & Regards

ENTIRE THREAD

how to get multiple record set Posted by sangeeta yadav @ 1/23/2014 10:12:06 PM
RE: how to get multiple record set Posted by Pete Sass @ 1/23/2014 10:34:34 PM
RE: how to get multiple record set Posted by sangeeta yadav @ 1/24/2014 8:19:59 AM
RE: how to get multiple record set Posted by Raju Shrestha @ 1/24/2014 2:38:27 AM
RE: how to get multiple record set Posted by sangeeta yadav @ 1/24/2014 8:10:27 AM
RE: how to get multiple record set Posted by Tore Bleken @ 1/24/2014 8:15:10 AM
RE: how to get multiple record set Posted by Cetin Basoz @ 1/24/2014 1:12:57 PM