Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>I have created a form with a 2-page pageframe.
>>The first page is used to search for a value in
>>one of two tables. I would like for the search
>>results to be displayed in a grid on the second
>>page. I have tried various combinations for the
>>recordsource of the grid. Either I get all records
>>for the table, no records or the grid shows entirely
>>white. The SQL I tried to use looks something like
>>this:
>> SELECT * FROM title,libkey where
>> libkey.keyword = csearchword
>>On the first page they can choose 2 different fields
>>to search on. I need to be able to change the
>>grid recordsource for each different search.
>>
>>Thanks in advance!
>>Susan
>
>Where do you put the results of the SQL? If you aren't using a cursor or table, do so and use that name as the data source for your grid
I am putting it into a cursor and I use it as the recordsource.
In the click event of the page, I refresh the page. I stated that
this is VFP 3.0, but it is VFP 5.0
Précédent
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