Hi,
My problem was a side effect of too many temporary files in my temporary
folder.
In this folder I found lots of files (9999 files) with file extension of
.tmp.
After I delete theses files, my SQL selects now work.
With this command you can know the temporary folder: print
pathtodirectory$(tempfilename$(""))
But this is also result to an endless loop if you already have too many temp
files in your temporary folder.
Normally the files are in c:\Documents and Settings\PEM\Local Settings\Temp\
(where PEM is your username)
Thanks to Peter and Greg for the hints. I am so happy.
Jimmy
-----Original Message-----
From: Peter Horsb�ll M�ller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 1:56 AM
To: Jimmy Beaudoin; [email protected]
Subject: RE: MI-L [MI-L] Mapinfo query results in an endless loop
Did you try deleting the files in the Windows temp folder ?
c:\Documents and Settings\PEM\Local Settings\Temp\
where PEM is your username
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
-----Original Message-----
From: Jimmy Beaudoin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 1:19 AM
To: [email protected]
Subject: MI-L [MI-L] Mapinfo query results in an endless loop
Hi,
Since an error occur in my application the MapInfo object, I've got problems
with MapInfo. Each time I make query in MapInfo using the SQL Select, the
query results in an endless loop. The only one SQL query that's working well
is "select * from TABLE_NAME". If the SQL query is using: where, group by or
order by condition, the problem occur. If I run a MapBasic program that
contain a SQL select, the same problem append also.
I have tried everything, trying on new tables, rebooting the computer,
reinstalling MapInfo, and the problem persist.
The only issue that I have, is a complete PC re-install and it does not seem
to be helpful.
Did anybody have the same experience?
Does anyone know how to help me?
I have MapInfo 7.5 running on Windows XP.
Yours,
Jimmy Beaudoin
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16697
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16714
