Application Express :: 4.2 - Validate Field In Tabular Forms?

May 13, 2013

1.- i have a product_item field (wich is a lov and user choose one value), so i need to call a function (sending it the selected value product_item) that will return me some data about the product i selected, for example :

if the function return 'A' then
disable the next item on tabular form, lets say quantity
else
enable the next item on tabular form, lets say quantity
end if

2.- i need to determine the result of two items operations:
total := final_quantity - start_quantity
the user will introduce start and final quantity and i will determine the total.

View 0 Replies


ADVERTISEMENT

Application Express :: Numeric Field In Tabular Form

Mar 25, 2013

I am using APEX 4.1 and Oracle 10g XE.

I want to restrict 3 digits after decimal in tabular form. Only three or less than three digits should be allowed after decimal and should be stopped automatically.

e.g. 34.543

View 6 Replies View Related

Application Express :: How To Create A Display Field In Tabular Form

Oct 1, 2012

I 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

View 2 Replies View Related

Application Express :: File Browse Field In Manual Tabular Form?

Oct 26, 2012

I am using Oracle APEX 4.0. I want to create a tabular form with one column as File Browse field.I've created form using APEX_ITEM and file browse item using pure HTML tags as we do not have any such item in APEX_ITEM. So these fields are appearing now but how do I save uploaded files in APEX_APPLICATION_FILES and then in my table?

View 3 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 :: Number Mask Format With Tabular Form (Text Field)

Aug 24, 2012

By default number that "starts" with a leading zero with decimals - zero is removed. 0.49 => .49

I'm adding for e.g. the mask "FM990D0999". 0.49 => 0.49

Ok this is fixed.But if I have an integer without decimal. 1 => 1.0

If I change the mask to FM990D9999 1=> 1.

I would like to have a zero leading when it's 0.49 but also no decimal when it's an integer => 1

APEX 4.0 with 11g

View 2 Replies View Related

Application Express :: Unable To Set Default Date Value For Tabular Form DB Date Field?

Dec 3, 2012

Version : 4.1.1, I have a tabular form on a DB table. One of the columns is a date field. When the user hits the "add Row" button on the tabular form, I want the Date field to be defaulted to sysdate. Here is what I have tried so far,

1. Created a "hidden" item P1_SYSDATE and populated the default value with sysdate. After this, under the DB tabular report date field, I used default type - Item/application on this page and entered P1_sYSDATE

2. Instead of populating the default value of the P1_SYSDATE hidden item, I created a before regions process and added

:P1_SYSDATE := sysdate

and added P1_SYSDATE to default type of the tabular date field with default type as "ITem/application on this page.

I get the error

ORA-01790: expression must have same datatype as corresponding expression

I tried to_Char(sysdate,'dd-mon-yyyy') and then converting it back to to_date. still no luck.

View 1 Replies View Related

Forms :: Validate Time On Field

Aug 22, 2010

I have a varchar field and user will enter the time in that field as per the format HH:MI HOURS:MINUTES.Actually there is no control on this field and user is making mistakes like instead of HH:MI he is entering HH;MI.

View 1 Replies View Related

Forms :: Validate Field To Be Valid Email ID?

Feb 16, 2011

want to validate a field to be a valid email id.

View 1 Replies View Related

Can't Validate Date Overlaps For A Tabular Column

Oct 2, 2013

The validation I created to validate whether new or updates rows does not overlap with any records in the table isn't working. The columns are StartDt and EndDt  Validation Type:

NOT EXISTSValidation expresion:select 1    from  sample S    WHERE S.STARTDT BETWEEN :STARTDT AND :ENDDTOR(S.ENDDT BETWEEN :STARTDT AND :ENDDT)or (S.STARTDT <= :STARTDT and S.ENDDT >= :ENDDT)or (:STARTDT <= S.STARTDT and :ENDDT >= S.ENDDT)Error Message:Times overlapWhen Buttons pressed-Select Button- The validation works if a new row or updated row overlaps any existing start and end date records but it doesn't work if I update startdate and end date rows that doesn't overlap existing date times Example:TABLE

[code]....

View 5 Replies View Related

Application Express :: Validate Date And Time

Jul 18, 2012

I am using Apex 3.2

I have a field on my form called P4_START..It has a format mask of DD.MM.YYYY HH24 MI and a default value of TO_CHAR(SYSDATE, 'DD.MM.YYYY HH24:MI').

I need to create a validation which fires on save, to ensure the user is inputting a date and time

View 5 Replies View Related

Application Express :: 3.2 - Validate Date Format

Oct 17, 2013

Apex 3.2 I have a field called P14_START_DATE.The display as type is Date Picker (DD.MM.YYYY). Now if the user uses the pop up calendar, the field is populated with eg 07.12.2013. I have 2 standard validations, not null and item specified is a valid date. If the user decides to type in the date, they can use a different format, eg 07/12/2013, which I do not want to happen.How can I validate the field, so they get an error if they do not use format dd.mm.yyyy.

View 2 Replies View Related

Application Express :: How To Validate Date In Column Section

Dec 19, 2012

How to validate a date in column section?

View 1 Replies View Related

Application Express :: Validate Database Column Using Validations Tab?

Sep 11, 2012

I'm trying to validate a database column using the validations tab in APEX, the data entered will always be in 'A0000' format but i cannot work out how to set up the validation correctly

View 2 Replies View Related

Application Express :: Check Box In Tabular Form 4.1

Sep 14, 2012

How i can use check box in tabular form . working with 4.1 and am using simple check box (display as) .it creating the check box. how i can set value yes or no into it?

View 1 Replies View Related

Application Express :: Tabular Form With Updates In 4.1

Dec 5, 2012

This problem went away for me in 4.2, but I am limited to 4.1 in production. The problem is this: I have three editable columns in my Tabular Form

1) I make a change to column 3 and press submit. The values in columns 1 & 2 (that were not changed) are overwritten with null during the update (submit). Column 3 is saved correctly.

I deleted my tabular form and re-created it thinking that I may have trashed something. But it appears that is the way it works. How do I prevent the unchanged editable columns from being overwritten with nulls?

View 2 Replies View Related

Application Express :: Dynamic Tabular Form

Jul 9, 2012

I have one table that holds a list of People...

Another that holds Classifications

Another that holds Sub Classifications (linked to the Classification table)

Table(*Person*)
PersonID, PersonName
Table(*Classifications*)
ClassID, ClassName
Table(*SubClass*)
SubClassID, SubClassName

I need a form that will allow me to put Classifications and Sub Classifications against a Person. I want to be able to add new Classifications and SubClass Values which are dynamical added to the form...

I have a table that holds other data and links the People to the Assessment

Table(*Person2Assessment*)
AssessmentID, PersonID, Date, AssessorName, Notes

I have a table to hold the Values of the Assessment...

Table(*AssessmentValues*)
AValuesID, AssessmentID, ClassID, SubClassID
-----------------------------------------------------------------
A typical person may look like:
e.g.

Person1(Fred)
Class1(Programming C++)
SubClass1a(Expert)
Class2(Language)
SunClass2a(English-speaking)
Class3(Location)
SubClass3e(India)
-----------------------------------------------------------------

Now I have the data tables but how to create the table and save the values for the Assessment Values in one table the dynamically adds values based on the different classifications available...

View 2 Replies View Related

Application Express :: Defaulting In Tabular Form

Jun 7, 2012

I got stuck in trying to add a simple fixed number (e.g. -1) to a field in case the database-fields is still null.

I supposed I could use report attributes > column attributes tabular form attributes, and then use Default Type and Default but nothing seems to work.

View 1 Replies View Related

Application Express :: 4.2 Tabular Form Number Of Rows Bug?

Oct 25, 2012

When I build simple tabular form in APEX 4.2 it displayed 10 rows per page by default. When I changed that number in Number of Rows field to 15 nothing happens. Again only 10 rows per page were displayed. Next field on the right to Number of Rows is Number of Rows (Item). Tabular form works as expected when I use this field and define number of rows with hidden page item. So workaround issue (bug?) is easy. Is this some kind of bug or I miss something obvious?

View 1 Replies View Related

Application Express :: How To Manipulate DML In Apex Form (not Tabular)

Aug 12, 2013

 I have one question I made a report and form in wizard with 1 table (Ex : EMP) and want to make a INSERT/UPDATE/DELETE process based on PL/SQL API. I think, mixing APEX_APPLICATION and APEX_ITEM pl/sql api can solve this question but not sure.... I have known the tabular form processing with PL/SQL via Oracle APEX book, but cannot find any samples on simple form processing. 

View 5 Replies View Related

Application Express :: Spinbox Plugin For Tabular Form?

Sep 19, 2012

have a spinbox plugin for tabular forms? I saw a plugin on jquery but I could not download it.

APEX 4.1
Oracle 10g Rel 2 DB

View 0 Replies View Related

Application Express :: Disable Column In Tabular Form

Dec 28, 2012

How i can disable column in tabular form.working with 4.1 and i have wizard based tabular form.If i have entered value in one column second column should disable and vice versa?

View 5 Replies View Related

Application Express :: Duplicate Record Into Tabular Form

Oct 23, 2013

I have created tabular form using

SQLselect"LINE_ID","LINE_ID" LINE_ID_DISPLAY,"ALLOCATION_ID","SERVICE_ID","CATEGORY_CODE"from "HOTEL_ALLOCATION_DTL"WHERE SERVICE_ID=:P6_SERVICE_ID 

here line_id is primary key .here i don't want to enter duplicate category code when i submit rows.Here Allocation_id and service_id would be same for particular service_id .How can i create validation to enter duplicate category code .  

View 1 Replies View Related

Application Express :: Updating Fields On A Tabular Form

Oct 1, 2012

I have an application where I'm trying to match skillset supply to skillset demand. We have resources and we have work for resources to do. Resources possess a set of skills. Work requires a set of skills. Skillsets are described by three fields: Domain, Target, Skill. So, we are able to capture the supply of skills in a table:

RSRC_ID (FK to Resource table)
DOMAIN
TARGET
SKILL
PROFICIENCY  (this is the skill level 1 to 5)

The relationship of resources to skill supply is 1 to many. Conversely, work demands skills, and so we capture skill demand in a table:

WORK_ID (FK to Work table)
DOMAIN
TARGET
SKILL.

The relationship of work to skill demand is 1 to many also.

Users assign skills to resources using a master-detail form. It works fine
Users assign skills needed to work also using a master-detail form, and it works fine as well

A view then joins the skillset supply to skillset demand so that assignments can be made only where supply and demand match. This view is used in the LOV below.

I am using a mapping table to capture assignments of work to resources or resources to work. It is a many to many mapping of work and resources with matching skillsets, and it looks like this:

RSRC_ID  
WORK_ID
DOMAIN   (
TARGET   ( These are the skillsets where demand equals supply and are derived from the view and presented in the LOV )
SKILL      (I've created master-detail forms for the two types of assignments. An LOV in the detail form will present qualified resources or eligible work and then return the appropriate RSRC_ID or WORK_ID, but I must also populate the other three fields (DOMAIN, TARGET and SKILL) before I can insert or update the record. Here's the LOV from the form where resources are assigned to work:

SELECT sed.domain||'.'||
       sed.target||'.'||
       sed.skill||'/'||
       sed.skill_prof||'  '||
       r.first_name||' '||
       r.last_name "d",
       r.rsrc_id "r"
FROM   ri_resource r, ri_skill_supply_eq_demand sed
WHERE  r.rsrc_id = sed.rsrc_id
AND    sed.work_id = :P18_WORK_ID

order by 1It is not enough to just match the work to the resource, we must record for what skillset they are matched. I can't seem to see an easy way to populate the three other fields in the tabular form using data that I can retrieve with the LOV.

View 1 Replies View Related

Application Express :: Maximum Rows On Tabular Form?

Sep 27, 2012

I have a tabular form (report) multi-record. It display only the records 1-15 with pagination to the other pages. When I set the field 'Number of Rows' to 100, it still displays record 1-15 only. I just want to see the complete dataset on one page, without pagination. (There is a filter on it so there will never be more than 100 records displayed)

View 4 Replies View Related

Application Express :: Tabular Form Row Background Colour?

Jan 29, 2013

I have created a tabular form and have changed some row background colours by using the Column Template sectiom in the report template

i.e

<td #ALIGNMENT# headers="#COLUMN_HEADER#" class="t16data" style="background-color:#FFFF33">#COLUMN_VALUE#</td>

with '#ASSIGNMENT_ID#' = 99 as the condition

This changes the colour but when I move the mouse over the row it removes the colour.

View 3 Replies View Related

Application Express :: Javascript Function For Tabular Form Changes?

Apr 12, 2013

I have a tabular form with a few columns. THey are ID, date1, date2 and task_name. The task_name is a drop down list of tasks. Upon selecting a specific task, I want the date1 and/or date2 columns to become read only (voided out) so users cannot enter in data. I am working with a tabular form, so I figured I need a javascript function to handle the logic and to call the function in the html elements of the column in the apex environment. This will need to happen dynamically (on click) before the page is submitted. I am more lost/confused on syntax. I know I will need to know the actual column name (coo1, coo2, something like that) of my columns that I will be refering to when I use javascript.

View 2 Replies View Related

Application Express :: Unable To Delete Row(s) From Tabular Form?

Jan 28, 2013

I created report with row selector, when I select one row I get tabular form regarding to the selected row from report. I can insert and update data from tabular form, but I have problem with deleting them. Error I get is

ORA-01403: no data found (Row 207589)

My tabular form is created by wizard and primary key is managed by database rowid, I use apex 4.1 an 10g database.

View 3 Replies View Related

Application Express :: Tabular Form Delete Row Functionality

Aug 29, 2013

I have a wizard created tabular form, adding a row is easy using addRow() function, is there a way that I can delete the row from it?  Let's say I have added a row and not submitted the form, but now I want to delete just that row from the form, how can I do that?

View 1 Replies View Related

Application Express :: Deselecting All Checkboxes In Tabular Form

Nov 8, 2012

I am using Apex 4.2 with Oracle 11g

I have a requirement where I need to create a tabular form with a check box column. I created one using Apex_item.checkbox() function.

I have a button, when clicked it has to deselect all the checkboxes. I know I can use javascript onclick function and call a javascript. But I dont know how to use the javascript for a tabular form.

View 0 Replies View Related







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