SQL Forms 3.0 - Automatic Block navigation, How ?

I have ORACLE 6.0 installed on Unix ( SUN IPC ).

I am using SQL Forms 3.0 for my application.

Now, In one of my forms, I have two blocks. My master and detail blocks each correspond to two different tables. During addition of details( using KEY-CREREC ), after adding the master details, the cursor remains in the last field of the Master block. I am not automatically able to go to the Detail-Block.

For this, I tried using GO_BLOCK() with block name in ON-VALIDATE-FIELD of the last field of Master Block. No dice. I get "Illegal use of restricted package .. BAM BAM BAM !'. If I replace the GO_BLOCK invokation with NEXT_BLOCK also No Dice. If I try DO_KEY('KEY-NEXTBLK'), still ND.

My Form validation unit is 'FIELD'. As far as I can see, I don't see any alternative. User has to press [Next Block] key, at the end of Master block entry.

Any help from out there please ?

Thanks in advance,

Sridhar

My Email : SRIDHAR_B1_at_blrv1.verifone.com

P.S : Hi Jonathan ! Any help ? Received on Mon Jul 13 1992 - 12:06:20 CEST