Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Questions about Dynamic Color in Grids
Message
From
02/11/2004 12:44:54
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
00956908
Message ID:
00957148
Views:
14
Yes, it would be even better :-)

>>I was thinking you could group your tables by date in a temporary cursor using a select command, ordering and indexing it (the cursor) by date.
>>Then if you set a relation from The main tables into the cursor, you could
>>set the dynamicBackcolor of the grid like that :
>>Yourgrid.setall("dynamicBackColor","IIF(mod(recno('GroupCursor'),2)=0,YourFirstcolor,YourSecondColor)","column")
>>In this way you should switch between two color as the date change.
>
>Nice idea. Or, if there are few records in the second cursor (say, ~10), you may have another field in this cursor called RGBColor I and have a color there. I used a variation of this idea in several of my applications. The difference is that I have a status field (which is always one of the 5 different values) and a color for each status.
Previous
Reply
Map
View

Click here to load this message in the networking platform