Well, I just tested it out, 12/21/02, on Xe on AS400, but first came across this long, long ago (B7.3.2 or B7.3.3) on a unix server (HP3000?) and (I BELIVE but not sure) that I have also done this on a SequelServer using Sequel7. I'm not sure if those are the right terms.
Have you (I wanted to say "you all"), or any of you try updating keys with a Headerless/Detail (Hdls/Dtl) and had it not work?
( I only noticed the following on the AS400 and never had a chance to go back and look at the other systems)
The Hdls/Dtl form has an interesting feature to it, that regardless of the fields in the grid, the form will update all the fields in the business view even when they are not in the grid. And, the update will assume that those missing grid columns are blank. Imagine my suprise when fields were getting updated and not even in the grid! I also found that form level filter fields tended to update to the database, so if you're going to test my theory then you'll want to leave the filter fields off of the form and stick to the QBE.
** Note - I typically verify my statements before posting them on this site. In this case, I verified the ability to change keys only and have NOT verified this last paragraph to see if it only occurs in certain circumstances.
Here are the steps I went through to test this out.
1) Created test TBLE with 4 key fields and two non-key fields. Generated TBLE.
2) Created test BSVW with all columns.
3) Created test APPL with Find/Browse with all columns. Select Form/Exits (I know this is not good practice having a Row type exit interconnecting to a form without filtering) to a Hdls/Dtl form with only a grid for all columns, QBE added and a Find button added. And then I tested it. Creating this test took less time than I took to write this reply. So how about it? Anyone want to try this on their system and see if it works?
Ben again
I know I should post my system info here
but it keeps changing and I can never remember
what it is, so I only look it up when I ask a question.