Help with master/detail with grid as a detail!

Scriptcase 9 Discussion
#1

How to update fields in master form if detail app is grid instead a form as editable grid?

Macro sc_master_value can not be used in grid application. Also there is not an event suitable for calling this or a similar macro in grid application (see my previous post). Only event suitable for this may be onRecord (with lots of gymnastics).

Editable grid or editable grid view forms as a detail is useless for tables with to many fields.

Any help or other suggestion is welcome.

Greetings,

Dule

#2

There are several ways to do it.
Create a “service” and call it inside your grid. This call will be a JS Aajx call to this service (updating physicial table value) and then with JS modifiying the value on screen.
Another option could be to update your table with PHP inside your grid, and then

sc_redir(yourmasterform,,'_parent')
#3

I do not want to update a master database table (I know how to do that), but to update screen fields on a master form. This screen fields are not from database but added calculated fields. If macro “sc_master_value” can be called from grid that would be the easiest way. Why to use JS when we already have application link (with little pencil) on a grid to call a form. I understand that Scripcase is RAD tool and such simple task must be easy to do without knowing and using JS. А Form as detail can do that but а grid as а detail can not.

#4

Why to use JS when we already have application link (with little pencil) on a grid to call a form.

Because you can’t right now, and who knows if you will in the future. You asked how to do it, and I answered how. You have to work with JS.
Then, you have 2 options. follow my advice and change your mind, or wait to get that done by NetMake.

#5

Thank you for your suggestion, I will find a way to done. But I think that Netmake should do something to improve their product and help their users in a future.

At the moment, I’m a bit disappointed that this has not been resolved in the current version. Grid as a detail in master/detail is not supported as it should.

Thanks again for your fast response.