Forms :: How To Create Multilingual Form
Feb 4, 2011My requirement is to create Multilingual form. Its very urgent. In fact if i want to make it work in 2 languages. English and Chinese.
View 1 Replies
ADVERTISEMENT
Forms :: Create Login Form In 10g?
Jun 17, 2011how to create a login form in forms 10g how upload login.fmb
View 2 Replies View RelatedForms :: Create A Form For Ordering
May 25, 2010i create a form for ordering>>>that the person can enter his/her information and isbn book to make the order,but the order id i make it sequentially! well first of all i create a data-block and i insert only the oid in trigger when-new-item-instance..i had create the sequence:
declare
create sequence seq1
start with 90
increment by 10;
end;
and i make a view form such of fields that user can enter a details o what he/she want to order!!
1- is that enough?
2- it seems there is an error in creating the sequence?? wrong way to create the sequence!!
Forms :: How To Create Login Form
Oct 23, 2013I have made few forms , but i want only those users to access these forms who have valid login and password to access these forms.
For example i have created one form employee details (shows the details of emp table in tabular form) which is based on emp table.
The users are scott having password tiger ,and User Test having password Test. i want to make a login form to give access to only these users to access employee tables. if someone else tries to access it then it should show Unauthorized login error.
My requirement is i want to create a basic login form which includes
Login i.e Text_item
Password i.e text_item
Login i.e push button
what should be the queries behind these items. and how to connect this form to database. I am attaching file , just add working codes in that or you can write codes here also .
Forms :: How To Create Sequence In Form
Jan 13, 2013I know how to create sequence in the database.But I want to create this sequence from the form by giving the name of the sequence from a filed in the form.
View 1 Replies View RelatedForms :: Create Directory With Oracle Form PL/SQL
Jan 16, 2010i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g
my problem is when i use this code
trigger WHEN-BUTTON-PRESSED
EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';
IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"
I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');
trigger WHEN-BUTTON-PRESSED
WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');
BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "
How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();
Forms :: How To Create MASTER_DETAIL Form Manually
Oct 25, 2013I know how to design master_detail form using wizard but i want to create it without using wizard.I have created two blocks emp and dept without using wizard ,and connected them to emp and dept table by changing their properties.Now i want to create relationship between these two blocks, My requirement is when i press execute_query button if deptno is 10 in dept block then emp block should show data for deptno 10 only.
I know it can be done using add relationhip option in dept block (which is master block)but how to do that.
Forms :: Create Login Form With Validation
Dec 4, 2010I just need to create a login form ..its like user will login using his given id and password will be encryted when entering and i just need to simple validation that if he has entered corrected password it will display message ok or else wrong password.
View 3 Replies View RelatedForms :: Create Hyperlink That Open Another Form
Sep 18, 2010i was create simple two forms in the first forms i want to create a hyperlink that open another forms.
View 1 Replies View RelatedForms :: How To Create Form Dynamically At Runtime
Dec 26, 2011I am working with forms 6i..Is it possible to create form dynamically at run time..
View 2 Replies View RelatedForms :: How To Create Browse Button In Oracle Form Builder
Mar 19, 2010I would like to create a browser button which enables to browse a tree directory and to select a file. how can i do it?
View 1 Replies View RelatedForms :: Create A Form To Store Any Excel / Word Files?
Jul 1, 2011i m using oracle 10g forms.
i want to create a form where i can store any excel / word etc files.
Server Administration :: Query Regarding Multilingual Database
Nov 16, 2011For setting multilingual database which will have application data in Japanese I am preparing as follows....The database server is Linux and database is 10g (10.2.0.4) For storing Japanese characters in the database I am creating a database with AL32UTF8 character set
1) Do I need to change any settings on the Linux server just for handling Japanese characters? (In case it would have been windows database server would I need to change regional settings and/or any other OS settings to Japan etc?)
2) Assuming that a Japanese character will not fit in a single byte and default for semantic for char and varchar being byte, do...I need to change nls_length_sementic to char?
3) Apart from some more space requirement and performance impact on string functions will it cause any other adverse effect?
4)I would select Japanese character set -say JA16SJIS, instead of super UTF compliant AL32UTF8? What would be advantage of using AL32UTF8 over using Japanese specific character set?
5) Do I need to set nls_lang on the Linux server?
6) Users will be connecting to Linux server using putty or sqlplusw from windows Which operations will need the client to set nls_lang? To what value?
7) Apart from setting nls_lang on the client (if needed) as in question 6), are any settings needed on the client for inserting and displaying Japanese characters? e.g. regional setting, font setup, codepage setup.
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Forms :: Opening Form Has Attached Libraries Caused Form Close
Jul 19, 2010If I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
Forms :: Want To Call Web Form For Uploading Image From Custom Form
Apr 16, 2013I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies View RelatedForms :: How To Reload Calling Form After Closing Called Form
Jul 15, 2007I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
Forms :: 2 Different Form To Pass Values From One Form To Another
Mar 11, 2010is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.
View 1 Replies View RelatedForms :: Any Way To Load A Form Within A Form
May 21, 2010I have a requirement, is there any way i can achieve the following User Interface using oracle forms
Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.
The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.
Forms :: How To Open Another Form Within A Form
Dec 20, 2012I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.
In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.
This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.
Forms :: Pre-form And When-new-form-instance?
Mar 1, 2010What is the difference and significance of
1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?
Reports & Discoverer :: How To Create Parameter Form In Descriptive Format
Jan 28, 2013I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.
parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?
Application Express :: How To Create A Display Field In Tabular Form
Oct 1, 2012I am stuck at point.
using apex 4.1, created tabular form for inserting values from customer with a simple query
table name : customer
select
USER_ID ,
USERNAME,
PASSWORD,
STATUS,
PRODUCT_ID
from CUSTOMER
I WANT TO FETCH THE NAME OF PRODUCT FROM ANOTHER TABLE NAME PRODUCT_NAME, I WANT THAT WITH TABULAR FORM COULMN OF PRODUCT NAME IS ALSO DISPLAYED, HOW I DID THAT ? JUST WANT TO ADD COLUMN FROM ANOTHER TABLE IN TABULAR FORM.
WHEN I ADD TABLE NAME IN FIRST QUERY IT IS NOT WORKING GIVING ERROR ABOUT NOT JOINING THE TABLE
Application Express :: Coding Stored Procedure - Create Material IN And OUT Form
Nov 21, 2012I have to develop an application for a store, where some material In and Out on daily basis. and i want to see current status any time.
How to do that means coding of stored procedure, on whose basis i can create material IN and OUT form.
Application Express :: How To Create Validation Only For Created Rows In Tabular Form
Sep 19, 2012Is it possible to create a validation for tabular form which will be fired only for created?
There is a possibility in APEX 4.1 to choose two types of "*Execution scope*" first is "*For created and Modified Rows*" and second is "*All Submitted Rows*".
Application Express :: Clearing (or NOT) Form Fields After ARP CREATE Or DELETE Operation
Jan 15, 2013I understand everything -- <gripe> need better Automated Row Fetch (ARF) documentation </gripe>, but I now have CREATE, QUERY, and DELETE working and I can choose to clear the form (or NOT). And I don't claim this is the best or simplest or most-efficient or most straight-forward approach. It's one virtue is that it does seem to work.
I need to be careful state that this involves both Automated Row Processing (ARP) -- which enables INSERT, UPDATE and DELETE. And Automated Row Fetch (ARF) -- which enables SELECT. ARF is found under Page Rendering and ARP is found under page processing. As we have seen, the two are -- or can be -- interdependent. For example, I believe the error I talk about next is caused by ARF trying to fetch the record just deleted by ARP.
Starting from the situation of
1) having the values retained on the screen when CREATE is clicked and the record is added and
2) getting a database error after a DELETE of a row, A solution is the "reset" processes. Under Page Rendering add a "reset page" process to: "Clear Cache for all Items on Pages (PageID,PageID,PageID)" and indicate the page with the database operations and under Conditions: When Button Pressed: choose CANCEL, CREATE, DELETE, QUERY or SAVE. I made two of these - one for CREATE and one for DELETE. To cover both buttons, you need two processes as you can only indicate one button per process.
Now the form (screen) is cleared after the CREATE (by process
1). And since it's also cleared after the DELETE (by process
2), there is no Database error on DELETE.
(The source of that error was ARF trying to retrieve the deleted record because the PK field had the "just deleted" key value. This nulls it and I have ARF set not to attempt a fetch when the key field is null.
So, how about that? Burleson has an example here which adds more detail than I recall seeing before.URL>....
I think the DML Fetch Mode settings he shows are new to the ARP screen in 4.2. I don't see them in 4.1.
Forms :: Add Sub Form To A Form
Apr 26, 2011I have a main form of "sales contract". I want to add sub form to take input for commission & shipment details in separate sub forms.
When I click a button on main form, system should open sub form, in which I enter the detail.
Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black
Sep 23, 2011I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
Application Express :: Create Items Context Help Editable Report Or Report And Form App
May 9, 2013How do I create Items context help editable report or report & form app?
what is its table?
Reports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report
Nov 29, 2011I am trying to open report in parameter form in drill down report.
View 7 Replies View Related