Forms :: How To Make Oracle Application Always On Top
Feb 13, 2010I want to make oracle application "always active" or "always on top" automatically when windows logon as feature provided in task manager.
View 2 Replies
ADVERTISEMENT
Forms :: Make Excel Dump For Some Banking Application Using 6i?
Jun 17, 2010I am trying to make an excel dump for some banking application using Forms 6i . I am making use of OLE to make an excel dump. I have a small problem while using this OLE concept . I have an Account column which is is having the data type VARCHAR2 at database level . when i try to make a excel dump of this column , then the values in the account number column in excel is getting converted into number column . Eg: A/c - 000123 is appearing as 123 in excel. How this can be retained as 000123 in excel sheet .
test case -
actual value appearing value in excel
000123 123
code extract in hv used -
args := ole2.create_arglist;
ole2.add_arg(args, rowcount);
ole2.add_arg(args, colcount);
cell := ole2.get_obj_property(worksheet, 'Cells', args);
ole2.destroy_arglist(args);
ole2.set_property(cell, 'Value', rec1.BANKNR);
ole2.release_obj(cell);
Application Express :: How To Make Use Of SSO Login Credentials Of Oracle In Authentication Schema
Jul 16, 2013I am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.
View 0 Replies View RelatedForms :: Make Calendar In Oracle 10g
Sep 15, 2011I want to make calendar in oracle form 10g, but i don't know make it. How to do make calendar?
View 2 Replies View RelatedForms :: How To Make Calculator In Oracle 6i Or 10g
Jul 22, 2013Is it possible to design calculator in oracle forms 6i or 10g?
View 2 Replies View RelatedForms :: How To Make Browse Image In Oracle 10g
Apr 17, 2011how to make browse image in oracle form 10g?
View 1 Replies View RelatedApplication Express :: 4.2 - Make URL Shorter?
Mar 22, 2013I am using apex 4.2, mod_plsql
the url of application is very long, is there any way to make it short
Application Express :: How To Make A Multiline Label
Jul 19, 2012how to makea multiline label. I have couple of text fields and would like to have the label divided in two lines for each of them. I tried with new line character etc. however didn't succeed.
View 2 Replies View RelatedApplication Express :: How To Make Error Message Red
May 20, 2013A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,
I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?
Application Express :: How To Make Use Of Error Template Control
Oct 2, 2012I actually have tried to read the Customizing Templates chapter of the Users Guide. According to that guide, the following substitution strings are supported in the the Error Template Control section of page templates.
#MESSAGE# and #ADDITIONAL_INFO# - Places the error message.
#TECHNICAL_INFO# - Displays detailed internal error information which will just be visible for developers.
#BACK_LINK# - Displays a link back to the previous page.
#OK# and #RETURN_TO_APPLICATION# - Returns to translated text strings.
However, if I enter the follow code
<p> message: #MESSAGE# </p>
<p> additional info: #ADDITIONAL_INFO# </p>
<p> techie stuff: #TECHNICAL_INFO# </p>
<p> back link: #BACK_LINK# </p>
[code]........
return to application: Return to application.
It appears that only the first substitution string is doing anything. I'm especially interested in additional info and technical info. The back_link just looks like an html snippet, not sure why I would use a substitution string for this. I imagine the last two could facilitate site translation, but that doesn't work much if there is no machinery for translating error messages themselves.
Application Express :: How To Make Default Attachment As CSV File Instead Of HTM
Oct 28, 2012I am having an interactive report with an email subscription.
My question is, how can I make the default attachment as a .csv file instead of the .htm file?
Application Express :: How To make Item Mandatory Dynamically
Oct 24, 2013How to make an item as a mandatory field dynamically with the change of another item in different regions
View 10 Replies View RelatedApplication Express :: Make Fields On Form-page More Accurate?
Oct 18, 2012How to make fields on form-page more accurate? I want make fields one under another one, and control the distance between them.
View 3 Replies View RelatedApplication Express :: Where To Make Changes To Calendar Height / Width And Misc
Nov 13, 2013Apex 4.2I have a page with a calendar on it. I have several issues with formatting the data within each cell. Currently, I use a substitution string to place the id in the calendar cell.
Clicking the id will link to another page. What I notice is that for each id on a calendar cell (or date), it lists them one under the other. Is there any way to list them side by side? Also, I need to make changes to the calendar cells. I would like to expand the width and the height, but am not sure where to do this.
Application Express :: How To Make Report Column Non-editable In Master-detail Form
Jun 20, 2013I have created a master-detail form. The detail columns are created as report columns instead of getting created as Items. I need to make a column non-editable.
View 1 Replies View RelatedApplication Express :: Store Encrypted Numeric Value And Make Unencrypted Value Visible To Just Some Users In Apex
Jul 3, 2013I'm looking for a way to store an encypted numeric value in one field in a table (so that it appears encrypted even to a DBA) and to display the unencypted value in Apex forms and interactive reports for some users but not others.
View 4 Replies View RelatedForms :: How To Make A Calendar
Mar 4, 2003I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?
View 20 Replies View RelatedForms :: How To Make A Node
Feb 27, 2012How to make a node of a Hierarchical Tree BOLD without intervene java code ?
View 1 Replies View RelatedForms :: Make Field Non Editable
Jul 29, 2010I have a field on the form which is a database field and the value is populated by a LOV. The user should not be able to edit the value selected or enter his own values in the field. Basically the field should only be populated by the lov and should not be editable.
I tried using the SET_ITEM_PROPERTY('XX.XX', UPDATE_ALLOWED, PROPERTY_FALSE); but this only disable update against existing value. If a user selects a new value from LOV that can be edited.
Forms :: Make Cursor At The Item
Jan 25, 2013I have a button "clear" , I want when the button is clicked the items will be cleared and the cursor is at the first item, here is the
:emp.id:=null;
:emp.ename:=null;
:emp.sal:=null;
go_item('emp.id');
=>but the problem that the item changes color, but the cursor remains at the button "clear"
NOTE:
I used the "when-new-item-instance" trigger to change the color of text items
Forms :: Make One Form For Many Systems
Mar 4, 2013make one form for many systems i have (i.e) I need to make it like portal many button for many systems When i enter the button i login to specified system (i.e) I need to make new connection to this schema and disconnect the previous one.
View 1 Replies View RelatedForms :: How To Make Block Query
Jan 30, 2012I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.
View 12 Replies View RelatedForms :: Make Field Protected Against Update?
Apr 29, 2011What i am required to do is to protect a field 'COUR_CODE' from update when the SHIP_METHOD='R'. c
if :system.record_status = 'INSERT' then
declare
vcour_code ACCOUNTS.cour_code%type := NULL;
vcourier_account_no ACCOUNTS.courier_account_no%type := NULL;
canvas_name varchar2(30);
begin
[code]....
Forms :: How To Make Query Mode Work (f11)
Apr 2, 2012I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.
View 18 Replies View RelatedForms :: How To Make Demand Wise Report
Jul 3, 2013I have a payment table that has the ids of cds that has being sold in the past month. From there I want to make a demand wise report. I am aware of the report wizard in the oracle forms but I dont want to use it. Here are the tables in a bit more details.
payment: id_cd, price, dateofsell
cd_details: id_cd, name, price, language.
Make Oracle Tree In Specified Format?
Apr 6, 2013---------------------------script of table for tree--------------
create table eqpt_mast
(
EQPT_ID VARCHAR2(16),
EQPT_CODE VARCHAR2(9),
PARENT_CODE VARCHAR2(9),
[code]....
output of tree like:-
grandf(0)
|__
---father1(1)
[code]...
i want to make tree like the above format.In the above tree "(value)" shows the code_type i.e. level of the tree..
version----Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
Forms :: Unable To Make The Form Fields Available To Edit
Jan 30, 2013My requirement is to call a form through special menu icon from one main form and display some information. Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit. I am displaying a record based on a view.
For that i have used below code in when-new-form-instance
- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');
After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.
I have added below piece of code
set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);
in almost all the triggers and tried. I could still see all the fields are read only.
Forms :: Make Print Button To Display Information
Oct 4, 2012how can i put button in a form to print the information i displayed in this form.
View 1 Replies View RelatedForms :: Make Push_button To Act As Browse Pictures Files?
Feb 19, 2010How i can make a push_button to act as browse the Pictures files only to upload in Image Box. At Commit store in my Database.
View 1 Replies View RelatedWorkflow :: How To Make Node To Deferred In Oracle
Aug 17, 2012How to make node to deferred node in oracle workflow ?
View 2 Replies View Related