Hello Michael,
Loop for getting row count :)
Oh, no better this:
select count(*) from tab1
print tab1.col1
TM> fetch first from tab1
TM> i = 0
TM> do until EOT("tab1")
TM> i = i + 1
TM> fetch next from tab1
TM> loop
TM> or select everything and count that
TM> select * from tab1
TM> i = selectioninfo(SEL_INFO_NROWS)
TM> Cameron Crum wrote:
>>
>> If you don't include mapbasic.def you can use TableInfo("Table1", 8)
>>
>> Cameorn
>>
>> "HANNA MICHAEL (TOR1MMH)" wrote:
>>
>> > TableInfo("Table1", TAB_INFO_NROWS) gives the number of rown in the table
>> > Table1.
>> >
>> > Make sure you include MapBasic.def in the module.
>> >
>> > Michael Hanna
>> >
>> > -----Original Message-----
>> > From: Morrier, Steve [mailto:[EMAIL PROTECTED]]
>> > Sent: Tuesday, June 04, 2002 2:38 PM
>> > To: [EMAIL PROTECTED]
>> > Subject: MI-L Number of Rows
>> >
>> > HI again,
>> >
>> > Is there a way, in MapBasic, to determine the number of rows in any given
>> > table? TIA
>> >
>> > Steve
>> >
>> > -----Original Message-----
>> > From: Christian McNierney [mailto:[EMAIL PROTECTED]]
>> > Sent: Tuesday, June 04, 2002 12:51 PM
>> > To: [EMAIL PROTECTED]
>> > Subject: RE: MI-L Update Area
>> >
>> > 1 sq. mile = 259 hectares so you can use Area(obj, "sq mi")*259
>> >
>> > Christian
>> >
>> > -----Original Message-----
>> > From: Mark Lindberg [mailto:[EMAIL PROTECTED]]
>> > Sent: Tuesday, June 04, 2002 12:33 PM
>> > To: [EMAIL PROTECTED]
>> > Subject: MI-L Update Area
>> >
>> > Hello,
>> >
>> > I would like to update an existing AREA field in a browser using Table:
>> > Update Column. The area measurement I want to use is hectares.
>> >
>> > How would I structure my Expression?
>> >
>> > Thanks for your time!
>> >
>> > Cheers,
>> > Mark
>> >
>> > _________________________________________________________________
>> > Join the world's largest e-mail service with MSN Hotmail.
>> > http://www.hotmail.com
>> >
>> > ---------------------------------------------------------------------
>> > List hosting provided by Directions Magazine | www.directionsmag.com |
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>> >
>> > ---------------------------------------------------------------------
>> > List hosting provided by Directions Magazine | www.directionsmag.com |
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>> >
>> > ----------------------------------------------------------------------------
>> >
>> > This communication (including all attachments) is intended solely for the
>> > use of the person or persons to whom it is addressed and should be treated
>> > as a confidential xwave communication. If you are not the intended
>> > recipient, any use, distribution, printing, or copying of this email is
>> > strictly prohibited. If you received this email in error, please
>> > immediately delete it from your system and notify the originator. Your
>> > cooperation is appreciated.
>> >
>> > ---------------------------------------------------------------------
>> > List hosting provided by Directions Magazine | www.directionsmag.com |
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>>
>> ---------------------------------------------------------------------
>> List hosting provided by Directions Magazine | www.directionsmag.com |
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
--
Best regards,
Vladimir Lashin
MBBuilder COD mailto:[EMAIL PROTECTED]
microOLAP Technologies LLC
http://www.microolap.com/gis/ - GIS related products
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
