Hi All,
Assuming:
1) function myResult always returns the value 'Passed' in this example - so I could test where the bug was
2) t-Trx is a temp-table
Can anyone tell me why this works fine :
OPEN QUERY {&SELF-NAME}
FOR EACH t-Trx WHERE t-Trx.transferDirection <> "Out"
AND
myResult( 'AnyValue' ) = 'Passed'
NO-LOCK.
.. yet this doesn't ( i.e. no values are returned in the query ) :
OPEN QUERY {&SELF-NAME}
FOR EACH t-Trx WHERE t-Trx.transferDirection <> "Out"
AND
myResult( t-Trx.Status ) = 'Passed'
NO-LOCK.
.. also if I put a MESSAGE 'Hi' into the function block, in the first ( working ) example the message appears, in the second broken example, the message doesn't appear, implying that progress isn't bothering running the function - yet no error is reported.
Cheers,
Ingie.
Assuming:
1) function myResult always returns the value 'Passed' in this example - so I could test where the bug was
2) t-Trx is a temp-table
Can anyone tell me why this works fine :
OPEN QUERY {&SELF-NAME}
FOR EACH t-Trx WHERE t-Trx.transferDirection <> "Out"
AND
myResult( 'AnyValue' ) = 'Passed'
NO-LOCK.
.. yet this doesn't ( i.e. no values are returned in the query ) :
OPEN QUERY {&SELF-NAME}
FOR EACH t-Trx WHERE t-Trx.transferDirection <> "Out"
AND
myResult( t-Trx.Status ) = 'Passed'
NO-LOCK.
.. also if I put a MESSAGE 'Hi' into the function block, in the first ( working ) example the message appears, in the second broken example, the message doesn't appear, implying that progress isn't bothering running the function - yet no error is reported.
Cheers,
Ingie.