Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting query results into a grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00019393
Message ID:
00019400
Views:
35
>>I am using VFP 3.0 and wish to put the results of a query into a grid on the same form that I am collecting user input. I have the qpr file created and working and can put my results into a table, cursor, etc. as needed. When I send the results to a table, I am getting the correct results. But, if I have the grid data source set to the same alias, and the type set to alias, I get a blank grid, without rows or columns even. I do wish the grid to be read only. I am at my wits end trying to figure out why this is happening. Any suggestions?
>>
>>TIA,
>>Jeff Deitch
>
>you can use the qpr as the grid data source. you can also cut and paste >the qpr query and set the data source to the sql results.

Do I set the RecordSourceType to 3-Query and then set the RecordSource to the name of my qpr file or do I put my actual sql statement in there? If I specify the name of my qpr file, where should I send the results? Finally, what do I set my column ControlSource to? Thanks for the help.
Previous
Reply
Map
View

Click here to load this message in the networking platform