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:
Denys Beauchemin <[log in to unmask]>
Reply To:
Date:
Wed, 20 Sep 2000 09:32:50 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (47 lines)
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.

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:17 AM
To:     [log in to unmask]
Subject:        Re: Image: dbinfo: mode 302: What is Key item number?

Well, in this case, I'm looking at the master dataset.  The item number being
return exceeds the number of items contained in this master dataset.

Is it possible that mode 302 is returning the item number within the database
as a whole and not as a part of a particular dataset?  Would that be why a call
to DBINFO with mode 102 would be required?

Is there any way I can determine the item number within a particular dataset?

>>> Michael Anderson <[log in to unmask]> 09/19/00 11:50AM >>>
When calling DBINFO Mode 302, try following it with a call to DBINFO Mode 102
to get detail info for the Item Number in question.

I think Mode 302 returns the item number of the item that is named in the
related master dataset.

ATOM RSS1 RSS2