NetTalk Central

Author Topic: Child Browse  (Read 7175 times)

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Child Browse
« on: October 17, 2013, 10:41:01 AM »
Hi Bruce, from the new updates when I want to insert a new record into a child table lost the focus of the parent table. the record is saved well but I have to refresh the system and going out again. I Attach a picture.

thanks

Agustín

[attachment deleted by admin]

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #1 on: October 17, 2013, 10:34:07 PM »
7.27 is out today - let me know if it's still happening there.

cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #2 on: October 30, 2013, 03:26:59 AM »
Bruce, the problem persists in version 7.28

regards

Agustín

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #3 on: October 30, 2013, 04:00:06 AM »
I wasn't able to duplicate in the Books (71) example. So I'm guessing it might be related to your filter on the _Child_ browse. ie your Browse on Ordenes. What is your filter set there?

cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #4 on: October 30, 2013, 06:31:56 AM »
The problem is in the filter (form)

On set filter (parent browse):

Thisview {Prop: Filter} = 'SQL' & |
                            '(' & |
                            '(A.IdSucursal =' & p_web.GSV ('Loc: FiltroDropSucursal') & ')' & |
                            'AND' & |
                            '(A.TipoTrat = <39>' & CLIP (LEFT (p_web.GSV ('Loc: TipoTrat'))) & "<39>) '& |
                            ')'

Thanks

Agustín

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #5 on: October 30, 2013, 11:57:43 PM »
what is the contents of ThisView{prop:filter} after this call?

Any why set the filter like this, and not via the template?

cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #6 on: October 31, 2013, 04:50:07 AM »
A.IdSucursal is a field in the browse = Variable form (filter drop)

If necessary I send the app with the filter (form) and the 2 browse(It is in mysql)

I'm working on version 7.10, I can not update the following versions

attached an example

[attachment deleted by admin]
« Last Edit: October 31, 2013, 04:53:08 AM by agustinh2000 »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #7 on: October 31, 2013, 09:58:55 PM »
I don't think you answered my questions.

a) What is the contents of ThisView{prop:filter} after this call?
b) Any why set the filter like this, and not via the template?

>> I'm working on version 7.10, I can not update the following versions

ok, but if you can't update there's not much I can do to help.

Cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #8 on: November 01, 2013, 08:41:45 PM »
Ok, the first answer: it is a sql filter
the second answer is: do not use the template to make the filter

What I was saying about updates is that until version 7.10 I can work properly, after that I could not update because I have all filters with this method.

But for better understanding I attached a code sample (filter, child browse and browse)

Recall that the problem is that when I insert a record in the child lose focus browse

we are in contact

Agustín

[attachment deleted by admin]
« Last Edit: November 01, 2013, 08:43:21 PM by agustinh2000 »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #9 on: November 03, 2013, 09:42:43 PM »
I don't think you're understanding my questions properly;

>> a) What is the contents of ThisView{prop:filter} after this call?

> Ok, the first answer: it is a sql filter

What I mean is - tick on the Send Filter & Order to Debugview template option, cut the filter from Debugview, and post it here.

The second question could be worded better.

>> b) Any reason why you set the filter like this, and not via the template?

I understand what you are doing, I don't understand _why_ you are doing it.

Let me add another question;

c) If you set the template in the filter as normal, then does the problem persist?

cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #10 on: November 05, 2013, 06:22:11 AM »
Bruce, I send an example of the filter in Example 71. and 2 images.

Use the template to make the filter.

greetings and sorry for the lack of expression

Agustín

[attachment deleted by admin]

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #11 on: November 07, 2013, 10:21:06 PM »
Please post instructions on the path I need to take to duplicate the error in the example.

cheers
Bruce

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #12 on: November 08, 2013, 06:20:38 AM »
Ok.

1) I create a form (Filter) to add the filter (menu link invoice)
2) From the Filter tab procedure call (BrowseInvoices)
3) In Browse (BrowseInvoices) -> Actions-> Filter-> Conditional filters-> Child of Filter
4) In the Browse (BrowseInvoices) -> Actions -> Children (BrowseLineItems)

Insert a new record in BrowseLineItems and loses focus

regards

Agustín

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Child Browse
« Reply #13 on: November 11, 2013, 01:42:07 AM »
Ok, I see what is happening. The fix is not trivial though, so I'm investigating further.

cheers
Bruce




agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: Child Browse
« Reply #14 on: December 16, 2013, 03:46:16 AM »
Hi Bruce, in the future you believe that you can fix the bug?

I am working with version 7.10

regards

Agustín