Re: MI deleting a range of rows

[Warren Vick, Europa Technologies Ltd.]

Hello Ben,

> Is there a way through mapbasic to specify a range of rows to 
> delete rather than 1 or all?

All part of living with a basic SQL implementation. The lack of fully feature where 
clauses in 
UPDATEs and DELETEs is a bit of a pain. The solution is to simply make a selection of 
the 
records you want to delete and delete the results. For example:

select * from TestTable where rowid mod 2 = 0 into TO_DEL   ' Select every even record
delete from TO_DEL

Ditto for updates.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]