At 01:43 PM 11/7/2004 -0600, Dick Fey wrote:
However:
If a history DOES exist, Customer field changes to RED in EVERY row History button changes to RED in EVERY row
At first I thought that the cusname being a field, while the history button is a variable, might cause it. But it works perfectly on the single row if there is no history. So if this theory is correct, why does it change ALL rows if there is a history.
Dick,
Change the underlying code as follows and see what you get.
SET VAR vHisChk Integer = 0 SELECT Refnum INTO vHisChk INDIC ivHisChk + FROM OrdHistory WHERE RefNum = .vRefNum IF vHisChk = .vRefNum THEN PROPERTY idHisory FONT_COLOR 'RED' PROPERTY idCusname FONT_COLOR 'RED' ELSE PROPERTY idHistory FONT_COLOR 'BLACK' PROPERTY idCusname FONT_COLOR 'RED' ENDIF RETURN
For more examples and a similar scenario, take a look at Running R:BASE Your Way! (Part 9), included on your Fall 2004 Conference CD:
Example: Dynamically Displaying/Hiding Enhanced Tabs
Database: RRBYW9
Associated Form: SalesTransactions
Associated Tables: Customer,InvoiceHeader,InvoiceDetail, Employee and Contact
On Row Entry EEP: SalesTransactions.EEP
Have fun!
Very Best R:egards,
Razzak.
