General information
Category:
Forms & Form designer
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only