Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to show only certain fields in grid
Message
From
28/10/2008 10:26:22
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01357674
Message ID:
01357678
Views:
16
Was it never supported? I swear I've used something like that in the past.

>The former is supported syntax, the later is not.
>
>You've a few choices (in no particular order):
>- Run another query to create new cursor with fields you need
>- Use SET FIELDS TO
>- Configure ControlSource of the columns to display specific fields only
>
>
>>I have a cursor for which I only want to show certain fields in a grid.
>>
>>Why does this work, showing all the fields...
>>
>>	.Fm_CONTAINER1.grdWorkListXMLCursor.RecordSource = ''
>>	.Fm_CONTAINER1.grdWorkListXMLCursor.RecordSource = 'WorkListXMLCursor'
>>
>>But not this to show selected fields?
>>
>>	.Fm_CONTAINER1.grdWorkListXMLCursor.RecordSource = ''
>>	.Fm_CONTAINER1.grdWorkListXMLCursor.RecordSource = 'WorkListXMLCursor.Desc,FieldVal'
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform