In message
<[log in to unmask]>,
Venkataraman Ramakrishnan <[log in to unmask]> writes
>Hi

>I was recently trying to update some records in a "Detail Data Set" in
>Turbo Image using SUPRTOOL, As I wanted to update a Search Item I was
>using the CIUPDATE option to do the same.
>
>But I was getting the following error, have copy pasted the error below.
>
>---------------------------------------------------------------------------
>
>TURBOIMAGE RESULT AT $00000000: RETURN STATUS = 17
>
>DBUPDATE, MODE 1, ON #6 OF PINDB.DATA
>
>NO CURRENT RECORD OR THE CURRENT RECORD IS EMPTY (CONTAINS NO ENTRY)
>
>---------------------------------------------------------------------------
>
>But when I tried to read the record using Suprtool Get/Chain I was able
>to read the record successfully, also when I used the Query option I
>was able to read the record.

Which record could you read? The updated record with the new search item
in, or the original record that you were trying to update? My guess is
the latter...

>Also I checked the Automatic master corr. To the detail dataset, there
>also the corr. Record is present.

For this to be a 'the' implies certain specifics in your database schema
- that there is one and only one Search item in your detail dataset, and
that this is linked to that one and only one Auto master. Are you sure
this is the case?

>When I looked up the Manual the description for this error mentions
>that either the "Master" record is not present or the "current" record
>is not present, hence this error.

>But this is not the case as I found the records...when doing a read....

Well, you checked on 'or the "current" record is not present'. But did
you pay enough attention to 'either the "Master" record is not present'?

Hypothesis: your detail dataset has more than one search item; there is
one linked to an Auto Master, which you have checked. But there is
another, linked to a Manual Master, which you have not checked. And this
is the item you are trying to change. And you are trying to change it to
a value which does not pre-exist in that Manual Master. And hence your
update fails.

Further hypothesis: The Manual Master in question is dataset #6 in your
DB; #6 is the number neither of the detail set you are trying to change,
nor of the Auto master you were looking at.

>Can anyone please help me out.....
>Warm Regards,
>Venkat

Write a Manual master record for the Search key first, if necessary,
then your update will succeed.

But am I to understand that you are using Suprtool, with no data
validation, to update your database?

If so, do please bear in mind that while Image has perhaps just saved
you from breaking the structural integrity of your database, it cannot
prevent you breaking your data integrity, at a perhaps more subtle
level.....

--
Roy Brown        'Have nothing in your houses that you do not know to be
Kelmscott Ltd     useful, or believe to be beautiful'  William Morris

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *