Hi,
Situation: My query in MapBasic selects all records from table A that intersect
table B. The query result C is saved as a MapInfo table. Now I want to delete
all records from table A that were selected initially. Because for the initial
query two tables are used, the selected records from table A cannot be deleted
("cannot delete from a view"). Therefore, I select all records from A that have
a same identifier as the records in table C, using a nested query.
Select * from A, B Where A.Obj Intersects B.Obj Into C
...save table C and open it...
Select * from A Where ID = Any (Select ID from C) Into qryDelete
Delete from qryDelete
Problem: this approach is awfully slow. Removing 500 records from 5000, takes
about two minutes.
Solution: ?
Does anyone know a faster approach.
Best regards,
Ren� Bruinink
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
