>I have the following select in my code:
>
>SELECT ReComm.ident, ReComm.date_prev, ReCommD.*, ApSupp.name, ARCode.descr ;
>FROM ReComm ;
>LEFT OUTER JOIN ReCommD ;
>ON ReComm.ident = ReCommD.ident ;
>LEFT OUTER JOIN ApSupp ;
>ON ReComm.iddetail = ApSupp.ident ;
>LEFT OUTER JOIN ArCode ;
>ON ReCommD.Code = ArCode.Code ;
>WHERE WEEK(ReComm.date_prev,1,2) = THISFORM.ScnWeek.value ;
> ORDER BY ReComm.ident
>
>()
>Recomm:10387 rec, RecommD:21940 rec, apsupp:10672, arcode:13
>Recomm.ident, recommd.ident, apsupp.ident are unique key (integer)
>Arcode.code is unique key (char(5))
>
>It runs for ever and my NT4 (Workstation, 128MB RAM, enought disk space) tells me that VFP6 is not responding.
>It runs good if I specify a short range of Recomm.ident in the where clause. It runs good also if I take out both apsupp and arcode tables from the query.
>I thought that VFP6 would not crash on this. I can understand that it could run slow so you play with the indexes but "not responding"??? The same query in Crystal report runs in about 30 seconds.
>Is there a memory limit or somekind of trap with vfp6?
>
>Thanks.
>Eric.
Do you have an index on WEEK(ReComm.date_prev,1,2) in the recomm table?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope