Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filling a grid with output from SQL
Message
 
To
02/02/2000 14:44:26
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00326283
Message ID:
00326339
Views:
29
>Insert ThisForm.grdOutput.recordsource = '' before the SQL-select.
>
>HTH
>>cmdbutton.click is this:
>>
>>USE q:/qa/qdms2000/DOCUMENT/document share
>>SET MESSAGE TO ""
>>
>>l_cSearchtext='%'+upper(alltrim(ThisForm.txtSearchString.value))+'%'
>>
<b>ThisForm.grdOutput.recordsource=''</b>
>>select * from document where title like l_cSearchtext order by number into cursor temp1
>>
<b>brow</b>
<b>ThisForm.grdOutput.recordsource=''</b>
>>ThisForm.grdOutput.recordsource='temp1'
>>ThisForm.grdOutput.refresh
>>thisform.refresh
>>
I tried the bolded additions, based on your suggestions (with only one null recordsource statement at a time) and neither worked....although the BROW shows that temp1 has records....

I've got two strikes........lookin for an underhand lob here :)
Phil Thomas
http://phillipdthomas.com

Never let your energy or enthusiasm be dampened by the discouragements that must inevitably come.....
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform