Hi
A small gotchya with this is that it will give a count that includes deleted rows. If
you want a count of records, you will need to pack
the table first. Otherwise you can step through the table and count them. Something
like ..
fetch first from tab1
i = 0
do until EOT("tab1")
i = i + 1
fetch next from tab1
loop
or select everything and count that
select * from tab1
i = selectioninfo(SEL_INFO_NROWS)
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]
--
Mike Taylor
______________________________________________
GIS Senior Consultant mailto:[EMAIL PROTECTED]
Sinclair Knight Merz Limited http:\\www.skmconsulting.com
Level 12, Mayfair House Tel: +64 4 473 4265
54 The Terrace Fax: +64 4 473 3369
PO Box 10283,Wellington
New Zealand
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
