Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>Sorry I posted this, I have just discovered my error. I had to set the grid's recordsourctype to 1-Alias when using a cursor. Thanks to all who read this anyway.
Carmen
Hello All
> I have a form which contains a grid object. The data source for the grid is the results of the query. I created the query through the query designer and the query works as intended. According to the Fox documentation, in order to populate a grid with the results of a query, the output of the query has to be a cursor or a table. I have made the appropriate copying of the sql statement into the LOAD method of the form. I know the query is working properly in the form, because I browsed the table that the query outputs to. I have set the recordsourcetype property and the recordsource property properly in the grid, and yet no data from the table shows up. I know the table is correct because I put a browse command in the method and it is there fine. I'm not sure what I have missed.
>
>Thanks All
>Regards,
>Carmen
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement