Eben Young writes





We have just located a potential problem and would appreciate some answers

from the image gurus.



Given an automatic master dataset, and two detail datasets.  Both details

are linked to the automatic master by the very first field in the

dataset.  Given key XXXXX, and a record existing in dataset #1, performing

a DBFIND on dataset #2 yields a hit (DBFIND DB-STATUS = 0).  But of

course, the DBGET yields nothing.  Does anyone have experience with this

and/or knows the reasons for it?  Is this normal?



We can repeat this problem with multiple databases and datasets.



Thanks in advance for your assistance!

-----------------------------------------------------------------

Actually, there's nothing wrong.  The DBFIND is establishing that the 

record exists in the master (auto or manual) and establishes the chain 

beginning and ending.  The DBGET, mode 5 or 6 traverses the chain of 

records in the detail. 



To firmly establish if there are any records for a given key value your 

code should be as follows:



IF DB-STATUS = 0 AND DB-CHAIN-LENGTH > 0

    DISPLAY "I HAVE RECORDS"

ELSE

    DISPLAY "NOTHING HERE FOR THIS CHAIN VALUE" 



Michael Berkowitz / Project Manager

CGS / BlueCherry

213 614-1308

[log in to unmask]



Please join us for the 2005 CGS International User Group

September 25 – 28, 2005, The Venetian Resort Hotel and Casino

Visit www.cgsinc.com/ug2005 for details and registration