Home » Developer & Programmer » Forms » CURRENT RECORD (FORMS 6I)
CURRENT RECORD [message #339958] Sun, 10 August 2008 06:25 Go to next message
sajidrazmi
Messages: 47
Registered: August 2008
Location: oman
Member
HI EVERYBODY
I HAVE WRITTEN THIS CODE IN POST-SELECT BUT IT IS GIVING ERROR

DECLARE
CUR_ITEM VARCHAR2(80);
CUR_BLOCK VARCHAR2(80):= :System.Cursor_Block;
BEGIN

CUR_ITEM := GET_BLOCK_PROPERTY(CUR_BLOCK,FIRST_ITEM );
WHILE (CUR_ITEM IS NOT NULL )
LOOP
CUR_ITEM := CUR_BLOCK ||'.'||CUR_ITEM;
SET_ITEM_INSTANCE_PROPERTY (CUR_ITEM,CURRENT_RECORD,VISUAL_ATTRIBUTE,'DISP_ONLY_LOOK');
CUR_ITEM := GET_ITEM_PROPERTY( CUR_ITEM, NEXTITEM );
END LOOP;
END;

I AM NOT COMPILING IT IT GIVES ME ERROR
PLEASE HELP ME.
Re: CURRENT RECORD [message #339985 is a reply to message #339958] Sun, 10 August 2008 14:39 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If only we knew which error it was ...

Perhaps you'd want to read the OraFAQ Forum Guide and learn how to properly ask a question.
Re: CURRENT RECORD [message #340008 is a reply to message #339985] Mon, 11 August 2008 00:13 Go to previous messageGo to next message
sajidrazmi
Messages: 47
Registered: August 2008
Location: oman
Member
hi dear
when i am going to compile it gives that error

begin declare exit for goto if loop mod null pragma raise return select update while an<identifier> <a double quoted delimited identifier> a bind variable <<close curent delete fetch lock insert open rolback
save point set sql commit <a single-quoted sql sting>
the symbol ''''was ignored

i have written this code post-select trigger
Re: CURRENT RECORD [message #340036 is a reply to message #340008] Mon, 11 August 2008 02:29 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, I don't have Forms 6i so I can't test it, but the very same code is successfully compiled on Forms 10g:

./fa/4766/0/
Re: CURRENT RECORD [message #340043 is a reply to message #340036] Mon, 11 August 2008 02:52 Go to previous messageGo to next message
sajidrazmi
Messages: 47
Registered: August 2008
Location: oman
Member
thanks
but still the same code is not compiling in forms 6i
any way i am trying to do it

thanks once again

[Updated on: Mon, 11 August 2008 03:21]

Report message to a moderator

Re: CURRENT RECORD [message #341415 is a reply to message #340043] Mon, 18 August 2008 18:22 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
It works for me in Forms 6.0

David
Previous Topic: how to go for a spcified record in a block
Next Topic: populate list element at run time
Goto Forum:
  


Current Time: Thu Dec 08 02:07:25 CST 2016

Total time taken to generate the page: 0.06970 seconds