Can you please tell me, am i doing anything wrong, I am using the following to display the result in the grid. But nothing is appearing in the grid when i am executing this query using the cursor.
i have two columns in grid, do i need to specify the column names(with table name and field name anywhere in the grid before i use the below code.

I am using the distinct with two fields from two different tables.

#################################################################
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 &&1 - Alias &&4 - SQL
.RecordSource = LcSQL
endwith

################################################################

Thank you very much.