Re: DUPLICATE key in Index/Sql*Forms30

Ron Olshavsky (rono_at_clark.net) wrote:
: Farnham Dave (farnham_at_spot.Colorado.EDU) wrote:

: : Scenario: I have four block in a screen.
: : I am entering data for the FIRST time
: : in blocks 1 and 2, and then in 3 referenciing
: : an existing record in that table for that block,
: : and then entering new data in block 4.
 

: : By the way, these are all base table blocks.
 

: : When I hit the commit key, Block 3 gives me an
: : error saying duplicate key in index. I'm not
: : trying to enter new data in block 3, just use an
: : existing record that already exists in my table....

I once had a similar scenario where I needed to have a master block and two parallel detail blocks that both pointed to the same database table. I wanted to do the same sort of thing, but I was having the same kind of problem. I was told by Oracle that having 'horizantal' detail blocks (as they reffered to it) was not supported in 3.0 but would be in 4.0

That is that. I never was able to get a good solution . If you get one, let me kn ow.

-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs_at_netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------