Application Express :: Creating App That Works On Both Desktop And Mobile?
Nov 14, 2012
I know that there is now an option in the shared components to set the home page/theme for Desktop display as well as for Mobile display. So the app would automatically know what interface should be rendered based on the device running on. Do I need two versions of each app page (just like the login page) in order to have the app work on BOTH desktop and Mobile ? the reason I am asking is that an AEPX page can have one and only one template/theme. So if I have an app (desktop app) of 10 pages , should I replicate those 10 pages and make them mobile pages. If yes then how do I tell the to navigate differently (branch from page to page) based on the used device ?
i'm on apex.oracle.com creating a mobile application. When creating a new region of type report -> Listview it results in an error if the query is too big (or returns too many columns).The error is: Error during rendering of region "Add Javascript code for Plugins". ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The query i used: SELECT * FROM APEX_APPLICATION_PAGE_ITEMS
get Syntax Highlighting for the Application Builder: URL....
Trying to learn about Oracle Database Mobile Server.Installed the server, installed the client on WIN 32, created a publication and successfully synchronized.Now need to write a client application for mobile users.
Qs 1) Can I write a simple JSP that reads a table from device SQLITE database?or, the JSP needs to read off a subscrption?If it needs a subscription as the source, then how do I mention it in the JSP?
I was having a play with an icon menu system on apex mobile using a list template as described by Peter Raganitsch.Improve the APEX mobile Theme – Part 3 | get along with Oracle and APEX Though instead of using images from /i/, I wanted to source images from the database using apex_util.get_blob_file_src
However the rendered output begins <img src="/i/apex_util.get_blob_file? If I run the following on page load $('img').each(function() { $(this).attr('src', $(this).attr('src').substr(3)); });
I get the output I want but the console is still full of errors and I feel very dirty.of displaying icon images from a report in the mobile interface?ie - similar to an iconic interactive report.
I'm running a mobile application on a hosted Apex environment which uses lots of jQuery mobile. The environment has been updated to 4.2 recently, and since that happened pages that I had setup to use the content grid, to show content in 3 columns no longer works, there only appears to be 1 column now.
how to combine APEX 4.2 with jquery mobile componentsOn one page with a hole bunch of components there is also a popup-div<div id="myPopup" data-role="popup">
<!-- close button, safe button, input field and short list... --> </div>It gets opened with js: $( "#myPopup" ).popup( "open" );
This all works fine, besides the face that it only works after refreshing the page! The page gets loaded via js: $.mobile.changePage('f?p='+ $v('pFlowId') +':20:' + $v('pInstance') { transition:"slide", reloadPage:true });...
which also works fine so far. That same problem I had before when I was using a dialog instead of the popup. - only showing after refreshing the page.
This certainly must have something to do with how JQM loads and renders the page (besides the APEX-job) - a rather basic issue. I have also tried different ways of calling the page, with no difference to that problem.
Tabular form works fine for first entries, but upon going back to add more records Page 55 has a button that links to the 'Approval' page which is a tabular form (Page 56).A text field at top of this tabular form receives the pass of a varchar2 field from page X which is an identifier (not PK). Tabular form query has condition WHERE ISO_NUMBER = :P56_ISO_NUMBER
When I add records on the first pass to the tabular form and click submit all is fine and dandy.When I get out of the tabular form and go back to it and add additional records I get this error:
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "C4B43B9A17A41D287D55DEFE9B035944", item checksum = "607C07E22C9B03E6A45AF44EDC06BB31"., update "SPICE_HUNTER1"."DOC_APPRV_DOC" set "APPRV_DOC_ID" = :b1, "DOC_INFO_ID" = :b2, "ISO_NUMBER" = :b3, "DOC_APPROVER" = :b4, "DOC_APPROVED" = :b5, "DOC_APPROVAL_DT" = :b6, "DOC_COMMENT" = :b7, "APP_USER" = :b8Here's what I've done to try to figure it out:
1. Ran debug and saw it was happening in my MRU; and 2. In the past what I have cleaned out tabular form table data because I've found that when I'm in this testing mode going back and forth with changes gets fouled up, but with a clean slate it still happens. 3. I had Hidden the ID fields, and then remembered this was one of the issues with versions of this error. (I actually logged this one to remember!). So I made them Display as Text (Saves State) and unchecked their boxes.
I have created a JQuery mobile template for APEX which at the moment is just returning data from my database in a reports region. Is it possible to include a search bar before the user sees any data so they can search for records in the database and return them to the results page I have already created?
If so what is the best approach with the mobile template?
Event: click. type: jquery selector selector: a.show_popup no condition.
action: skillbuildersmodalpage 2.0.0 URL: attribute of triggering element.
This works fine, but after the popup is shown and closed, the link is not working until the page is entirely refreshed again.
after the popup is closed, i only refresh the report with $a_report , ( in another dynamic action on the "auto close skillbuolders" event) i don't want to submit all the page....the partial refresh is working fine too, but not the link, it only works again by refreshing or submiting all page
I Have installed the oracle database 11g, the oracle database mobile server and i use Glassfish as the application server. Everything is fine i have tested the mobile server configuration using Oracle mobile server workbench the mobile server runs but when i want to connect to the mobile manager workspace via the browser using
[URL].......
I have a server error HTTP 404- The requested resource () is not available .
I have created a procedure within a database package, but when I want to create a form based on procedure but I can't call it. I think that I have to use prefix, I am a beginner in database and I don't know how to do this.
In APEX I've always created form on report so as to have the list of records of a table and the possibility of inserting/updating every sinle record by means of the form on it, ok?I have an application concerning classic costumers, orders, ... with a table for every item.
The problem is that I have to gather all information ao as to produce a classic bill with a typical layout where you have on your left some descriptions and on your right an amount but of course the layout is not based on a classic table, do you mean?Do I have to create a table in which I'll add data and null values so as to get the layout desired
I have an Interactive Report with a column that I need to create a link on but I need to pass the value of another column.
This report shows the Features of a particular Release. There is a select list for the Release that is selected and executes the report. There is a column that indicates whether the Feature has a Commitment attached to it. If there is have that a link to another report that shows all the Commitments for that Feature by passing the FEATURE_ID which is also a column on the Feature report.
Query: SELECT .... ,CASE WHEN ft.feature_id IN (SELECT cc.feature_id FROM customer_commitments cc WHERE ft.feature_id = cc.feature_id ) THEN 'Yes' ELSE 'No' END "Commitment Exists" ,ft.feature_id ....
FROM ....If "Commitment Exists" has a 'Yes', the 'Yes' is a link that will pass the FEATURE_ID to another report that will show the Commitments for that Feature. If the "Commitment Exists" has a 'No' then no link. I was also wondering if the Commitment report could open in a seperate window and make it modal?
I'm trying to create a functionality on my application that lets the user change their password whenever they want or when the password gets expired.
But to do that, first I need a Branch to the page "Password Change" whenever the login procedure returns "Password Expire", but when the user has an expired password he can't access none of the pages of the application.
My other problem is:
Even if I can get the user to be redirect to the "Password Change" page, I would need a function that validate his current expired password, because in order to alter his own, he would need to inform his current password and the new one he desires. If I was using Apex Authentication that would be very easy I think, but I'm obligate to use Database Account Authentication.
I have a form on a table that allows me to edit, delete, or create records. If I choose to edit a record from the report the form get populated correctly and edits or deletes work fine. My problem is when I choose to create a new record. I get a blank form which is what I want, but once I fill it out and click the create button, the automated row fetch fires again and gives me a no data found error. How do I get it to not fire when the create button is pressed?
i m using Apex4.1 and data base oracle 11g, browser firefox
i m using recaptcha plugins i had tried it with both way by creating 3 hidden field and and also directly with taking a item based on plugin. URL.....
More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and redirect to another page. The problem I'm running into is that the text item is always submitted regardless of the captcha.
We use Apex 4.2 with Apex Listener. Recently we patched apex to 4.2.2 and now when we try to create a form based on a table, after selecting the schema and table we get the following error: "You do not have access to the schema that you are importing.
Import failed" I've seen some posts regarding this error but nothing that works with my current situation. The database grants are in place.
I need to create a forgot password page in which there will be two text box named user name and email id and user will provide his usename and email id in those text box. so apex will check that the provided name and email id are there in the data base and if email id corresponds to right user name then a mail will be send to that email Id containing auto generated password.
i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.
.I am trying to install Discoverer Desktop 9.0.4 on a windows 7 x86 machine. I know the product is obsolete, but this is only temporary as we transition to a new platform.
I am able to install the software just fine; what I cannot do is log in. I keep getting
Unable to connect to: discov_user@op012 Failed to connect to database - ORA-02248: invalid option for ALTER SESSION
The NLS_LANG for the database is at AMERICAN.AMERICA.WE8MSWIN1252 I have set it on the client to match I have deleted it from the registries I have created a system variable
Nothing works. I know the tnsnames.ora file is correct as the exact same load works fine on a XP machine.
I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.
I have a form developed using Oracle 10g Forms Builder. It is deployed on server. I need to track who is remotely accessing the desktop and running this form. How can we track this. Are there any webutil commands to trace the application used to access the desktop? What is the work around for this?
We are setting RAC between two machines(Desktop PC connected wirth LAN ....have storage Local to them and no Shared storage..Only NFS).We have shared the mount point by NFS.We do not have any shared storage but we need to share the RAW files to setup the OCR and VOTING DISKS.
The problem is:
1. We need to keep the RAW devices for OCR and voting disk common to the machines (Desktop PC..both Linux OELU5). I am able to create the raw file systems but that is local to one machine. I am not able to understand how to share the raw devices between two machines.
2. Tried to use ISCSI utility but that did not work. (How_to_use_iSCSI_Targets_on_Linux)
Scenario : One Machine has 500 GB Storage. Second machine has 80 GB Storage. Made private and public networks(Used two Network cards in LAN). All are communicating.
Problem : Need to make the storage 300GB (Out of 500 GB) of Machine 1 as shared storage. How can we do that? (Do we need any virtual software...ex .. vmware for that?)