Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tai Nguyen
  Where is Tai Nguyen?
 
 United States
 Tai Nguyen
 To: Oliver Cortazar
  Where is Oliver Cortazar?
 San Luis Potosi
 Mexico
 Oliver Cortazar
 Tags
Subject: RE: need help with concatenance queries
Thread ID: 228704 Message ID: 228842 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Friday, May 22, 2009 2:20:36 AM         
   


> >
> > *********************************************
> > *********************************************
> >
> > How do I execute cQUERY in the run-time and place the data into a cursor(write code to do that because I need to bind the trainingRecords cursor to the report)? How do I run that cQUERY to store all the data in the TrainingRecords cursor after concatenance them altogether? Thanks.
> >
> > Tai Nguyen.
>
> the &cQUERY line runs the query and stores the result in the trainingRecords cursor.

************************************
************************************

I got an error "Command contains unrecognized phrase/keyword" when I tried to run? Was it because I had a different version of FoxPro (because the command didn't exist, could it be missing some dlls or other run-time environment files? Or the spelling was wrong?) Anyway, I have a version of 9.0. I just figured out the way to do that with a command like Create Cursor mycursor (initials c(5), names c(30)) and insert data in each SUBQUERY and it worked. I really want to see this &cQUERY to work because I have a feeling that this should work but somehow it didn't.

Tai Nguyen.

ENTIRE THREAD

need help with concatenance queries Posted by Tai Nguyen @ 5/20/2009 11:59:13 PM
RE: need help with concatenance queries Posted by Oliver Cortazar @ 5/21/2009 12:56:11 AM
RE: need help with concatenance queries Posted by Tai Nguyen @ 5/21/2009 3:13:37 AM
RE: need help with concatenance queries Posted by Oliver Cortazar @ 5/21/2009 8:16:31 PM
RE: need help with concatenance queries Posted by Tai Nguyen @ 5/22/2009 2:20:36 AM
RE: need help with concatenance queries Posted by Oliver Cortazar @ 5/22/2009 7:06:07 PM
RE: need help with concatenance queries Posted by Anders Altberg @ 5/22/2009 8:12:11 PM