You can use SQL SELECT and choose
Where condition : ID mod 2 And ID > 32 and ID < 49 for the ODD
or where condition ID <> (ID mod 2) And ID > 32 and ID < 49 for EVEN
You can use your Mapbasic windows to make (or see the result) of those queries
Select * from Outlets where ID mod 2 And ID > 32 and ID < 49 into ODD
Browse * From ODD
Select * from Outlets where ID <> (ID mod 2) and ID > 32 and ID < 49 into EVEN
Browse * From EVEN
Gilbert
Dear List,
A blindingly simple question, but something im having trouble with. If I
have 100 records in a table, each with an integer value for the ID column (not RowID,
just a column I put in), can I get MapInfo to recognise and select all the evens, or
all the odds? can I then get it to recognise evens and odds between given values e.g
select all odds between 32 and 49.
Thanks for help in advance P
Peter Solomonides
<Technician>
ΛTKINS Rivers & Coastal
Thomson House
Birchwood Park
Risley, Warrington
WA3 6AT
01925 62 2015
07734859137
View 'Alliance' Issue 3: our new Atkins Newsletter for work let by the Environment
Agency < http://www.atkinsglobal.com/wsainternet/markets/water/relatedinformation/41
49163_alliance_issue3_for_.pdf>
This email and any attached files are confidential and copyright protected. If you are
not the addressee, any dissemination of this communication is strictly prohibited.
Unless otherwise expressly agreed in writing, nothing stated in this communication
shall be legally binding.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe,
e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12883
Disclosure of Material Facts
Every Proposer or Insured / Reinsured when seeking new insurance / reinsurance or
renewing an existing Policy must disclose any information which might influence the
Insurer / Reinsurer in deciding whether or not to accept the risk, what the terms
should be, or what premiums to charge. Failure to do so may render the insurance /
reinsurance voidable from inception and enable the Insurer / Reinsurer to repudiate
liability.
This email, together with any attachments, is for the exclusive and confidential use
of the addressee(s) and may contain legally privileged information. Any other
distribution, use or reproduction without the sender's prior consent is unauthorised
and strictly prohibited. If you have received this message in error, please notify
the sender by email immediately and delete the message from your computer without
making any copies. While attachments are virus checked, Aon Limited does not accept
any liability in respect of any virus which is not detected.
Aon Limited
Company Number: 210725
Registered Address: 8 Devonshire Square, London, EC2M 4PL
Aon Limited is a member of the General Insurance Standards Council (registration 2239)
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12887
