Application Express :: Retain Text Area Line Breaks

Nov 3, 2013

I am using textarea item to enter and save data into table but saved data doesn't retain all formatting eg line breaks so how can i format the text entered in the textarea so it retains line breaks when saved in the table or sent in the email via APEX_MAIL.SEND...  in APEX 4.1.1, 

View 0 Replies


ADVERTISEMENT

Application Express :: Prefix Text Entered Into Text Area With Userid And Timestamp?

Sep 12, 2012

Have got basic form on a table and have a textarea which holds Notes added by user.

So Notes database field is updated on Save / Apply changes button being pressed.But would really like any text added / appended to the Notes field to be prefixed by userid and date / timestamp.

Is it possible via dynamic actions or Javascript to have any new text added / typed to be auto prefixed as per above.

Would only want the first key press in the filed to trigger the auto-prefix and if added text was deleted then the auto prefix to be deleted as well ?? If user doesn't press Save / Apply changes obviously want to leave existing Notes as is.

View 5 Replies View Related

Application Express :: HTML Text Area With Save Button

Oct 22, 2012

I have created a region Q_INFO and in the region i have added HTML text area. This text area is editable for only few users. If the user types in the text area and presses save button. The text is stored in the table INFO. And this text is displayed to all other users. But when i enter any data in the text area with multiple new lines and press SAVE button. The text is displayed in single line. I want to maintain new line and paragraph in the text area.

View 2 Replies View Related

Application Express :: Causing (new Line) In Display Of Text In A Report

Jul 27, 2012

Oracle 11.2; application express 4.1...I have a table with a unicode clob column into which I insert descriptive text. Within these text entries I have inserted CR/LF (00D00A). However when I display the text entries in a report, the text streams instead of appearing with separate lines.

My report statement:
select text_entry_dt, entry_authy_nm, entry_text
from obj_text
where obj_id = :P41_FIND_ID
  and text_type_cd = 'DES'

hat to do to obtain line separation within the entry_text content?

View 3 Replies View Related

SQL & PL/SQL :: Remove Line Breaks In Select Statement?

Sep 9, 2013

I have a simple column in a table which store a description. This can include line breaks so when you select from it, it looks similar to below

'Part number: X
Batch: Y
Size: Z'

I would like to be able to create a view (so not having any impact on the original data) to return it as below

'Part number: X Batch: Y Size: Z'

View 3 Replies View Related

Application Express :: How To Retain Entered Data In Collection Report Columns

Jul 28, 2012

I created one collection report and in the report when i click on the next >> then the report will show the next columns to enter data in some columns but the data which i entered before going to next will not get retain (data is getting lost) when i come back by clicking << previous but i want the data to get retained even when i click on next >> or previous << in report so that i can enter large amount of data at a time in the report columns by clicking >> & << and click on submit button to save all the data.

View 3 Replies View Related

Application Express :: Setting Up SSO In Work Area?

Jul 5, 2012

How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.

Have you able to run this script before?

apex_sso.sql, apex_verify.sql, apex_sso_server.sql

My output for this scripts are good.

View 0 Replies View Related

Application Express :: 4.2 Front Page Login Area Alignments

Dec 2, 2012

I am running Apex 4.2 on Oracle Express Edition (Linux). Sometimes my login page has the alignments of the Workspace/username/password login area below the Apex image as below: [URL] ........

This is with using Firefox. The font page renders ok with other browsers like IE or Chrome.

View 2 Replies View Related

Application Express :: Retain Checkbox Value On Cascading LOV Checkbox

Sep 29, 2012

My development instance's APEx version is 4.1. I have two checkbox items works on cascading LOV. The cascading works very well as long as if I do not come back and check anything from the first checkbox item after I checked the second checkbox.

If I do, the cascade LOV refresh uncheck all checked values from the second box. My question is, how can I preserve the second check boxes checked values before refresh?

View 0 Replies View Related

Application Express :: Starting Report Column On New Line

Jul 30, 2013

Recently I remember reading what I think was a blog post on placing the last column of a report underneath the penultimate column - I think it was for classic reports.

I can't find it... Col1  Col2  Col3----  ----  ---- abc   def   xyz123   456   987  Col1  Col2  ----  ----  abc   def         xyz123   456         987

 I think it was done with some magic in the column definition, or maybe some jQuery?Agnostic to version. It was a more robust solution than using a HTML expression of#COL2#<BR>#COL3#

View 5 Replies View Related

Application Express :: Adding Calculation Of Amount In Invoice Line?

May 10, 2013

I need to add the calculation of the amount in an invoice line.

I write the item description, the price, the quantity and the tax. Which is the best solution to calculate the total price of the line. I think to add a SQL function after the button “Add line” is clicked.

View 5 Replies View Related

Application Express :: Installation (or Upgrade) Supporting Objects On Command Line

Mar 31, 2013

is it currently possible to install the supporting objects using sqlplus?

When I export an APEX application which contains supporting objects (scripts to install images, css files, tables and seed data) I can run this script on the command line using sqlplus to install the application into the target environment.

After installing the application (which works fine), I cannot invoke the installation of the supporting objects nor the upgrade of the the supporting objects.

Am I overlooking the obvious, have checked APEX_APPLICATION_INSTALL but there is no function available for that purpose?

View 0 Replies View Related

Application Express :: Search Application And Replace Text Within It

Sep 24, 2012

In Application Builder, is there a way to searching the application and replacing text within it?

I have an application item named "FORMAT_TYPE1". I would like to perform a find and replace action (just like a word processor) where any part of the application that has name or text "FORMAT_TYPE1" in whole or in part is replaced by the text "FORMAT_CATEGORY1". For example:

FORMAT_TYPE1 becomes FORMAT_CATEGORY1
&FORMAT_TYPE1. becomes &FORMAT_CATEGORY1.

The find/search would do it in any attribute, source code in the application. There is only a Search Application feature, which is useful in identifying places, but lacks any replace function. Is there something else that will do this, besides exporting, editing the source code in a text editor, and then importing the application again?

View 0 Replies View Related

Application Express :: Format IR Total And Text

Nov 13, 2013

Apex 4.2 I have an interactive report.I use the sum attribute on the column and break formatting option to create a report total on one columnReport Sum Label Total:Break Columns No BreaksHow to I format the total text and value in to red 

View 16 Replies View Related

Application Express :: How To Display Blob As Text

Jul 9, 2013

I am developing an apex application using the apex cloud (apex.oraclecorp.com). I am using the DB link to show the data on APEX UI. I have a blob data which is stored in the remote DB, and I want to display the BLOB data as text on a popup or a new page or a download link.  I tried using display only item but APEX throws an error saying that remote DB is not supported. Also, It would be great if I can just show a download link on the UI for the BLOB data, again when I try to select the format as BLOB in the column attributes, When I give the table@dblink as BLOB table I get an error saying that "table@DBLINK not found". Is there any way to display the BLOB data as text or download it which is present in my local DB?

View 10 Replies View Related

Application Express :: Import Text File

Oct 5, 2012

In my apex application needs to import data files, through end users. The fields in this file are not separated by any character (structure is not classic CSV), but have a fixed width.

How to do?

Scenario 1:

import file to a temporary table with a blob column, create a trigger for this table via a PL / SQL code meet end table

Scenario 2:

using DBMS_LOB libraries to read directly file

Scenario 3:

?

Milos.

(Apex 4.1.0.00.32, db:10.2.0.4 )

View 9 Replies View Related

Application Express :: Any Way To Add Text To Image Automatically

Dec 18, 2012

I have an image that shows flags of 2 countries... I want to show revenues that they generate every day. is there a way to add text to the image (on it) using values from a table.

View 10 Replies View Related

Application Express :: Add Dictionary In Rich Text Editor?

Apr 22, 2013

I would like to add Dictionary in Rich Text Editor of APEX.

I am using Oracle APEX 4.2 on Oracle 11g.

View 1 Replies View Related

Application Express :: Button With Pre-element Text Is Given A Container Div?

Aug 8, 2013

Just installed 4.2.2.00.09 and imported a workspace and an application. Worked fine.I noted a page display difference when compared to the exported application (4.1.0.00.32). I have (so far) found this:If I have a button with Pre Element Text set to <div class="dummy"> and Post Element Text set to </div>, Apex generates an extra div around it all.If my button was named P1_SUBMIT I end up with 

