Hi All :)
i want to display all the records of my database in a table with scrolling
example if i have 3records in my DB so a table must have 3records too !!!
this is my code :
Cursor cur IS
SELECT numb_ph AS phone,
name_emp AS name
FOR s IN cur LOOP
:emp.numb_ph := s.phone;
:emp.name_emp := s.name;
but the problem 's all records of my DB are display in one record (to view another record i use the scrolling ..
Is there any special requirement that you have to do it manually, if not use datablock wizard to create your datablock,Just follow the wizard, once the database block is created the wizard automatically opens the layout wizard where you can select
the fields you want to be displayed.
Select form or tabular format
give the number of records you want to be displayed
from the same screen you can even select the display scrollbar option
thnx for the answer and for the link :)
but i do not want choice the number of records to display because the table will be malformed ..
example :if i have 2 records in my DB and i chose 5records to be display in the table so 3 records will be unoccupied !!!!
It will not insert blank record into table(if you make any of the field's required propery to yes form will not let you save without entering data into that field). You can display other fields as well.