Yes used the named query with certainly help, and you could even add the NoSelect keyword to you statements and get a better performance as well:
SELECT * FROM TABLENAME INTO OTHER_TABLENAME NoSelect In this way the current selection will not be changed. Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis Sidste frist for tilmelding til MapInfo Konferencen er den 6. august 2004. Tilmelding samt yderligere information kan ses p�: http://www.cowi.dk/GIS -----Original Message----- From: Simeon Kohlman Rabbani [mailto:[EMAIL PROTECTED] Sent: Saturday, August 07, 2004 2:35 AM To: 'Mapinfo-L' Subject: RE: MI-L MI Pro hangs when browsing from selection table Thank you for the help. There were too many temp tables. I was running a program that has to select each line of a table one at a time, and each selection was producing a temp table. When it hit 10,000 (or 9999), the program hung. Can this be avoided by selecting into a named table? Example: SELECT * FROM TABLENAME INTO OTHER_TABLENAME Instead of SELECT * FROM TABLENAME INTO SELECTION Thank you, Simeon ----------------------------------------------------- Simeon Kohlman Rabbani Prefeitura Municipal de Aracaju ----------------------------------------------------- -----Original Message----- From: Uffe Kousgaard [mailto:[EMAIL PROTECTED] Sent: sexta-feira, 6 de agosto de 2004 02:45 To: Mapinfo-L Subject: Re: MI-L MI Pro hangs when browsing from selection table 2 ideas for possible causes: 1) You have too many temp tables in the temp directory. 2) You have installed Windows XP SP2 (RC) which is known to interfere with many existing applications because of changed security settings. HTH Regards Uffe ----- Original Message ----- From: "Simeon Kohlman Rabbani" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 06, 2004 6:12 AM Subject: MI-L MI Pro hangs when browsing from selection table I have been a MapInfo user and MapBasic application developer for over 6 years, and have never before encountered this strange problem. Every time I try to browse from a selection, MapInfo hangs (the cursor goes to the hourglass and stays there). This also occurs whenever I close the last map window. I am using version 7.0 Professional. I have uninstalled the entire application, including MapBasic, ODBC, Data - the whole 9 yards, and reinstalled everything from scratch, and the problem is still occurring. This suggests to me that there may be a Windows or other DLL that is causing the problem, but I have no idea how to track it down, if that is the case. Has anyone else ever encountered something like this? I am using the Windows XP operating system. Any help would be greatly appreciated! Thanks, Simeon K. Rabbani --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12859 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12875 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12879
