Home » Developer & Programmer » Application Express & MOD_PLSQL » Forms in Apex (oracle 11g)
Forms in Apex [message #578155] Mon, 25 February 2013 00:52 Go to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member

I am developing a form with a base table , cargo .

The cargo table has the first field as FEDID ( numeric, unique , primary key , not null ) .

howerver when I run the forms , this field does not appear in the screen .

So, I am unable to populate data in the table .

please help
Re: Forms in Apex [message #578157 is a reply to message #578155] Mon, 25 February 2013 00:58 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Apex has, probably, set that item as "Hidden" as you, I suppose, said that it is a primary key column (and chose the way to populate it, such as a database trigger or a sequence). So, set it to be a "Text item", run the form and see what happens. Check its other properties and processes (so that you wouldn't be surprised if Apex overrides value you enter into a form and puts a sequence number into a column).
Re: Forms in Apex [message #578168 is a reply to message #578157] Mon, 25 February 2013 02:46 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Thank you very much .

How do I attach a list of value to a forms item
Re: Forms in Apex [message #578169 is a reply to message #578168] Mon, 25 February 2013 03:06 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd suggest you to read documentation, first. It will make things much clearer.

Basically, you'd set that item to be a select list or popup lov. Then, you'll see the list of values property which should contain a query. That can be named LoV (create it in shared components), static LoV (see examples for more info) or a query which must return two values: a display one, and a return one.
Re: Forms in Apex [message #578177 is a reply to message #578169] Mon, 25 February 2013 05:10 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Thank you very much . I am able to solve the problem .

In shared component there is Breadcrumbs , please let me know what is this . could not find any thing in the documentation
Re: Forms in Apex [message #578178 is a reply to message #578177] Mon, 25 February 2013 05:15 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Breadcrumbs are used as navigation objects; they are "links" located at the top of the screen so that you could easily locate current page position, relative to other pages.

By the way, you should improve your search skills. Breadcrumbs in Apex documentation.
Thank you very much [message #578185 is a reply to message #578177] Mon, 25 February 2013 07:29 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Thank you very much .

I would like to deploy this in the server .

Please help me in this .

Please let me know the steps .
Re: Thank you very much [message #578186 is a reply to message #578185] Mon, 25 February 2013 07:35 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you just being lazy or playing stupid? I told you - read the documentation.
Re: Thank you very much [message #578231 is a reply to message #578185] Tue, 26 February 2013 00:24 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
sorry boss , reading
Re: Thank you very much [message #578250 is a reply to message #578231] Tue, 26 February 2013 02:03 Go to previous message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Thank you very much .

I am reading the documentation .

IT says that there is "NO separate Server installation needed "

To, run Oracle Application Express , you must have to embedded PL/SQL gateway , which is default "

So , do I have to give other application user's connection to the PC , where I am developing the application .

Around 26 different user's from different locations are planning to access this application .

Previous Topic: create remote file with util_file
Next Topic: unable to change
Goto Forum:
  


Current Time: Thu Aug 21 09:04:50 CDT 2014

Total time taken to generate the page: 0.09574 seconds