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

asked 24 Feb '12, 08:28

Michiel%20A's gravatar image

Michiel A
5161648
accept rate: 13%


Hi Michiel,

The team implemented this feature today. It will be available in the next version.

link

answered 27 Feb '12, 15:34

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
accept rate: 20%

Hi Michiel,

there is just one commit api, api_application.doCommit

link

answered 24 Feb '12, 08:50

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

edited 24 Feb '12, 08:51

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%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
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%20A's gravatar image

Michiel A
5161648
accept rate: 13%

edited 25 Feb '12, 02:10

Hi Yalim,

Good news, thanks.

Michiel

link

answered 28 Feb '12, 09:25

Michiel%20A's gravatar image

Michiel A
5161648
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%20K's gravatar image

Uwe K
1123
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

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

Tags:

×6
×6

Asked: 24 Feb '12, 08:28

Seen: 3,164 times

Last updated: 20 Nov '13, 10:51


© Copyright Gerger 2017