<div id="P1_SUBMIT_CONTAINER">
<div class="dummy"> <input type="button" value="Search" id="P1_SUBMIT" /></div>
</div> 

Is it possible for me to turn this extra div off?

View 0 Replies View Related

Application Express :: How To Retrieve Item Help Text From Database

May 23, 2013

I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?

View 4 Replies View Related

Application Express :: Rich Text Editors In 4.2 After Upgradation

Mar 12, 2013

We have recently upgraded to apex 4.2.1 from 4.1. After this, we get a strange stopping issue that the rich text editors clear all their values once the page is submitted. This happens only in Firefox and Chrome, but works just fine in IE. Have you ever noticed and had a solution for this?

View 1 Replies View Related

Application Express :: Dynamic Population Of Text Fields

Jan 17, 2013

how to dynamically populate text fields.For eg, i have a lov with employee no, as soon as a no is selected next text field with employee name will be populated.

View 5 Replies View Related

Application Express :: Text Areas In 4.2.2 - Can't Be Read Dynamically

Sep 3, 2013

i encountered a big problem after upgrading Apex from 4.1 to 4.2.2. On an application page there is a Text Area which will be read and processed after clicking a button. I didn't want a refresh of the page and did it with a dynamic action.All this worked like a charm with 4.1. Since the upgrade, the value of the Text Area is always returned as null while processing the dynamic action, but the value is filled by the user!When i change the type of the Element to Rich Text Area everything works fine, but i don't want this because i don't want HTML in the corresponding table. Is this a bug? How can i workaround it? 

View 10 Replies View Related

Application Express :: HTML Text In Reports Sub-region Not Displaying

Nov 30, 2012

I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .

View 1 Replies View Related

Application Express :: Rich Text Editor Image Path?

Jun 27, 2012

i'm using Apex 4.1

When user add an image to a rich text editor in apex is there any way to get the source path of that image within PL/SQL block when page submit happens ?

View 2 Replies View Related

Application Express :: How To Have A Dynamic Action Populate Text Fields

Sep 7, 2012

How to have a dynamic action populate text fields. When the create button is hit, it will insert the record in the DB like normal.

I had a search box doing a dynamic action when a record_number is entered and the selection changes It populates the remaining text boxes with the results of the record_number.

I used a "SET_VALUE" true action on each individual ITEM

For each individual item i have different SQL Statement populating that item.

Ex. To populate Last_Name/ P2_LAST_NAME item i do the following

Select LAST_NAME from patient_Demographics
where record_id = :P2_RECORD_ID

Affected Elements:
P2_LAST_NAME

So i have about 8 of these true statements, so i'm hitting the DB 8 times to get the individual items. Is there a way to hit the DB once and set the items using one PL/SQL statement? I tried using a PL/sql function body,

View 14 Replies View Related

Application Express :: Disable Entering Text In Date Field

Oct 23, 2012

I am using APEX 4.2

I have created a form with a Date From and Date To fields.

I am using the Date Picker format (the new one, not the Classic), and have set the calendar to Show on Both (Focus and Icon Click).

I would like to restrict the field so that the user cannot enter any text - they can only use the Date picker/calendar to choose a date. This would them remove the clunky validations - so I can restrict the users so they can't enter the wrong format in the first place.

Is this possible?

View 4 Replies View Related

Application Express :: Interactive Report Sort Text As Number?

Jul 10, 2012

it is possible in an Apex interactive report to sort text as number?

For example, a series of text rows:

4
10
2

would sort as:

10
2
4

if it were text. What I would like to see is:

2
4
10

View 4 Replies View Related

Application Express :: Dynamic Action For A Text Field In Tabular Form?

Sep 13, 2012

for a text field of a, wizzard generated, tabular form i created a dynamic action when lost focus. using a jquery selector to bind the da to the item in every row when the event fires some jscript and pl/sql code is executed. this all works like charm for existing rows.

but how can i bind the da to the field for newly added rows?a sc of the definition of the da can be found here [URL]...

View 2 Replies View Related

Application Express :: Change Form Text Field Label Using Javascript

Oct 22, 2013

I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA. 

View 3 Replies View Related







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