Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change to better
Message
 
To
11/11/2004 05:55:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00960324
Message ID:
00960325
Views:
11
I do not understand what exactly You want to do, what are the fields in Report You want to print? Why You have a cikle before REPORT FROM ... But I would do that this way:
cName    = UPPER(ALLTRIM(thisform.pageframe1.page1.text1.Value))
cNam1    = UPPER(ALLTRIM(thisform.pageframe1.page1.text4.Value))
beg_date = thisform.pageframe1.page1.text3.value
end_date = thisform.pageframe1.page1.text5.value
SELECT * FROM Mstr;
   WHERE UPPER(ALLTRIM(Mstr.InName)) == cName AND;
         UPPER(ALLTRIM(Mstr.Nam1))   == cNam1 AND;
         BETWEEN(mstr.datein, beg_date, end_date);
INTO CURSOR ToReport

SELECT ToReport
GO TOP
SCAN
   m.a=innoumber
  ? m.a ,innoumber
  wait
  m.b=price
  m.c=total
ENDSCAN
GO TOP
REPORT FORM  mstr22 preview
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform