Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One Cursor, Two Forms
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00243391
Message ID:
00243562
Views:
22
>>One more thing, how can I use only a few fields in my grid? I've got a SQL statement that has 9 in it but I only want 4 from that cursor in my grid...is there and easy way to do that without issuing another SELECT and pulling only those 4 fields?
>
>Put the following code where you need it:
>with thisform.gridname
>   .columncount = 4
>   .column1.recordsource = 'mycursor.fieldname1'
>   .column2.recordsource = 'mycursor.fieldname2'
>   .column3.recordsource = 'mycursor.fieldname3'
>   .column4.recordsource = 'mycursor.fieldname4'
>endwith
Ummm....one more thing, I think you meant .column1.controlsource NOT .column1.recordsource :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform