Sorry by not posting a sum on this issue. I though it was a simple question that
wasn't worth place on this list.
1)
Evens
Select * from TableName where ColumnName/2 = ColumnName\2
Odds
Select * from TableName where ColumnName/2 <> ColumnName\2
Steve Wallace
GIS & Market Information Manager
Florida Farm Bureau Insurance Companies
2)
select * from the_table where int(rowid/2)=rowid/2 into selectiontable
where "the_table" is the name of the table you are selecting from and
"selectiontable" is the name of the query table you want. I have used rowid
itself in the example, but if you populated a field like "ID" with rowid,
you could just substitute in that field name for rowid.
You can use Query>SQL Select to run this query. However, you can also just
type it into the MapBasic window (use Options>Show MapBasic Window to get
it) and hit return.
Regards,
Eric Johnson
Boulder, CO
[EMAIL PROTECTED]
3)
I know this has been answered but since no sum was given - for other peoples
interest you could also use the MOD function
even:
select * from query1 where rowid mod 2 = 0
odd
select * from query1 where rowid mod 2 = 1
I believe this approach to be better because it can be used to get every Xth
row
eg
Xth row:
select * from query1 where rowid mod X = 0
Cheers
Martin
==================================
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
The several answers I got were around these approaches.
Thanks for all that help me.
Dyan C. Catamaran
Phero Tech Inc.
--------------------------
604-940-9944
604-940-9433
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
