I could have sworn I've done this... now I can't get this to work.
I have a search form up. When double-clicking on a row in the results
listview, an eep does this:
SET VAR vPayWhere = ('ID = .vID'), vPayType TEXT = 'ALL'
EDIT USING payable WHERE &vPayWhere
The Payable form comes up, and there is a radio group at the top where they can
pick either "All" or "Paid" (this is what the vPayType variable does). It
comes up as "All", and if they click "Paid" then it sets a new vPayWhere
clause, as shown below. I thought that by doing the table refresh, it would
reach back to my "edit using payable where &vpaywhere" clause in the previous
form to do a refresh, but it just stays on the "All". I've tried temporarily
modifying Paid to say other things, and it ignores. Code traces with no error.
The vPayWhere by itself works to bring up payable data from the R> prompt.
SWITCH(.vPayType)
CASE 'ALL'
SET VAR vPayWhere = ('ID = .vid')
BREAK
CASE 'PAY'
SET VAR vPayWhere = ('ID = .vid AND payit IS NOT NULL')
BREAK
ENDSW
PROPERTY TABLE payable 'REFRESH'
RETURN
I can do this, right?
Karen
