a very basic form:

1. create a new form
2. create canvas
3. create a block.
edit properties.
set Number of Records Displayed => 10 or greater
show scroll bar => yes
scroll bar canvas => <canvas name>

4. add a text item to the block.
edit properties
set item type => text item
data type => char
maximum length => 30
visible => yes
canvas => <canvas name>

5. add 2 buttons to the canvas, one to process query, one to exit the form

6. add when-button-pressed triggers to each button.
edit properties:
item type => push button
number of records displayed => 1

7. pl/sql for query button

declare
cursor mycur is
select table_name
from user_tables;
begin
for i in mycur
loop
create_record;
:<text item name>:=i.table_name;
end loop;
first_record;
end;

8. pl/sql for exit button
exit_form(no_validate);






-----Original Message-----
From: Poole David
[mailto:oracledba-ezmlmshield-x7771518.[Email address protected]
Sent: Tuesday, November 30, 2004 7:28 AM
To: LazyDBA Discussion
Subject: Basic 'Oracle Forms Builder' Query


All

Can anyone provide me with a step by step example of how to create a basic
form using Oracle Forms Builder that when the user presses a button a simple
database query executes (i.e. select table_name from user_tables;) and
displays the results in a text box?

At the moment I have Developer Suite installed Oracle Forms Builder open
with a database connection.

Thanks

David



Systems Operations, Thus Plc.
.
. . _
www.thus.net www.demon.net
email. david.[Email address protected]
internal. 740 4156
external. 0141 566 4156
mobile. 07880 502093


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page