Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to show only certain fields in grid
Message
 
 
To
28/10/2008 10:12:24
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:
01357676
Views:
17
This message has been marked as the solution to the initial question of the thread.
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'
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform