c.recip1, c.reciporg1
******************
LcSQL = [select distinct(a.tiffile), b.proj_no, b.workpkg_no, c.tofrm, c.sequence,;
c.docdesc, c.ref1, c.author1, c.docindex_i from ocrdata a, docudeck b, docindex c ;
WHERE UPPER(b.file_name) = UPPER(a.tiffile) ;
and b.docindex_i = c.docindex_i ;
and a.OCDATA like "%] + alltrim(thisform.text1.value) + [%" ;
order by a.id into Cursor lcSource]
*****************
Max literal string is 255 chars.
Then split it in substring components.
LcSQL = [select distinct(a.tiffile), b.proj_no, b.workpkg_no, c.tofrm, c.sequence,;
c.docdesc, c.ref1, c.author1,c.docindex_i,c.recip1, c.reciporg1];
+[from ocrdata a, docudeck b, docindex c ;
WHERE UPPER(b.file_name) = UPPER(a.tiffile) ;
and b.docindex_i = c.docindex_i ;
and a.OCDATA like "%] + alltrim(thisform.text1.value) + [%" ;
order by a.id into Cursor lcSource]