HP3000-L Archives

September 2000, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Boris Kortiak <[log in to unmask]>
Reply To:
Boris Kortiak <[log in to unmask]>
Date:
Wed, 20 Sep 2000 10:53:30 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (28 lines)
Thanks Denys,

Let me restate this to make I understand it correctly.

After doing a mode 302 call to DBINFO, one gets back the key (master) or search (detail) item number for the referenced data set.  This number represents the item number within the entire database.  This item number is ordered by schema declaration.

After doing a mode 104 call to DBINFO, one gets back an array listing the item numbers for all items in the selected dataset.  This item number is also ordered by the schema declaration.

By searching the array returned by a mode 104 call for the item number returned from the mode 302 call one find the relative placement of the data item within the dataset.

Have I got this correct?

>>> Denys Beauchemin <[log in to unmask]> 09/20/00 10:32AM >>>
All item numbers returned by DBINFO calls refer to the number of the item when 
initially declared in the database schema.  If you use DBINFO 302 on a dataset, 
it will return the item number of the key or search item for a master dataset. 
 With this value, you can then search the array returned by a call to DBINFO 
104 on the dataset in question, which will contain all the item numbers of that 
dataset, in the order they are declared within the dataset.

Do not forget that element 0 in the return array of DBINFO 104 contains the 
number of items within the dataset.  So simply set up a little loop X to go 
from 1 to element(0) within that array and compare each value with the value 
you got from DBINFO 302.  When you have a match, the loop value X at that time 
will be the item placement within the dataset.

BTW, you may want to use absolute values for the item number comparison.

ATOM RSS1 RSS2