Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display Cursor Results in Form Grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00220961
Message ID:
00220983
Views:
21
>>>I'd like to display the results of a select query cursor on a form grid. I can't access the cursor from the builder app and when I try placing the cursor value (THISFORM.Grid1.RecordSource="Q_cursor") and the appropriate controlsource in the grid text fields the grid is blank but the cursor is not. Do I need to set the RecordSourceType (it's Table) to another value? The grid works fine when the RecordSource is a data environment table??
>>
>>Yes, change it to Alias...
>
>I changed it to Alias...now the grid is completely blank, no lines, no headers.

Okay... :) Alias is correct, but you should do something like this, it depends where you create the cursor:

grid.recordsource = '' (empty string)

SQL into cursor...

grid.recordsource = 'mycursor'

grid.refresh
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform