General information
Category:
Coding, syntax & commands
Title:
Select query pointing 2 tables of same type due to 2gb limit
Please help i am counfused how to make the query to search both the tables ocrtable and ocrtable1 both are same type of table with same fields etc.
since the ocrtable reached 2gb limit thats why we had to create another new table with the same name but one at the end.
Now when i fire the following query it searches in ocrtable from now on i want to also include ocrtable1 in it and what ever the data comes need to be pushed into the cursor and then i will bind the cursors data into the datagrid.
Please help if you don't mind.
****************Query*******************************************
LcSQL = [select distinct(a.tiffile), b.proj_no, b.workpkg_no];
+[from ocrtable a, docudeck b, docindex c ;
WHERE UPPER(b.file_name) = UPPER(a.tiffile) ;
and b.docindex_i = c.docindex_i ;
and Upper(a.OCDATA) like "%] + Upper(alltrim(stxtocrstring)) + [%"] + swhere +;
[ order by a.id into Cursor lcSource]
****************************End***************************************
The data in both the tables is unique the key field is ID which is completely unique in both the tables ocrtable and ocrtable1 no 2 records in both tables has a same id.
Thank you very much.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only