is there such a thing as SQL delete commands in MapInfo?
the closest i can find is one where you can delete rows/objects from a table
based on ROWID. eg.
delete object from mytable where rowid = myrow
however i want to do something like...
delete object from mytable where myfield.value = myvalue
but there doesn't seem to be a way to do it.
the best i can do is do an SQL select, put all the relevant ROWID's into an
array, then run the former SQL delete for each selected object.
i'd like to do it in one hit, rather than have to make up a loop to do it.
ash
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 2959
