Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nesting IIF(), is this possible
Message
De
23/08/2001 11:03:38
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
22/08/2001 12:19:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00547335
Message ID:
00547986
Vues:
9
>>>The verification engine require that table for report is opened, and often it say syntax error for really valid expressions. Try to store this and run report anyway with this expression, and see of it will show you syntax error.
>>>
>
>>I use Fox Pro 2.6 quite a lot and almost always it says syntax error when you click verify, but works when the report is run.
>
>This used to happen to me also. I gave up on using verify, it wasn't worth it.

Verify in Expression builder does work only if you have the tables open. For some reason, when it's called from a report designer, it doesn't see them. Actually, the best way that I've found to check for a validity of an expression is to paste it into the command window next to a question mark, or (even better, if it has a value dependent on a field),
browse fields fld1, fld2, fld3..., x={expression_here}
This way you see how it functions across the whole table, i.e. what the report would show. It's easier to edit the expression in the command window (where we at least have some control over the fonts and size), and paste it back into the report once it's fine. Saved me a lot of time, regardless of what I used it for - reports, methods or prgs.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform