Hi formspider team,

I have master-detail1-detail2 form. All three datasources use grid.

My problem is related to editing. I am in first row of detail1 grid. I modify a value in detail2 grid. I move to row 2 of detail1 grid. Return back to first row again. The changes I made in detail2 grid are lost.

This is happening because an execute_query command is issued in detail1 grid when row focus is changed.

I checked your demo master-detail-detail example. The changes are lost in the demo also.

The users should be able to make changes to master, detail1, detail2 datasources and move around freely without losing his work.

Kindly suggest a solution?

Regards, George.

asked 23 Sep '15, 06:19

grajan777's gravatar image

grajan777
1011226
accept rate: 10%


Hi George,

i ran into the same problem and solved it by checking for dirty datasources. If the master or detail is dirty, the user is asked to commit the changes.

This commit also saves changes in other datasources... I have not yet figured out if it is possible to save datasources separately.

The processing is very complex. Therefor i opened this thread to which you also responded. http://osqa.theformspider.com/questions/4450/is-there-a-checklist-to-make-sure-that-i-did-not-forget-anything-in-my-application

Hope this helps :)

Kind regards, Jan Willem

link

answered 23 Sep '15, 07:27

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131227
accept rate: 0%

Hi Jan,

Saving of every record/datasource is not the right solution. I am looking for a solution like in Oracle Forms where you can work on any number of tables in a page and move around freely without losing any work. This is the natural way and the right way users want to work. I wonder as to how Oracle did it around 20 years ago.

I am waiting for a solution recommended by formspider team.

Regards.

George.

link

answered 23 Sep '15, 08:03

grajan777's gravatar image

grajan777
1011226
accept rate: 10%

Hi George,

Oracle Forms has been built upon the principle "logical units of work". You can change as many tables as you wish before commit, but as soon as you mingle with the logical unit of work, Forms will ask you to commit. You will surely know the message "Do you want to commit the changes?", which was inherited from the Forms predecessor IAF/IAG 30 years ago :)

Because of the logical units of work, Oracle Forms does not allow to change a master record when changes are pending in its details. So, what you are asking is not possible in Oracle Forms... If it is however working for you, so if you can keep changes in details pending while parents are changing, that will probably be done by basing the block on a procedure that overrules the normal tables/view handling of Forms.

For what i have seen now from Formspider, this behaviour is exactly the same in Formspider. But as you say, perhaps the FS team knows a workaround to get it working. It appears to be a public holiday week in Turkey so the engineers will be back on Monday.

By the way, one of the most frequent complaints of Oracle Forms users is that they get the question to commit or not and really have no idea which changes they have made. So, if it was easy in Formspider, i would not use logical units of work anymore.

Kind regards, Jan Willem

link

answered 23 Sep '15, 08:48

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131227
accept rate: 0%

Hi Jan,

In the early versions of Form there was no, "Do you want to commit the changes?" This was added in the later versions. This can be simply overcome by replacing the Clear_Block(ASK_COMMIT) command with POST in CLEAR_ALL_MASTER_DETAILS procedure of the form;

You can keep on changing master-detail-detail without committing any data even when blocks are based on database tables.

If you want a sample .fmb file which functions exactly as I have mentioned above, I have no problem sending it to you. This was created newly for re-testing these features after your answer, as I forgot many things in Oracle Forms since I am out of touch with it now.

Any how it is a good idea to ask the users to save the changes before they navigate away from the master record as they can forget to save the data. But to keep on asking for saving changes on every detail table is very annoying.

Regards.

George

link

answered 23 Sep '15, 10:00

grajan777's gravatar image

grajan777
1011226
accept rate: 10%

edited 23 Sep '15, 10:13

Hi George, that's new for me :). As alpha tester I worked with Oracle to develop the first versions of Oracle Forms somewhere around 1987/88 and we had much discussions about this error message :)

Perhaps i have never noticed the new feature to allow changes in details for multiple parents, because after some years we started to use designer/headstart and almost never used Forms directly again.

What you say is true: the question to save changes is not user friendly. On modern user interfaces changes are almost saved automatically... Try to store your settings in Chrome, for example. I guess it depends on the application what's best. I will focus on this subject closely the next weeks when my fs-application goes in beta.

Kind regards, JW

(23 Sep '15, 10:57) Jan Willem V...

Hi Jan,

Formspier IDE is saving all the changes without ever asking the user.

Regards. Goerge.

link

answered 23 Sep '15, 11:12

grajan777's gravatar image

grajan777
1011226
accept rate: 10%

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:

×2

Asked: 23 Sep '15, 06:19

Seen: 881 times

Last updated: 23 Sep '15, 11:12

Related questions


© Copyright Gerger 2017