Passed parameters and selection sets
Ray Scheel
ray.scheel at wsdtx.org
Tue Aug 2 09:33:15 PDT 2005
I was trying to modify a selection (called from a php-built web form /
command line) that currently selects the desired unit to also be able to
select all a defined regional grouping based on the contents of a passed
parameter. Line "a" works fine, field 5:unitcd(2,*), is correctly
compared to the contents of @pm. Where I ran into trouble was when
trying to add logic to catch the codes for the larger groupings.
I would enter and save a selection set like this:
a | 5 | unitcd ; unit code eqf| @pm|
b | @pm| Parameter eq | _North
|
c | @pm| Parameter eq | _South
|
Selector Sentence:
a or (b and north) or (c and south)
but when I came back to it, what showed up was this:
a | 5 | unitcd ; unit code eqf| @pm|
b | @pm| Parameter eq | _|
c | @pm| Parameter eq | _|
Selector Sentence:
a or (b and north) or (c and south)
Note the stripping down of the "Value" column to one character.
I had identical results when using @pw- at pz and when trying "co" instead
of "eq". Behavior for passed parameters verified on linux versions of
both 5.0.11aR4 and 5.0.14R4. The behavior did not carry over when
trying a few other system maintained fields, it apparently only impacts
passed parameters.
I'm going to work around this by selecting all records in the selection
set when I've got a leading "_" in the unitcd and will instead drop the
unwanted units in sort/selection processing (referring back the
selection set "north", "south", etc).
Has anyone else run into this? Is there an unadvertised fix or setting
to change this behavior, or documentation that their use in selection
sets isn't supported or is (sometimes) limited to the first character?
Should I just give up on using passed parameters for much of anything in
selection processing since I keep tripping over significant bugs (e.g.
the incompatibility with index scan I discovered about a year ago)?
Surely I'm not the only person trying to use command line parameters in
selection sets, am I? I'm getting tired of getting well into a project
and then having to stop to identify an issue or undocumented limitations
and then come up with a workaround to compensate.
Ray Scheel ray.scheel at wsdtx.org
Windham School District Computer Services
Programmer 936-291-5206
More information about the Filepro-list
mailing list