Help please...
We are a local UK council new to MapInfo, (but not new to GIS), with
one licence which we are using to evaluate the product with the
potential to use it more widely.
I am running MapInfo on my Viglen PC P5/75 with 2x 0.5GIG hard drive
and 64MB RAM. MapInfo is installed on the D-drive, as is the data I
am using.
I am getting into situations using SQL Select where MapInfo is not
responding & I have to close it down & clean up the .tmp files each
time.
I am searching a table of 4,800 address records for records not
contained in another table of 3,800 records, and the processing never
finishes.
ie
select * from table_a where not data1 in (select data1 from table_b)
the data from table_a originates from an ACCESS .MDB database, the
data from table_b originates from gradually selecting a series of
points in MapInfo & appending them to table_b as part of a quality
checking process. Both tables can be browsed OK independantly.
I have similar "timeout" problems where using select on a 58,000 row
address file when trying to do a simple SQL select on posttown i.e.
select * from table where posttown ="portsmouth". Again I can browse
the whole table. - The data again comes from ACCESS .MDB.
Any advice, please? Thanks. Linda Williams
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
