Hi list,
I am trying to identify and delete all those rows in a table that have the
same ids as records in another table. I was trying to do this by something
like:
Select * from table1,table 2 where table1.id = table2.id into temp
Delete from temp
By issuing this select statement I can identify all the records in table1
I want to select, but I can�t delete them via the Mapbasic programme. The
funny thing is, that it is no problem to delete those selected records directly
in Mapinfo.
Now, I�m deleting those records through a for...next loop:
For i = 1 to Tableinfo ("table2",TAB_INFO_NROWS)
Fetch rec i from table2
num = table2.id
Select * from table1 where id = num into q1
delete from q1
Next
This works out OK, but it is very slow. I was wondering if there is a more
efficient way to do this?
Thanks for any advice
Ulrike
__________________________________________________________________
Turbospeed zum Turbopreis! Surfen Sie doch auch mit der DSL-Flatrate
von Tiscali. Nur 15,90 EUR im Monat.
Tiscali DSL basiert auf dem T-DSL-Anschluss der Deutschen Telekom AG,
durch den weitere Kosten entstehen. Dieser ist in vielen
Anschlussgebieten verf�gbar. 6 Monate Mindestvertragslaufzeit.
Und falls Sie wider Erwarten im ersten Monat nicht zufrieden sein sollten,
gew�hrt Tiscali Ihnen ein sofortiges K�ndigungsrecht und Sie erhalten
Ihr Geld zur�ck.
Klicken Sie hier:
http://registrierung.tiscali.de/produkte/1342_dslflatrate.php?akkcode=10253
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11665
