Hi Sergey,
The theory with all macro under same SQL statement does not work.
VFP is looking at one command at the time, and when expanding all macros
under same command and if it is greater then 8192 it will produce
an error.
See this link as well:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/conSystem_Capacities.aspAlso if I break those field as suggested at first like the following it will
pass the 8192 characters limit, that does not work as well since at the bottom
I entered all fields names and exprssions into an SQL statement and that will
pass the 8192 characters limit as well.
SELECT aaa, bbb, RECNO() as rn ;
FROM temp1 ;
INTO CURSOR xxx1
SELECT ccc,ddd, RECNO() as rn ;
FROM temp2 ;
INTO CURSOR xxx2
SELECT ;
xxx1.aaa ,;
xxx1.bbb ,;
xxx2.ccc ,;
xxx2.ddd ;
FROM ;
xxx1 ;
INNER JOIN XXX2 ;
ON xxx1.rn==xxx2.rn ;
INTO CURSOR ResultCursor
If I add the following:
This way no need to enter all exprssions but I will fields like RN
all over.
SELECT *;
FROM ;
xxx1 ,;
xxx2 ;
INNER JOIN XXX2 ;
ON xxx1.rn==xxx2.rn ;
INTO CURSOR ResultCursor
Regards,
Doron