Save only active window / single datasource?

Hi,

As I understand, api_application.doCommit commits all changed datasources to the database, but is there an option to commit only changes made in a single datasource? (something like api_datasource.doCommit(<datasource_name>)

Thanks, Michiel

docommit datasources

asked 24 Feb '12, 08:28

Michiel A
516●1●5●44
accept rate: 13%

6 Answers:

oldest newest most voted

0	Hi Michiel, The team implemented this feature today. It will be available in the next version. link answered 27 Feb '12, 15:34 Yalim K. Gerger ♦♦ 191●4 accept rate: 20%

0	Hi Michiel, there is just one commit api, api_application.doCommit link answered 24 Feb '12, 08:50 Ugur Kocak ♦ 561●6 accept rate: 23% edited 24 Feb '12, 08:51

0	Hi Michiel, If this is a critical feature you need or would make your life much easier, we can implement it relatively quickly. link answered 24 Feb '12, 23:49 Yalim K. Gerger ♦♦ 191●4 accept rate: 20%

Hi Yalim,

This is indeed a critical feature for me. For example, when a user is in the process of entering a shipment, and finds that he is missing some master data in order to complete the shipment registration process, he needs to be able to add the master data (for example a new customer) and after that complete the shipment.
At that time i cannot do a doCommit, because it will throw validation errors because the shipment details are incomplete. Starting another application session and adding the master data there is not very user friendly, and besides that you would need to requery the datasource in the shipment session somehow in order to see the change and select the new master data record. In Oracle Forms i can solve this by opening a Form in a new session and commit only that session, so it wont validate my shipment.

It would be great if it were possible in Formspider to commit only a single datasource to the database if you want to.

Thanks, Michiel

link

answered 25 Feb '12, 02:09

Michiel A
516●1●5●44
accept rate: 13%

edited 25 Feb '12, 02:10

0	Hi Yalim, Good news, thanks. Michiel link answered 28 Feb '12, 09:25 Michiel A 516●1●5●44 accept rate: 13%

Hello,

the 1.6 API's says:

public docommit(in_datasourcename_tx IN varchar2) public docommit(in_datasourcenames_tt IN tt_datasourcenames)

but the package spec in in FS 1.6 has only the old one public procedure. (procedure doCommit;)

Is this feature not implementet in FS1.6 ?

Thanks Uwe

link

answered 20 Nov '13, 10:25

Uwe K
1●1●2●3
accept rate: 0%

Hi Uwe,

These APIs are existing under api_datasource package, I guess you are checking the spec of the api_application package. Please make sure that you are checking the api_datasource package spec.

Regards,
Ibrahim

(20 Nov '13, 10:51) Ibrahim Sand... ♦♦

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

datasources ×6
docommit ×6