Yup.  Also please remember to use absolute values when comparing item numbers.

Kind regards,

Denys. . .

Denys Beauchemin
HICOMP
(800) 323-8863  (281) 288-7438         Fax: (281) 355-6879
denys at hicomp.com                             www.hicomp.com


-----Original Message-----
From:   Boris Kortiak [SMTP:[log in to unmask]]
Sent:   Wednesday, September 20, 2000 9:54 AM
To:     [log in to unmask]; [log in to unmask]
Subject:        RE: Image: dbinfo: mode 302: What is Key item number?

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.