|
|
Re: problem with a running form [message #268820 is a reply to message #268632] |
Wed, 19 September 2007 18:53   |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Is this your first form? Have you been on a Forms training course? Go to the Oracle Forms website (see sticky), go to the section on Sample Code, download something that sounds interesting and work through it.
David
[Updated on: Wed, 19 September 2007 18:53] Report message to a moderator
|
|
|
Re: problem with a running form [message #270417 is a reply to message #268820] |
Wed, 26 September 2007 18:28   |
orame
Messages: 2 Registered: September 2007
|
Junior Member |
|
|
hello thanks for your replay
yes this is my first form thats why i dont know what the problem is
i wrot this code to a 'WHEN-new-form-instance'
declare
cursor curs is select name from phone;
a varchar(30);
n number:=0;
cursor cursd is select distinct(dept) from phone;
b varchar(30);
m number:=0;
begin
clear_list('listview');
clear_list('Dlistview');
open curs;
loop
fetch curs into a;
exit when curs%notfound;
n:=n+1;
add_list_element('listview',n,a,a);
end loop;
open cursd;
loop
fetch cursd into b;
exit when cursd%notfound;
m:=m+1;
add_list_element('dlistview',m,b,b);
end loop;
end;
___________________________________________________
do you think theres somthing wrong????
|
|
|
Re: problem with a running form [message #270437 is a reply to message #270417] |
Wed, 26 September 2007 21:45  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Please use 'code' tags when posting source code.
What do you want your form to do? Why are you populating lists when you can define them and LOVs more easily in the Forms Builder and then just associate the LOV with an item?
Go to the forms website and download an example form. Open it up in Forms Builder, LOOK at it and run it.
David
|
|
|