Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select query to show result in Grid
Message
 
 
To
08/03/2004 11:24:47
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00884113
Message ID:
00884115
Views:
10
rename your string name eg. lcSQL and .RecordSourceType = 1
LcSQL = "select distinct(a.tiffile), b.docindex_i from ocrdata a, docudeck b ;
where a.tiffile = b.file_name ;
And a.OCDATA like '% + alltrim(thisform.text5.value)+%' ;
Order By a.ID into Cursor lcSource"

&LcSQL

with thisform.grid1
.RecordSource = ""
.RecordSourceType = 1 && Alias &&4 && SQL
.RecordSource = "lcSource"
endwith
Previous
Reply
Map
View

Click here to load this message in the networking platform