This discussion is archived
1 Reply Latest reply: Apr 25, 2013 12:55 PM by Christian.Shay - Oracle RSS

oracle form 6i list item

niceali Newbie
Currently Being Moderated
hello
can anyone help i am using oracle form 6i. two tables emp and file_ref. in my emp block i have file no as text item. and from file_ref i have docname. i want to take a list item in which all and letter
if listitem is all then all docname displayed
and
if listitem is letter only those docname which names starting word letter should display

i use this
     begin
     set_block_property('FILE_REF',default_where,
'fileno ='||chr(39)||:emp.fileno||chr(39)||'and docname='||chr(39)||:file_ref.list_item1||chr(39));
go_block('FILE_REF ');
     execute_query;
     end;

and a error generated
bad bind variable

can anyone help pls

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points