Forum Stats

  • 3,854,212 Users
  • 2,264,340 Discussions
  • 7,905,609 Comments

Discussions

oracle form 6i list item

niceali
niceali Member Posts: 19
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
Tagged:

Answers

This discussion has been closed.