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
 Tags
Subject: Display data in Edit Box
Thread ID: 22884 Message ID: 22884 # Views: 17 # Ratings: 0
Version: Visual FoxPro 5 Category: General VFP Topics
Date: Tuesday, April 29, 2003 1:40:57 PM         
   


I have a list box which has to display data. The code is as follows:

Local msele
msele =''

Msele = " SELECT Poschedule.schno, Poschedule.stdate, Poschedule.endate,Poschedule.schqty, Poschedule.schqty-Poschedule.accqty"
Msele = Msele +" FROM gears!poschedule WHERE Poschedule.pono = mrefkey1 AND Poschedule.partno = mpartno AND Poschedule.stagecode = mstagecode"
Msele = Msele +" AND Poschedule.podate = mrefkey2 AND Poschedule.poref = mreftype AND Poschedule.grinno=0"
Msele = Msele +" AND (month(poschedule.podate) = month(date()) OR (((Poschedule.schqty+Poschedule.rejqty-Poschedule.accqty) >0"
Msele = Msele +" AND poschedule.stdate < date()))) INTO CURSOR poschlist"

This.rowsource = msele
This.rowsourcetype=3

Thisform.refresh()

Here anything declared with m as the starting is a variable declared in the form. My problem is the data is not getting displayed. Can anybody help me?

Regards
Vijayendran S


COMPLETE THREAD

Display data in Edit Box Posted by Vijayendran @ 4/29/2003 1:40:57 PM
RE: Display data in Edit Box Posted by Yuri Rubinov @ 4/29/2003 2:39:30 PM
RE: Display data in Edit Box Posted by Paul Brown @ 4/29/2003 2:51:13 PM