Dim MyRowID as integer MyRowID = MyTable.RowId
By the way, what is a "lower plant ecologist"? Are you lower on the totem pole then a flowering plant ecologist, say?
-- Sofia Nikolsky
JCH GeoInfo Solutions (919) 493-9339 www.jchgis.com
Alan Hale wrote:
This seems to me a very basic problem to which there is probably a
simple solution - but I confess I can't see what it is. I want to
programmatically iterate through a table updating rows on the basis of
information in each row. My first approach was to use "Fetch" so that
deleted rows in an unpacked table are skipped over. But then how do I
identify the rowid? If I use a while loop and a counter, the counter
will not take account of deleted rows and any updates will end up being
"staggered". What I think I need is either some way of identifying the
current rowid (after a Fetch statement), or a way of identifying if a
row is deleted.
I could of course programmatically pack the table, with a dialog to the user to check this is OK. I'd prefer not to take this approach, but if I do I have another question - how can I determine programmatically whether a table is packed or not?
Thanks
Alan Hale
Lower Plant Ecologist
Countryside Council for Wales
Aberystwyth
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9957
