NetTalk Central

Author Topic: Parent Child refresh problem  (Read 3243 times)

MikeR

  • Sr. Member
  • ****
  • Posts: 257
    • View Profile
    • Email
Parent Child refresh problem
« on: March 14, 2014, 03:10:28 AM »
When adding a child record  of a parent, after the add, the parent table refreshes, however the child table remains the same, if you try adding a second record the focus is now on a different record, although it shows the children of the original parent, creating the perception that you are adding records to the same parent, however you are adding to the new parent as per example below.


Example (see attachment 1)

When we add students to a class the first record is fine as per image below, however when the second student is added the Classes refreshes however the Class Students is not refreshed, causing the second student we adding to be added to the wrong class as per second image below.


(See attachment 2)
As you can see the focus is on the first record Grade 1 , the class students are on Grade 5, but when I insert  the information is for Grade 1



[attachment deleted by admin]

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Parent Child refresh problem
« Reply #1 on: March 14, 2014, 03:29:29 AM »
Hi Mike how are you adding the child browse? Via the templates or adding a 2nd browse to a form? The latter can sometimes give you more control. Also do you have much embed code on the child update form?

MikeR

  • Sr. Member
  • ****
  • Posts: 257
    • View Profile
    • Email
Re: Parent Child refresh problem
« Reply #2 on: March 14, 2014, 04:36:47 AM »
Hi Kevin.
There is no embeded code.
Only two browseTemplates
The parent has the second browse as a child
The child browse is filtered on the parent record.
 

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Parent Child refresh problem
« Reply #3 on: March 26, 2014, 05:30:24 AM »
I have experienced exactly this issue is 7.35. Is your child form called as popup? If it is uncheck the call as popup on the browse form tab and test if it still occurs.
It's possible that The refresh whole browse after change on the browse form\change tab may help although since you are talking about in insert it may have no effect.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

MikeR

  • Sr. Member
  • ****
  • Posts: 257
    • View Profile
    • Email
Re: Parent Child refresh problem
« Reply #4 on: March 27, 2014, 01:37:34 AM »
Hi Terry

Yes, my child insert was set as a pop-up. I have unchecked the pop-up on the child form and this has resolved the problem.

Bruce I'm out of the office for the next couple of days but will post an example when I'm back.

Thanks

MikeR

  • Sr. Member
  • ****
  • Posts: 257
    • View Profile
    • Email
Re: Parent Child refresh problem
« Reply #5 on: March 28, 2014, 02:26:07 AM »
Hi Bruce

I have included an example with data, the app and dictionary. The Login  and password is admin

If you add students to the class on the first page no problem, however if you page to the next page of the parent records and then add a student you will notice that the parent page is refreshed.

This only happens if you using a pop-up form, it works fine using a normal form.

Cheers
Mike

[attachment deleted by admin]

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Parent Child refresh problem
« Reply #6 on: April 09, 2014, 06:55:36 AM »
Hello, I have had the same problem appears when we use some filter.

I stayed in version 7.10, I can not upgrade my systems to version 8 for this reason.

Left a attached example (webserver exampes Books (71) with a filter)

Thanks and I hope comments

Agustín

[attachment deleted by admin]

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11183
    • View Profile
Re: Parent Child refresh problem
« Reply #7 on: April 16, 2014, 01:12:16 AM »
Hi Mike,

I've tweaked this for build 8.08 so it should be ok.

Augstin: Let me know the exact sequence to duplicate the problem in that example 71, and I'll confirm it's fixed there too.

cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Parent Child refresh problem
« Reply #8 on: April 16, 2014, 03:41:43 PM »
Bruce. (I send the sequence. I hope you understand me)

* In Filter form
1) I declare a variable (LOC: FILTER) (in filter form) to filter BrowseInvoices.

* In BrowseInvoices
1) Filters -> conditional filters -> I call parent procedure (filter) 'INV: Customer =' & p_web.GSV ('Loc: Filter')
2) I call the procedure child (children tab) (BrowseLineItems)

* In BrowseLineItems
1) Filter tabs table relationship with the invoice table (BrowseInvoices)

Problem.

When I want to insert from the form (UpdateLineItems) Registry lose focus.

attached image

[attachment deleted by admin]
« Last Edit: April 16, 2014, 03:44:39 PM by agustinh2000 »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11183
    • View Profile
Re: Parent Child refresh problem
« Reply #9 on: April 18, 2014, 02:15:23 AM »
unrelated tip: in that example, UpdateInvoices procedure, is a line of embed code;
loc:options = 'beforeShowDay: jQuery.datepicker.noWeekends'
You should just remove it (it causes a GPF in NT8).

Other than that the app seems to work ok Augustin, so it appears the problem is sorted out.
« Last Edit: April 18, 2014, 02:17:33 AM by Bruce »

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Parent Child refresh problem
« Reply #10 on: April 18, 2014, 06:18:24 AM »
you're right, the image is another example.
I test.

thanks

Agustín