Simple syntax problem

Nancy Tietz ntietz@mcare3.med.umich.edu
Tue, 18 Apr 2000 12:29:33 -0400


Try:

ACC *TSUBFILE
SELECT IF THE-PERCENT = 25.00  OR THE-PERCENT = 2500
REPORT THE-KEY THE-PERCENT
GO


I think how it is defined in the dictionary is just how it's gonna look on a
report.  So I'm betting on the 2500 value giving you the data.  Good Luck!
nt

-----Original Message-----
From: Enid Gentle [mailto:GentleE@rsc.org]
Sent: Tuesday, April 18, 2000 12:24 PM
To: powerh-l@lists.swau.edu
Subject: Simple syntax problem


Help!  all you Powerhouse experts:

This is a query from a trainee sitting here all alone and unable to find the
answer in the manuals.
Using a basic Quiz report:
If an element is defined as a float 4, and is defined in the Powerhouse
dictionary as being a 2-decimal point percentage, complete with % sign, how
do I test it for values?
I need to extract all items with a value of 25.00%  and I have tried all
manner of permutations of testing for this value.  Can anyone help me,
please?  I have run out of initiative and permutations.
I know it is just a simple syntax thing, but I cannot seem to get it right.

Enid
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.