Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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.
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