Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Applying dift. columns in table to rows in grid
Message
From
09/02/2005 08:42:31
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00985047
Message ID:
00985088
Views:
21
Use SQL SELECT to create a cursor that contains the proper values. Bind the cursor to the grid.

>I have a table that has the following columns:
>
>ac_charge I
>body I
>buff I
>allign I
>teardown I
>
>Each column contains 0,1,2,3
>
>I have a grid with 3 columns - Description, in process, completed
>If the value is 2, In Process gets a check.
>If the value is 3, completed gets a check.
>If the value is 1, the item is listed in the Description column and put in bold (or bold red)
>If the value is 0 then the item isn't included in the list.
>
>The question I have is, how do you take each column item in the table and when the value is equal to 1 put them in consecutive rows in the Description column of the grid? Can I use a collection as a source for each row?
>
>thanks for any suggestions.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform