Where should I call Resynch()

[Jose de Leon]

I'm having trouble synching my form with records that have been modified in a script.

I have a set with 5 one-to-many links (call them table1, table2, etc.) to the primary table. The form has a tab object. Each tab contains an embedded browse for each one-to-many link.

What happens is that if a person enters data into table1, I have a field rule event for OnSaveRecord() for table1 such that depending on certain conditions, it will automatically insert a record into table2. This works fine and is not a problem. The data is properly inserted.

The problem is that the embedded browse for table2 is not updated and the record does not show until the primary table's record pointer is moved and then returned.

I have tried .Resynch() in several events with no success. Where should I apply Resynch() to get the embedded browse to updated its list correctly?

Thanks,
Jose

[Finian Lennon]

RE: Where should I call Resynch()

On way you might try would be to put something like this code at the end of the OnSave Event, if your form is called EntryForm and you give the table2 browse an object name (in Form properties) called table2_browse

f=Obj(":EntryForm")
if is_object(f) then
br=f:table2_browse.this
br.resynch()

which should resynch the browse. Sometimes, however, bringing all browses in a form up to synch (without moving the record pointer) can be a pain.

Finian

[Jose de Leon]

RE: Where should I call Resynch()

Tried your suggestion with no luck.

An interesting thing is that if after the record is inserted into table2, then I click on the tab for table2 and move to another tab and back, there is no updated, BUT, if I click on the tab for table2, then click in the browse, then click on another tab and back, the browse is updated!?

Perhaps I need to make the table2_browse the focus and then try to resynch()?

[Finian Lennon]

RE: Where should I call Resynch()

"Perhaps I need to make the table2_browse the focus and then try to resynch()?"

I've yet to hit upon a guaranteed method but you can try adding a
f.resynch()
to resynch the form and/or a
br. fetch_first()
br.activate()
if that's what you want to do after the record is added.

Finian

[Jose de Leon]

RE: Where should I call Resynch()

Still no go. I'm wondering if that is the proper way to access the browse functions? The browse is in a tabbed object.

Shouldn't it be accessed perhaps like this:

:Form:Tab:Browse.resynch()

I've tried the line above but it doesn't work. Is there a specific way to access the browse on a tabbed object?

I know I can resynch the records if I wasn't using a tabbed object. There must be something about a tab that requires a different expression or requires the update to occur in a different event?

Thanks,
Jose

[Tom Cone Jr]

RE: Where should I call Resynch()

Jose, I think you need to address the particular tab page upon which the browse is located... and I think maybe you need to refresh() the browse instead of resynch the form...

something like this for the third tab page:

:Formname:tabbed3:Browse3.refresh()

You can check the name of the third page in your tabbed subform in design mode for the form. You can check the name of the browse object on the third page in your tabbed subform the same way.

This would have to modified for the names of the other tabbed pages and browse objects, of course.

-- tom

[Finian Lennon]

RE: Where should I call Resynch()

Have you checked the properties of the browse as an object on the form? A5 will give it a sequential browse1 or browse2 by default. I usually change these names to something more meaningful. Then I can address the object without any reference to the tabbed form.

Finian

[Jose de Leon]

RE: Where should I call Resynch()

Tried renaming the browse in properties with no go. Tried Tom's suggestion too with no go.

[tlyon]

RE: Where should I call Resynch()

I have a form that sounds quite similar. To refer to browses on tabbed pages, I simply use the :formname:browsename method, ignoring any reference to the tabbed object entirely. If you are trying to cause a refresh to occur live, while you are viewing the browse, this can be extremely tricky. I don't try to do that anymore because of the difficulty of it. However, when I select the tab after the browse table has been updated, it does reflect the changed data.

Tom Lyon

[martinwcole]

RE: Where should I call Resynch()

I have wresteled with this phenomenon for the past year to no avail - with the following exception:

tom Cone, when I was a first day neophyte, took me under his wing for a while and helped me immeasureably. one of his golden rules is "don't add records to a child table from the embedded browse" - always use a separate form - which tom and i called the childaddrecordform and/or the childeditrecordform in our emails.

Now what I have discovered is this - if, when you add a record to the child, change data on the record, and do so with a separate form, CLOSE THE PARENT FORM when you load the childaddeditrecordform and reopen it when you finish, using a global variable to keep track of the customer number and at the onactivate event of the main form if that variable is greater than one or whatever fetch that record. MOST OF THE TIME this works, although I sometimes have to say :browse1.fetch_first().

I don't know if this will help you - but this is the general way I go about it - hopefully version 5 will address this issue as i have seen many messages pertaining to it.

if you want more specifics or code examples email or reply.

Martin

[Peter.Wayne]

RE: Where should I call Resynch()

Instead of a resynch() try using
sys_send_keys("{F5}")