Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BETWEEN(...,...) / IN . . .
Message
De
30/10/1996 14:04:44
 
 
À
30/10/1996 13:58:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00011152
Message ID:
00011153
Vues:
37
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform