Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BETWEEN(...,...) / IN . . .
Message
From
30/10/1996 14:04:44
 
 
To
30/10/1996 13:58:38
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00011152
Message ID:
00011153
Views:
31
>Does anybody know how to replicate
>SQL syntax, BETWEEN() or IN for
>example, in generating a report with
>REPORT FORM ... ? The alternative that
>I use takes the form of stating the
>name of the same field as many times
>as there are variations in its value,
>and sometimes the total length of the
>executable line exceeds the limits.
>
>Any thought will be appreciated.

I have two advices:
1. Pull data in temporary cursor using SELECT-SQL and use plain REPORT FORM command.
2. If length of compiled command exceed limits you can split command line using macros:
cComline1="....."
cComline2="....."
.....
REPORT FORM &cComline1 &cComline2 ....
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform