Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filling a grid with output from SQL
Message
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00326283
Message ID:
00326347
Views:
25
Phil,

I read your message carefully. ThisForm.grdOutPut.RecordSourceType should be 1-Alias!!!!!!!!

>
>>>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 :)
>
> What is the RecordSourceType for this grid?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform