Current Position:Home > How to avoid multiple DataConnections with LCD ES2

How to avoid multiple DataConnections with LCD ES2

Update:10-11Source: network consolidation
Advertisement
Hi, we are just starting using the data connections to connect via a database with LiveCycle Designer. It seems we are missing something important regarding to manipulation of data from the PDF.
At first we have tried to apply a INSERT command to our first table and be able to browse through the items in the database. We are able to browse through the database only before we have inserted something.
If we insert an item and then try to browse through the database with (Next, Previous, Last or First) it will crash and have an error of the following :
(Next, Previous, Last or First) failed. Multiple-step operation generated errors. check each status value [ID:@11]
So then we have decided to create a second data connection which would have each of the column in the database except for the ID which appears to make everything crash.
E.G.:  Table_1
DataConnection1 --> ID, Field1, Field2, Field3, Field4          SELECT Command connection
DataConnection2 --> Field1, Field2, Field3, Field4               INSERT Command connection
Seems like we can't have a SELECT and INSERT in the same DataConnection because with those 2 different connections it works fine....
Then we are trying to show multiple data's in a table which is linked with the ID of the Selected ID in DataConnection1.. To show the data is all fine using a 3rd connection for that Table_2, then we are making sure a blank row is always there at the end of the table to be able to add this new entry to the database with a Add button to INSERT into the Table_2... Unfortunately we do not have a 2nd connection to that table because we cannot link those fields with the database for the purpose of a multiple entry view.
We have tried to make a 2nd connection for the purpose of the INSERT but it doesnt work at all.
We are basing ourselves on the sample provided by Stefan Cameron in his blog http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/
I am wondering if we are using the right functionalities and if it is the simplest way to work with databases...
If anyone can help, it would be greatly appreciated!!
Thanks in advance!
Mag

The Best Answer

Advertisement
Don't forget to activate the RESOURCE_LIMIT parameter, which default is FALSE :
alter system set RESOURCE_LIMIT = true;
Laurent, I had a similar problem some time ago : I didn't want to avoid multiple access, but only control who was doing what. That's because moving from Client/Server to Web the TERMINAL column in V$SESSION becomes useless.
I tried your solution, but I had to give up with it, because in my Forms9i application some forms call Reports, which generate a new session.
I decided to use DBMS_APPLICATION_INFO, and this is satisfactory for my requirements, but I'm interested to discover other solutions.
P.S. with my solution I'm able to limit accesses, because in the CLIENT_INFO string I put, among other things, the
application user, so I can control if an user is already connected. The problem is that existing applications have to be modified .....:-(
  • How to avoid multiple DataConnections with LCD ES2 Update:10-11

    Hi, we are just starting using the data connections to connect via a database with LiveCycle Designer. It seems we are missing something important regarding to manipulation of data from the PDF. At first we have tried to apply a INSERT command to our

  • How to avoide multiple duplicate entries in adress book? Update:10-11

    How to avoide multiple duplicate entries in adress book? I can add the same contact name and number more than twice and the phone isn't warning me at all!!! I's quite a heck for me.not possible from inside AB AFAIK. but you can do the following. in f

  • How to avoid multiple call to function: Update:11-30

    In our datawarehouse we have a huge receipt row table where all metrics ar stored in the local currency. On top over that we have views which calculate metrics to the desired currency. So basically all views looks like this select geo_region, product

  • How to avoid multiple selection in ALV tree control? Update:11-30

    Hi, Experts, I want to avoid multiple selections on Alv tree control after pressing control keyboard button(Ctrl). Even by pressing Ctrl keyword button i want to select only one row of a Alv tree control.i have used cl_salv_tree class for it is there

  • Rewriting SQL to avoid multiple scan of a table Update:11-30

    Hi, Is it possible to rewrite the following statement in order to avoid multiple scan of the tables: SELECT (ACT.ID_ACCES_CLIENT_TYPE * 100000) + 30024 ss_key, TO_CHAR(( SYSDATE ),'MM/DD/YYYY') date_key, 30024 transtype_key, ACT.ID_ACCES_CLIENT_TYPE

  • [svn:fx-trunk] 21141: Bug: 2780176 - Logging and logging out multiple times in LCDS can cause duplicate session detected errors . Update:11-30

    Revision: 21141 Revision: 21141 Author:   [email protected] Date:     2011-04-26 06:40:39 -0700 (Tue, 26 Apr 2011) Log Message: Bug: 2780176 - Logging and logging out multiple times in LCDS can cause duplicate session detected errors. QA: Yes Doc: No

  • How to avoid multiple votings? Update:11-30

    Hello All. How can I avoid, that there are multiple votings from one person?I think there is no option to avoid multiple votings. Adobe has not implemented this funktion. Formstack is as alternative to Formcentral. The Fieldoption there is called - U

  • How to avoid multiple LOGIN with same user in database. Update:11-30

    Hi All, Using database triggers how to control multiple logins of a pertiuclar user. thanks in advanceDon't forget to activate the RESOURCE_LIMIT parameter, which default is FALSE : alter system set RESOURCE_LIMIT = true; Laurent, I had a similar pro

  • How to avoid multiple users to access same tcode Update:11-30

    Hi all, Am creating one z tcode to display the material details for the particular reservation number. How can  I avoid multiple users to access the same tcode simultaneously. If anybody works over that tcode then no other user should be able to acce

  • How to avoid multiple password prompt for intarnet portal Update:11-30

    we have developed a intranet portal in Share Point 2013 with multiple site collection. when accessing through IE, Chrome, we can do settings to avoid multiple password prompt by adding the domain name of site in Trusted sites. How we can achieve the