Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vijayendran
  Where is Vijayendran?
 Chennai
 India
 Vijayendran
 To: Vijayendran
  Where is Vijayendran?
 Chennai
 India
 Vijayendran
 Tags
Subject: RE: Is there anyone to help?
Thread ID: 22360 Message ID: 22397 # Views: 1 # Ratings: 0
Version: Visual FoxPro 5 Category: General VFP Topics
Date: Thursday, April 17, 2003 8:25:18 AM         
   


Hey Khalil Shaddad
I tried recreating my query. On running the statement in the query mode, i get the required data, but in the form i get the same error when i reach WITH THISFORM..... & i do not get the data's in the grid. This is very urgent. Can you plz help me.

Regards
Vijyendran.


> Hey Khalil Shaddad
>
> That does not solve my problem. When i uncomment &msele i get error saying "unrecognized command verb". Anyway i will try recreating my sql statement, in the time if you come across any other idea or suggestion plz do say it.
>
> Regards
> Vijyendran
>
>
>
>
> > Hi,
> > There is one comma missing in your select statement. Change it to:
> >
> > ....
> > MSELE = " SELECT vendmast.vcode, Purorder.pono, Purorder.input, Purorder.instage, Purorder.output, Purorder.outstage, Purorder.poqty, Purorder.recdqty, Purorder.rejqty," && here is the missing comma at the end.
> > MSELE = MSELE + " Purorder.poqty - Purorder.mosissue + Purorder.rejqty AS BALQTY FROM gears!vendmast INNER JOIN gears!purorder"
> > MSELE = MSELE + " ON Vendmast.vcode = Purorder.vcode WHERE Release = 'Y' and Purorder.vcode = mvcode and vendmast.vtype = 'M' INTO CURSOR potab"
> > 
> > *&msele && if still having an such an error uncomment this line in order to execute your select statement.
> > 
> > THISFORM.PAGEFRAME1.PAGE1.GRID1.RECORDSOURCE = msele
> > THISFORM.PAGEFRAME1.PAGE1.GRID1.RECORDSOURCETYPE = 3
> > 
> > WITH THISFORM
> > etc...
> > 

> > if still you receive the error then try: &msel just after
> > Khalil Shaddad (Lebanon)
>
>
> Vijayendran S


Vijayendran S


COMPLETE THREAD

Is there anyone to help? Posted by Vijayendran @ 4/16/2003 1:50:15 PM
RE: Is there anyone to help? Posted by Khalil Shaddad @ 4/16/2003 2:09:42 PM
RE: Is there anyone to help? Posted by Vijayendran @ 4/17/2003 7:47:03 AM
RE: Is there anyone to help? Posted by Vijayendran @ 4/17/2003 8:25:18 AM
RE: Is there anyone to help? Posted by Khalil Shaddad @ 4/17/2003 12:56:05 PM