Form notes 2

How to connect text field to text field of data base table?
As we know that the data process from data base tables first we want to delete all old items which are situated on canvas or data blocks we do the clean the blocks and canvas due to place of new items or new data blocks.that's why we want to delete old item then we make the items or form as per our requirements so do not worry about it just follow my steps.you can make the new form which are connect to data base fields.

  • First we can delete all data blocks also we delete canvas to add new canvas.
  • we add 3 text field just go to text button left side of your frame just drag and drop here 3 text fields are
⍇⍇⍇ names are text0,text1,text3
set the text fields which are properly aliened and we level the text fields you just go to left side of text fields items here you see the add button to level the text field.the symbols of add level the text field is (A).  
⍇⍈⍈ department no ,department name,location
⍇⍇⍇item0,item1,item2
we can changed the value of text field such as dept_no ,d_name,loc.
NOTES:-
when we add items on a canvas automatically created a data block such as (block09) on object navigator then we changed the name Block09 to Dept here we can add name of the table you just right click and go to properties palate .here window is open then we go to data base properties further go to the data source type and finally insert the table
→ Here we go to query data source name(we add table name Dept) then minimized the window
we can attached or bind items(like dept_no,d_name,loc) then we want to connect items to dept no field in dept table(we can attached the dept no of dept table fields items) just click on items such as dept no,d name,loc then open properties palate ↓
data→data type(changed to number)→max size (yes)→data items(yes)→column name(dept no)
As we can do same task for two text field or items.
we need to compile it and run the form further go to query option and execute it
NOTES:-we can changed the ordering of field when we go  to canvas if we can changed the ordering of field having no any effect of field items.⇓
saved
⇓
run
finally record are available
⍇⍇⍇ its a manual data blocks. 

Comments

Post a Comment

Popular posts from this blog

Sql If Condition

Image
if condition use and if condition make result set .we are just confirming messages where you want to type and where you want to display .it might to declare local variable and getting some value .either greater then and less then the result will display on the screen on your SQL server . here we observed if statement .you can use as select statement and more .  
Read more

GST AND GST TABLES IN ORACLE APPS

What is GST ? Goods and service tax is an indirect tax throughout India to replace taxes levied by the central and state governments. when goods and service taxes implemented, there will be three kinds of applicable goods and services taxes. CGST Where the revenue will be collected by the central government. SGST Where the revenue will be collected by the state government for intra-state sales. IGST Where the revenue will be collected by the central government for intra-state sales. Below is the comparison between new and old taxes regime TRANSACTION                NEW REGIME                  OLD REGIME                         COMMENTS Sale within  state                 CGST+SGST                     VAT+central excise/service       revenue will                                                                                          tax                                             be shared                                                                                    
Read more
WHAT IS RECORD ? Record is a composite data structure which hold data items of different kinds.Record consist of different fields similar to a row of data base table. 1)table base 2)cursor base record 3)user defined record To create table base or cursor base record we prefer % row type attribute which provide record type to represent a rows in data base table.record can stored rows from data base table or fetch from  cursor variable and cursor. e.g of table base declare v_rc employees.%rowtype; begin select * into v_rc from emolyees where employee_id=100; dbms_output.put_line('employees details:'||'v_rc.last_name||v_rc.first_name||v_rc.salary); end; 2)cursor base record declare cursor c_rec_emp is select last_name,employee_id,salary from employees v_c_r c_rec_emp.%rowtype; begin open c_rec_emp; loop fetch c_rec_emp into v_c_r; exit when c_rec_emp %notfound; dbms_output.put_line('employee datails:'||v_c_r.last_name||v_c_r.employee_id||v_c_r
Read more