Find highest sequence number

[John Pearce]

I have a dataset of demographic data and a corresponding dataset of
comments.  Normally, a data entry person adds new comments records and
manually assigns a sequence number such that related comments are kept
together.

I need to find the highest sequence number for selected demographic records
without reading all of the comments records so I can add a system generated
comment with the next higher sequence number.  I seem to remember seeing a
way to do this in QTP but can't find it now.  Does anyone remember seeing
it?  Better yet, does anyone remember how to do it?

The environment is HP 8.19C4 using ImageSQL.  The demographic data has a
unique key IDNO the comments have a repeating key IDNO and sorted on SEQNO.

Thanks, in advance, for your help.

------------------------------------------------------------------
John Pearce  <jpearce@rmi.net>	| Bethesda Management Company 
Speaking for only myself		| Colorado Springs, CO  USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.