Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Placing data in a grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00636109
Message ID:
00636190
Vues:
19
Thanks that got what I wanted for that part

>Hello Matthew
>
>"set safety off" to not get the "are you sure" message
>
>
>>I have a form with textboxes, combos, and a pageframe on it. The third page has a grid with 5 columns.
>>I am using a SQL SELECT to populate a temp cursor and zapping the grid.recordsource and appending from the temp. The data is only visible if the query runs while the page the grid is on is the visible page. In fact the status bar tells me no records were selected if the page with the grid is not visible, and when I bring that page forward only the grid lines and headers are there. I would also not like FoxPro to ask me if I want to zap the file.
>>
>>This is in the LostFocus of a combo box where the user chooses a client.
>>
** query to filter sidemark by company code for display in a grid
>>
>>lcThisClientNumber = thisform.txtClientNumber.value
>>
>>SELECT Cdm11smk.smk_smark AS cSidemark;
>> FROM classicdb!cdm11smk;
>> WHERE Cdm11smk.cmp_code = lcThisClientNumber;
>> ORDER BY Cdm11smk.smk_smark;
>>INTO CURSOR curTmpSidemark
>>
>>SELECT curSidemark
>>ZAP
>>APPEND FROM DBF("curTmpSidemark")
>>GO TOP
>>thisform.pgfClientDetails.pagSidemarks.grdSidemarks.grcSidemark.txtSidemark.value = curSidemark.cSidemark
>>thisform.refresh()
>>The cursor is created in the Load of the form. How can I get the data into the grid without it being the page on top. Sometimes when the grid is visible, the data in the grid does not change with the selection of a new client from the combo box.
Opportunity is missed by most people beacuse it is dressed in overalls, and looks like work --- Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform