I have a view displayed on a grid which pulls records from 6 tables using UNION. Because union changes the order of my records I reset the order of the view. Im using recno to determine row color for most of my grids but it obviously wont work here. Are there any other ways to accomplish alternating row colors without having my records in their original order? Or is there a way to use union and keep my table records grouped properly?
Heres my union code:
CREATE SQL VIEW recrigo_view AS ;
SELECT * from recrigo_standardcargo WHERE recrigo_standardcargo.qty > 0 UNION ;
select * from recrigo_rentals WHERE recrigo_rentals.qty > 0 UNION ;
select * from recrigo_tubular WHERE recrigo_tubular.qty > 0 UNION ;
select * from recrigo_wellheads WHERE recrigo_wellheads.qty > 0 UNION ;
select * from recrigo_bits WHERE recrigo_bits.qty > 0 UNION ;
select * from recrigo_mud WHERE recrigo_mud.qty > 0
And my alternating color code:
This.Column1.DynamicBackColor = 'IIF(MOD(recno(), 2) = 0, RGB(230,250,240), RGB(255,255,255))'
Heres my union code:
CREATE SQL VIEW recrigo_view AS ;
SELECT * from recrigo_standardcargo WHERE recrigo_standardcargo.qty > 0 UNION ;
select * from recrigo_rentals WHERE recrigo_rentals.qty > 0 UNION ;
select * from recrigo_tubular WHERE recrigo_tubular.qty > 0 UNION ;
select * from recrigo_wellheads WHERE recrigo_wellheads.qty > 0 UNION ;
select * from recrigo_bits WHERE recrigo_bits.qty > 0 UNION ;
select * from recrigo_mud WHERE recrigo_mud.qty > 0
And my alternating color code:
This.Column1.DynamicBackColor = 'IIF(MOD(recno(), 2) = 0, RGB(230,250,240), RGB(255,255,255))'