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{ 


2. I wrote a small program based on an existing program.
Can I not insert a detail row for an existing master entry? 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?

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