Subject: | |
From: | |
Reply To: | |
Date: | Wed, 20 Sep 2000 09:32:50 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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.
|
|
|