We use 7.6. We are using a Variable Lisview to show our inventory of parts that go into our products.
We are allocating parts to specific orders and showing the total available after allocating. Once in a while, the available pieces may go negative in the allocating process. We now have a popup screen to warn the user this is happening. We now want the row with the negative information to be highlighted. This information is being shown in a variable listview. I get the parts affected with this code: SET VAR vnprt TEXT = NULL SELECT (LISTOF(DISTINCT partnum)) INTO vnprt INDICATOR ivnprt FROM inv_all_open + WHERE availpcs < 0 The Componenet ID for the varlistview is Comp_Inv. The var for the listview is vPchoice (based on the part number) How do I limit the row color to just the negative rows? I do not see in RDOCS that you can use a WHERE clause with a PROPERTY command. James Belisle Making Information Systems People Friendly Since 1990
