Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nesting IIF(), is this possible
Message
From
23/08/2001 11:03:38
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
22/08/2001 12:19:01
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00547335
Message ID:
00547986
Views:
16
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform