>Hi,
>Could someone give me more information on this error please
>Error No:1150
>Message: Not enough memory for filrmap

This indicates that VFP is unable to allocate adequate space for the bitmaps required to be created in a SQL Select involving WHEREs and JOINs; it's typically a situation where memory is underallocated in VFP via SYS(3050) or an inadequate amount of virtual memory to service the needs (the bitmaps for a Cartesian product, or several bitmaps required to resolve a complex WHERE/JOIN combination can be very large) or overallocation of EMS or DPMI memory under FPDOS or FPW, resulting in address space wraparound.

>
>Thanks,
>Ria