Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Putting query results into a grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00019393
Message ID:
00019400
Vues:
37
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform