Application Express :: How To Change Column Type At Runtime In 4.0

Apr 3, 2013

I´m newbie as Apex developer using Apex 4.0 with OracleXE 11.2, and now my problem is:

I have a tabular form where one of the columns, when calling the form, is a Display Item, so that you cannot change existing values​​.

I want, when adding a new row, that column become a Select List (named LOV) based on a query that exclude existing values ​​in other rows already inserted.

Can I change that Display Item to Select List (named LOV) programmatically at runtime? If not, what other options do I have?

View 13 Replies


ADVERTISEMENT

Application Express :: Change Font Size For Item Of Type Display

Jul 13, 2012

how to change the font size for an item of type display only ?

View 4 Replies View Related

Application Express :: How To Change Column Order In Interactive Report

Oct 18, 2013

I am trying to change the column order in an Interactive Report. Run the report as a developer then use the action menu. 

However, I am not sure how one can run the the report as a developer.  Do you just login and run the page?  Then if I do that, I don't see the action menu there.  If I go to page attributes "Save Report" tab, I do see the action menu but "Select Columns" only gives me "Report Type", "Report Name" etc as columns. Or we don't have enough privileges to run the report as a developer? 

View 7 Replies View Related

Application Express :: How To Change Column Header Value Dynamically In IR Report

Oct 29, 2012

I have created report with the collections. Report query has been changing dynamically but i got problem with report header names and headers names has not been changing dynamically it is always showing like c001,c002....etc so, i have created global item(G_ITEM) in shared components--->Applications items after that I have created process(before headers) and assigning some value to G_ITEM and used &G_ITEM to column headres in IR Report but here &G_ITEM is not showing any value.

How can i achieve dynamic headers names by using *&G_ITEM(global items)*

View 1 Replies View Related

Application Express :: Tabular Form - Change Column Values Before MRU

Jun 4, 2013

I have a problem with Tabular form. Configuration: Oracle 10g, Application Express 4.1.0.00.32.

I have tabular form on simple table. I need to change some column values before MRU. For example: i have column named "UPDATE_DATE" where i need write SYSDATE every time this record was updated. I've created page process, associated with my tabular form.

Process point: On Submit - After Computations and Validations;
Sequence set to 1 (before "ApplyMRU" process - it has sequence 10);
When Button Pressed: Submit;
Execution Scope: For Created and Modified Rows;

Source:

declare
indx varchar2(255);
l_map wwv_flow_global.vc_map;
l_id number;
l_pk number;
begin
[code]........ 
   
But this doesn't work. MRU process writes old values, that was posted from browser. I tried change values by

apex_application.g_f04(:APEX$ROW_NUM) := sysdate;but this also not work.

How can i change values before MRU? Why wwv_flow_tabular_form.set_row_values doesn't change values?

View 5 Replies View Related

Application Express :: ORA-01439 / Column To Be Modified Must Be Empty To Change Datatype

Sep 4, 2012

I need to modify the column type that already has data in it, i need it change varchar to number then The datas entered have $ and , (e.g $3,200). I need the $ and , removed with column type set to numbers.

When i currently do this i get the following error:

The TABLE operation was not successful for the following reason:

ORA-01439: column to be modified must be empty to change datatype

I've tried unloading the data and loading the data using the spreadsheet, cut and past and csv file but both give me more errors, so i just want that one column modified.

View 2 Replies View Related

Application Express :: Interactive Report / Change Text Color Based Upon Value In Another Column

Nov 12, 2013

I have a sample report at this url:

workspace: homeworldusername: test_reportpassword: test_report APEX version is 4.2.3, database 11g release 2... Application #: 202 : IR REPORTS TEST Page in question is page #2   

I have the report setup and need to make the following change... I have 2 columns: Comm and bonus,

if the bonus > comm, I need to change the text color of the bonus color to Red   if the bonus < comm

I need to change the text color of the bonus color to Green   if the bonus = comm, I need to change the text color of the bonus color to Black I have tried using code with the select and am NOT wanting that since it will be bundled with the data when downloaded as CSV or Excel.. Had thought about using the built in highlighting but that doesn't allow comparing a column to another.. Was thinking of a dynamic action, but not clear as to HOW to do it.

View 10 Replies View Related

SQL & PL/SQL :: Can Change Existing Table Column Data-type

May 18, 2011

i have one table emp in this table i have the column eno,ename,hiredate and i have data also in this table.

my eno colum data type is number so now i have to change this colum data type from number to varchar2.

if yes how can when i am trying to change this colum data type i got this error

Failed to commit: ORA-01439: column to be modified must be empty to change datatype.

View 1 Replies View Related

Application Express :: Possible To Set Application Availability In Runtime-only Environment?

Sep 6, 2012

I'm using apex 4.1.1.00.23.I'm wondering whether it is is possible to 'freeze' a production APEX application in a runtime-only installation, during an upgrade. I want to prevent strange behaviour for logged in end users. In the application builder one can set the availability of the application. I was thinking of making the application unavailable during the upgrade. Is this possible in a runtime only env? How? Or are there (better) alternatives?

View 1 Replies View Related

Application Express :: Dynamic Reports - Runtime Parameter Passing To Report Query

Jul 27, 2013

I have developed a report using apex shared components (report query and report layout) along with BI Publisher for report printing in pdf format. the Report template is built using Template Builder for Word. I have configured my Apex4.1 env with BI Publisher 11. This report is working fine for hardecode ID ( like REQUEST_ID=10 ).  to make report dynamic i have made following additions in the report 

I have added where clause in report query as WHERE REQUEST_ID = :REQUEST_ID (:REQUEST_ID is the text field in my page).

Added a text field names :REQUEST_ID to get user input at run time.

Create a button and add Repot Query URL in its properties. When i run the report with some valid value in :REQUEST_ID text field  i did not get expected result infect there is no record getting displayed in the PDF file. i think this is not the write way to do this but interestingly im not getting any error. how can i get this functionality in apex this way or the other ?

View 0 Replies View Related

Application Express :: Object Type As Application Level Variable

Jan 2, 2013

My question is, if I define an object type (create type ... as object ...) is it possible to hold a variable of this type as the session level? For example, if I am creating an order using multiple web pages, it would be much easier (and intuitive) to create and manipulate an order object than to hold the data in generic collections.

If that is not possible, is there some way to make a generic Apex collection appear more application specific? By this I mean some way to map the columns C001, C002, ... to more intuitive names such as CUST_NO and ORDER_DATE. I had considered possibly creating a view of the APEX_COLLECTIONS view which would rename the columns but then I would also have to create a bunch of instead of triggers if I wanted to update it as well.

View 2 Replies View Related

Application Express :: How To Change File Character When Export Application (4.2.1.00.08)

Feb 5, 2013

I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with

"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",

how can I do change it?

View 1 Replies View Related

Application Express :: Way To Change Application Builder Theme

Sep 24, 2012

Is there a way to change the Application Builder theme? There are themes for applications; how about for the builder itself? I looked but did not see a selection for this.

I'm a Geek thru and thru, I guess, but I think you might have to be xxxx retentive to like all these square boxes. And these old eyes have to squint to focus among the vast sea of gray shades.

View 2 Replies View Related

Application Express :: Change To Application Process Not Recognized?

Sep 13, 2013

I'm trying to make changes to a PL/SQL procedure in an application process and no matter what I do in the PL/SQL text (even removing semi-colons and messing up syntax) no changes register when I call the procedure from a page process. I've also tried creating a new application process with a similar procedure of a different name, and no page processes will allow me to call the procedure, saying that it needs to be declared. APEX 4.1.1

View 1 Replies View Related

PL/SQL :: ORA-02267 / Column Type Incompatible With Referenced Column Type

Oct 23, 2012

i what to update a column data type am geting this error

ORA-02267: column type incompatible with referenced column type

my query is

when i run

SELECT       b.table_name||
' joins to the '||
a.table_name||
' table on '||
c.column_name||
' = '||
d.column_name          Table_relationships

[code]....

View 9 Replies View Related

Application Express :: How To Change Logo URL

Feb 14, 2013

How to Change LOGO URL (When I click on logo redirect should go not to home page, but to any page that I want set manually).

View 3 Replies View Related

Forms :: Change Image In Runtime?

Nov 10, 2011

how can change image through runtime i mean if have 5 pictures first image will showing and second image showing

View 1 Replies View Related

Application Express :: Recognize A Change Of A Field Value?

Aug 21, 2012

I created a table (software defect details) and an interactive report on it. Users can go to the details form where they can manage many information: STATUS is one of them and they can change it or not.

I would like to send an email when SUBMIT botton is pressed only if field STATUS has changed. How can I detect this? I mean, I wrote a procedure in order to send an email and it works, but it runs always: I cannot set it running only when the content of STATUS_ID has changed.

how to understand if a field value has changed and, if possible what the old values was? I know how to do that by using a trigger (:old.status, :new.status) but I don't when using an APEX procedure.

View 4 Replies View Related

Application Express :: Change LOV Based On Another Field Value?

Sep 26, 2012

I have a need to change the LOV of a page item's select list based on the selection in another page item's select list. So in other words, for a page item that is a select list, I need to use one LOV normally, and a different LOV if the value of a different page item is set to X.

A dynamic action would be useful here (on change where Select List 1 = x), but I don't know how to take the action of changing LOVsfor Select List 2 based on that action.

View 5 Replies View Related

Forms :: How To Change Default Runtime Logo In 6i

Feb 5, 2012

How can I change the default runtime logo in forms 6i.

View 1 Replies View Related

Reports & Discoverer :: Change Value Of Text In Runtime?

Jun 2, 2010

how i can change the value of text in the runtime?

View 6 Replies View Related

Forms :: Change Item_type Property At Runtime?

May 9, 2012

Is it possible to change the item_type property of an item at runtime.

I have one text item and i need to lock(Read only) that item. I hope we can change the ENABLED property or by changing the ITEM_TYPE as DISPLAY_ITEM.

How to change the Item_Type to DISPLAY_ITEM from TEXT_ITEM at run time or else is there any other way except ENABLED property to male the field as READONLY.

View 2 Replies View Related

Forms :: Change Background Color At Runtime

Nov 25, 2010

I have a text item in the control block and I want to change the background color at runtime..I used set_item_property but it doesn't working.I used WHEN-MOUSE-MOVE TRIGGER at the field level and the code.

is
SET_ITEM_PROPERTY(':master_blk.department', FOREGROUND_COLOR, 'VISUAL');
'VISUAL' is the visual attribute name and before making the visual attribute I used
SET_ITEM_PROPERTY(':CONTROL.CREATE', FOREGROUND_COLOR, 'red');

but it was also not working..

View 6 Replies View Related

Forms :: Dynamic Lov - Change Query At Runtime?

Jun 25, 2010

I have text item and it is assigned with lov namely 'Typelov' and that xlov assigned with 'Rgtype'. When I create the record group i just create with sql

like

select distinct type from x;

But at runtime i want to change the query

select distinct type from x where col1 = 'XXX';

and now the lov should display the above filtter condition item only.Is there any possible

View 3 Replies View Related

Application Express :: How To Restrict Uploading Files By Mime Type

Oct 26, 2012

I have been searching the forum (and Google) looking for tips on how to ensure users can only upload files of specific formats (Word, PDF, etc) for specific document types as defined within the application (e.g. Curriculum Vitae (Word), Copy of Transcripts (PDF)).

While I have used this research to start work on a server-side solution, I would like to know if there is an apex-friendly way to "validate" a file-browse item based on mime-type.

View 2 Replies View Related

Application Express :: Performance Depending On Condition Expression Type

May 24, 2013

I was just wondering what people's thoughts and experiences are regarding performance of conditional expressions.

Tony blogs about it here

[URL}.........

And gives the example

1) Value of item/column in Expression 1 = Expression 2Expression 1: P1_JOB

Expression 2: SALESMAN

2) PL/SQL Expression

Expression 1: :P1_JOB = ‘SALESMAN’>

Recently I've been trying to eke every shortcut I can with an application and noticed this can be a contributing factor when done dozens of times within a page render.

View 1 Replies View Related

Application Express :: Refresh Tree On Change Of Shuttle

Sep 27, 2012

I have a requirement in which on Change event of shuttle, the tree present in another region of the same page should refresh. On refresh, the tree should include the values selected on the right hand side of the shuttle as its nodes.

View 3 Replies View Related

Application Express :: How To Change Grayed Field Font

Nov 7, 2013

I need to change the grayed field item font ... ie i need to make disabled item value to be bright to achieve this what i have to do.

View 6 Replies View Related

Application Express :: Update Field On Change For SQL Query

Nov 26, 2012

We are using APEX 4.2, 10GR2, RedHat5.

I have a report that comes from SQL Query (updateable report). I'm using the apex_item.text and apex_item.hidden on fields. I'm using a button to submit and after submit process to add some logic that I need.

There could be 1 - 10 records in the report. There is only 1 field that is needed to enter a value, but the value of this field determines the value of another field. I think that I can do this with a submit button and an after submit process where I loop through all the records. I think I have this handled.

This is the question

When the value of that field is changed then the value of another field in the same row changes immediately. All the examples I've seen so far are for a single record and that doesn't work for us.

I guess this is a MRU process but I haven't seen an example where a dynamic action is possible on a Multi Row Update.

View 4 Replies View Related

Application Express :: Interactive Report Get Where Clause And Change It

Sep 9, 2013

If it is possible in Apex 4.2 get interactive report where clause and change it before displaying result e.g. We have an report and for some of columns we should do exact match and for some partial match.And business requirement is that they should not add additional % at the and of search string. It should be added automatically for some fields. 

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved