daogu

saniao
December 9, 2010

CURRENT RECORD

Posted by : admin
Filed under : Forms

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.


Answer: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.


Answer: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


Answer: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/


Answer:thanks

but still the same code is not compiling in forms 6i

any way i am trying to do it

thanks once again


Answer:It works for me in Forms 6.0

David

Related posts:

  1. display_item /* sample code to set background display of a...
  2. How i get Last Record of Current Data Block using forms 6i Dear I am using forms 6i i want to...
  3. FRM-40102: Record must be entered or deleted first Any ideas why am I getting following error message...
  4. FRM-40508 : ORACLE error: unable to INSERT record hello all.. i got an error frm:40508 . pls...
  5. How to use LIKE operator in develoepr 10g Dear Experts, i wrote the following code, its executing...


No Comments

(required)
(will not be published) (required)
(opitional)