Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Print via myform
Message
From
10/11/2004 10:12:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
10/11/2004 04:21:08
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 5
Miscellaneous
Thread ID:
00959007
Message ID:
00959998
Views:
5
>hi,
>
>thank you for reply.
>does it work now? no , still
>
>
>
>
>
>select * from mstr where UPPER(inname) = UPPER(TRIM;
>     (thisform.pageframe1.page1.text1.Value));
>     and nam1 =thisform.pageframe1.page1.text4.Value and;
>between(datein, thisform.pageframe1.page1.text3.value,thisform.pageframe1.page1.text5.value );
>into cursor TempReport;
>  nofilter
>if _tally = 0
>  MessageBox("No records selected. Try changing your criteria.")
>else
>
>BROWSE  && i see what i choice
>
>ENDIF
>report FORM mstr33 preview && i see all data ...any idea
>select  mstr && go back to the table that belongs to the grid
>
>thanks .
>m.qasem

The problem might be with the SELECT statement, or with the report. Do some debugging, to find out which it is. For example, after selecting the data, issue the command SET STEP ON, and take a look at the cursor TempReport, to see if it has the correct data, or all the data from the table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform