Hello all !
I get this error when I run the following sql:
SET ANSI ON
Select distinct ff.firma as Firma, iif(isnull(ob.obco), ' ', ob.obco) as ObAct
from rec\firma as ff
left join br_firma as bf on str(year(ff.dinrf), 4) + str(ff.nrinrf, 6) = bf.codu
left join br_obiect as ob on bf.codu = ob.codu
where alltrim(ob.obco) in ('0111', '011101', '01110101', '01110102', '01110103', '01110104', '01110105', '01110106', '01110107', '01110108', '01110109', '01110110', '01110111', '011102', '01110201', '01110202', '01110203', '011103', '01110301', '01110302', '01110303', '01110304', '01110305', '01110306', '0118', '011801', '01180101', '01180102', '01180103', '01180104', '011802', '01180201', '01180202', '01180203', '01180204', '011803', '01180301', '011804')
into cursor crs_rezult
Does anyone know how could I obtain my data (taking into consideration that the query runned by the users could get a lot more complex than this) and if the cause for the error is only that VFP 6.0 ran out of memory ?
Thank you.
Salmano.
I get this error when I run the following sql:
SET ANSI ON
Select distinct ff.firma as Firma, iif(isnull(ob.obco), ' ', ob.obco) as ObAct
from rec\firma as ff
left join br_firma as bf on str(year(ff.dinrf), 4) + str(ff.nrinrf, 6) = bf.codu
left join br_obiect as ob on bf.codu = ob.codu
where alltrim(ob.obco) in ('0111', '011101', '01110101', '01110102', '01110103', '01110104', '01110105', '01110106', '01110107', '01110108', '01110109', '01110110', '01110111', '011102', '01110201', '01110202', '01110203', '011103', '01110301', '01110302', '01110303', '01110304', '01110305', '01110306', '0118', '011801', '01180101', '01180102', '01180103', '01180104', '011802', '01180201', '01180202', '01180203', '01180204', '011803', '01180301', '011804')
into cursor crs_rezult
Does anyone know how could I obtain my data (taking into consideration that the query runned by the users could get a lot more complex than this) and if the cause for the error is only that VFP 6.0 ran out of memory ?
Thank you.
Salmano.