Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid display
Message
 
 
To
22/02/1999 10:34:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00189955
Message ID:
00190300
Views:
12
Clark,

Create a container class that has all the controls in it. Make the grid a single column not bound to anything, replace the Text1 control with your container class.


>I have a table ( test1 ) with three fields
> field1 c (40)
> field2 c (40)
> field3 c (80)
>
>I have ten records in the table, field3 is empty in all but one record. I want to always display 2 columns in the grid ( field1, field2 ). If field3 is not empty, I need it to display on next grid line under field1, field2 as a single column. Is this possible ?
>
>In order to get needed results now I have created temp table with
>tmpField1 c (80)
>tmpRecno I
>
>I loop through ( test1 ) row by row and append blank in temp table then replace tmpField1 in the temp table with test1.field1 + test1.field2,tmpRecno with test1 recno()
>if test1.field3 is not empty than I append blank to temp table and replace tmpfield1 with test1.field3,tmpRecno with test1 recno(). The grid recordsource is the temp table and displays one column, tmpField1.
>
>I would rather find a way for grid to handle this without building temp table, my real scenerio has many more fields than this example.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform