CODEWITHSUNDEEP
sqloracle-databaseplsqloracle-apex
hello
hello

Reputation: 1

Querying for 2nd validation statement on an existing field in APEX

where id = (select id from tab1 where col2 = 'range') and desc = 'min'; 

var max := select LV R from LV 
where id = (select id from tab1 where col2 = 'range') and desc = 'max';

begin if :P1_range < min or :P1_range > max then 'invalid range' 
end if; 
end;

the above ^ will be my 2nd validation statement. i have one validation statement in place that the field must have a value in it.

Upvotes: 0

Views: 36

Answers (1)

Scott
Scott

Reputation: 5035

When using validations, the exact syntax will depend on the Type you've selected. Use the inline help to ensure you match expression format.

Validation example from Page Designer

Also make sure you explicitly convert and numbers and dates, since sessions state is stored as a string.

If you receive any errors, it's best to describe them here, as they will allow for quicker resolution.

Upvotes: 1

Related Questions