In message <[log in to unmask]>, aHash 
<[log in to unmask]> writes
>Hi all, I am new to the group as well HP3000. Glenn from tek-tips introduced
> this group to me. Thanks to him.
>
>I am trying to do an insert on table. Which has all the three columns as keys
>and is a detail dataset. It has on column as P8.
>
>I have two questions.
>
>1. What should I do to insert a record in this table using QUERY. The P8
>coulmn wont take my regular number(e.g 1234560). It is displayed as 123456{

It does that - it's showing as zoned.

Try looking at the record with R ALL,-

Then you should see that your 0 is in fact intact.

>2. I wrote a small program based on an existing program.

>Can I not insert a detail row for an existing master entry?

What we call 'adding a detail record' in Image parlance. Yes, you can - 
nothing should be stopping you.

However, if you have three columns ('fields' in Image parlance) which 
are keys, then these will key off three separate master datasets - i.e. 
it's a row for all three masters.

It then depends if these are Automatic or Manual masters.

If any of them are Manual masters, then the master entry for the key 
field value must exist before a detail using that value in the key field 
can be added.

But if they are Automatic masters, then the key value will be 
automatically created when you add the detail record.

> customer some how wants to reopen the master entry after a long time. 
>But there is no detail entry for it, because when the status column of 
>the master entry changes a different detail goes away (by an update).
> How do I handle this?

A master is a master - just display the master record to the customer. 
As it has more than just the key value, it's obviously a manual master, 
so it has data you can show the customer.

If there is a program which, for some reason, deletes one or more detail 
records when the master is updated in some way, then that's how it is.

Showing the detail record(s) for that manual master is a separate step.

But I have to confess that I don't quite understand what you are saying 
here, despite 8 months on IPI for TCS.

If I haven't covered it, can you please describe this better?


-- 
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 *