Information générale
Titre:
Select query with Grid
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement