Dear Phil Why don't you clear each query after its used - within the loop( Just close the table queryn. Also when you run the query save the result in your own name. ie Select * from Wales where Product = "MapInfo" INTO GOOD GOOD is just an example and should be replaced with your own choice eg Select * from Accidents where desc = "KNACKERED" into WRITEOFF the Tables named GOOD,WRITEOFF etc ( rather than Query1,Query2 etc ) can be used over and over again. You don't even need to close it, using this method. Another little tip add noselect to your query to stop records being selected on screen. Better still if you don't need to see them close all map windows as this will speed up the selections. Regards Bob In message <D16FF695DF4CD311ACB000A02483401E6547@SERVER>, Phil <[EMAIL PROTECTED]> writes > >I'm running a very intensive MapBasic program that repeatedly selects data. >The program seems to crash leaving the last query as "Query10000". All >previous queries have been deleted. > >Is there a limit on the number of queries MapInfo will run in one session? > >Many thanks.. > >Phil. > > >---------------------------------------------------------------------- >To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put >"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- Bob Young - www.bydesignwales.demon.co.uk ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI Limit on number of queries?
Bob Young - www.bydesignwales.demon.co.uk Tue, 9 Nov 1999 08:09:51 -0800
- MI Limit on number of queries? Phil
- Bob Young - www.bydesignwales.demon.co.uk