Home » Developer & Programmer » Application Express & MOD_PLSQL » Change application name dynamically (Apex4.0,Oracle 10g,Win7 32 bit)
Change application name dynamically [message #617603] Wed, 02 July 2014 04:17 Go to next message
Xandot
Messages: 96
Registered: January 2014
Location: India
Member
Hello,
I have one function that return the version number like "1.2" and version number is populated with the name of application like
when i edit the application so...
********-------------**********
Name - Maintenance_system_1.1
version -release 1.1
*******----------*************

but now i want to change the version number with the help of function ...
----function body-----------
return 1.2;
-------------------

So it'll reflect on Name filed and Version filed of application and home page of app...how can i do it....


Thanks,
Xandot



Re: Change application name dynamically [message #617650 is a reply to message #617603] Wed, 02 July 2014 09:24 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know. But I'd remove release number from the name. So:
- name: Maintenance system
- release: 1.1
Re: Change application name dynamically [message #617667 is a reply to message #617603] Wed, 02 July 2014 10:39 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1850
Registered: May 2013
Location: World Wide on the Web
Senior Member
How does your existing function retrieves the version?
Re: Change application name dynamically [message #617721 is a reply to message #617667] Thu, 03 July 2014 01:15 Go to previous messageGo to next message
Xandot
Messages: 96
Registered: January 2014
Location: India
Member
Function :-
create or replace function get_version return number
as
begin
return 1.2 ;
end;
*************-----------------***********

The above one is the function that used for retrieving the version number and i want to change the application name dynamically
like now my application name is "Maintenance_system_1.1" but i want to change it like "Maintenance_system_<get_version>"
(it means "Maintenance_system_1.2" )

Thanks,
Xandot

[Updated on: Thu, 03 July 2014 01:15]

Report message to a moderator

Re: Change application name dynamically [message #617722 is a reply to message #617721] Thu, 03 July 2014 01:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1850
Registered: May 2013
Location: World Wide on the Web
Senior Member
SQL> SELECT 'Maintenance_system_'||get_version APPLICATION_NAME FROM dual;
APPLICATION_NAME
-----------------------------------------------------------
Maintenance_system_1.2
Re: Change application name dynamically [message #617726 is a reply to message #617722] Thu, 03 July 2014 01:46 Go to previous messageGo to next message
Xandot
Messages: 96
Registered: January 2014
Location: India
Member
But its not working in application name filed ....
Re: Change application name dynamically [message #617746 is a reply to message #617726] Thu, 03 July 2014 05:45 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1850
Registered: May 2013
Location: World Wide on the Web
Senior Member
Xandot wrote on Thu, 03 July 2014 12:16
But its not working in application name filed ....


That's not a proper explanation of what issue you are facing. Please elaborate.
Re: Change application name dynamically [message #617757 is a reply to message #617746] Thu, 03 July 2014 06:36 Go to previous messageGo to next message
Xandot
Messages: 96
Registered: January 2014
Location: India
Member
Right now my application name is "Maintenance_system_1.1" , here 1.1 shows the version number but now the application has altered so the version number should be "1.2"
and the application name should be "Maintenance_system_1.2".

In future if any other alteration will happen then the version number should increase by 1.3 ...for the version number i have created the function as per the above post
that will reflect the new version number in all regions of my application except the name of application name..

So how can i change my application name dynamically like "Maintenance_system_1.1" ==To=>>> "Maintenance_system_1.2" ....

Thanks,
Xandot

[Updated on: Thu, 03 July 2014 06:37]

Report message to a moderator

Re: Change application name dynamically [message #617759 is a reply to message #617757] Thu, 03 July 2014 07:00 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1850
Registered: May 2013
Location: World Wide on the Web
Senior Member
How is the "application name alongwith version appended to it" is being populated now? To make it change dynamically with version, you need to pass the version number from whatever source it is coming from.

Any when you say that the query which I gave did not work, what exactly happened?
Re: Change application name dynamically [message #617821 is a reply to message #617759] Thu, 03 July 2014 15:10 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Xandot, repeating what you already said doesn't make things any clearer.

How do you get the application name now? Is it by using APP_ALIAS built-in substitution string? Or, do you get it from your own function?

If the former, you can't modify it. If the latter, adjust the function so that it returns both name and version.

Either way, you'll end up with a custom built function. Furthermore, it means that you might need to modify all the pages or a template (if possible & if you know how).
Re: Change application name dynamically [message #617876 is a reply to message #617821] Fri, 04 July 2014 03:16 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
On a second (third, ...) thought, template has nothing to do with it.

If you chose to display app. name & version on every page, I'd suggest you to remove these fields from all pages, place them onto the page 0 and display these page 0 fields on all pages. Doing so, you'd populate them only once (with your own functions) and that would do it, I suppose.
Re: Change application name dynamically [message #617894 is a reply to message #617876] Fri, 04 July 2014 04:51 Go to previous message
Xandot
Messages: 96
Registered: January 2014
Location: India
Member
Thanks Littlefoot and Lalit.....

Yup.. with the help of zero page i have achieved my goal....



Previous Topic: Add Text at end of the field
Next Topic: Need to find login and logout information
Goto Forum:
  


Current Time: Tue Jul 29 00:44:21 CDT 2014

Total time taken to generate the page: 0.06218 seconds