Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Text field with autocomplete is always NULL

LRMJan 22 2011 — edited Jan 23 2011
Greetings,

I am new to Apex so I am sure I am missing something obvious. I am using Apex 4.0.1 What I have done is created a form on a table page and added a new text with autocomplete page item. This new text field does not correspond to a column in the table. What I am trying to do is allow the user to use the autocomplete item to make a selection. Then when the user submits the page, I want to use the substr function on the value in the autocomplete field and populate one of the table fields. I have tried using PL/SQL functions in validations and computations but I have found that the value of the autocomplete field is always NULL. I can access the other fields that are associated with a table column fine. It must be something simple. Thanks for your help.
Page Items
P2_F1  - text field with auto complete. Not associated with a table column
P2_F2 – Text field. Is associate with a table column
This is what I want to do:

Entered this in a validation
begin
if :P2_F1 is not null then
   :P2_F2 := substr(:P2_F1,1,5);
end if;
end;
Thanks again

Edited by: LRM on Jan 22, 2011 5:25 PM
This post has been answered by Kartik Patel on Jan 22 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2011
Added on Jan 22 2011
4 comments
671 views