Home » Developer & Programmer » Forms » problem with a running form
problem with a running form [message #268602] Wed, 19 September 2007 02:49 Go to next message
orame
Messages: 2
Registered: September 2007
Junior Member
hello every one

im using developer 9i and i just build a phone directory form to view employees phone Numbers and other info the problem is when i run this form of course it will run in internet explorer page but it wont show the data until i add any thing in any field and press the save button in the running form

also i have another problem i put a listitem in the form to search for employees by their department but when i click on specific department it only shows one employee and i cant go to the next employee using the forward button in the toolbar

can you plzzzz help me Embarassed
regards Smile
Re: problem with a running form [message #268632 is a reply to message #268602] Wed, 19 September 2007 03:57 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What did you do to the form so that it doesn't work properly?

If you used a Data block wizard, form would - by default - be able to display all information when you EXECUTED a QUERY. As you mentioned "adding data into an item and commiting changes", I'd say that you wrote additional code which ... well, does something.
Re: problem with a running form [message #268820 is a reply to message #268632] Wed, 19 September 2007 18:53 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: how to export or import data to excel from database
Next Topic: Flag Set
Goto Forum:
  


Current Time: Mon Feb 17 05:46:35 CST 2025