Embedded Browse and Active Link Table

[Terrymorgan]

A button on another form will close & reopen the form as required, but it only runs successfully by clicking the button anything else programmatically just fails to reopen the form
May get there but running out of ideas

[Ted Giles]

BTW.
I am not haunting the site.

As Mayor, I get email almost constantly, so I am plugged in to my Tablet and can't resist peeking.

There has to be a solution, just not found it yet.

[Terrymorgan]

Obviously we have been on the same track
i have a button on another form which closes & then opens the form I wish to resynch, no resynch is necessary as when the form is opened again it is synced.
what I cannot do is get that button to work from the original form using push event as it just closes the form
still trying though
I will try your suggestion next

[Ted Giles]

I have gone in circles also, however, using a separate form to handle the refresh, you can close and open the data form quite neatly

Button on Data Form - I called it Refresh. It;s a bit like the Backup - you could say it was a requirement that the current form is closed during the process
Action - Close current form
Action - Open refresh form

Button on Refresh Form - I haven't tried launching the actions OnInit in the form
Action - Run the Resynch process
Action - Close current form
Action - Open Data form

[Terrymorgan]

No that doesnt work as when the form opens again it is brought to the front - back to the drawing board

[Terrymorgan]

Got the work around, as the close & reopen would refresh, i ended up using the timer of a different form (my main app menu) to do this
Thanks

[Ted Giles]

Solved it.
There is an Action Script event which allows you to refresh active tables.
However, the active link needs to be part of a Set with a 1:M relationship.

What I did was create a set based on the active linked tables, added a button with the Action Script attached.
Then, in my world, the Active Links were updated, although you sill need to go to the last record to see the changes.

The only other way I can imagine this working while not annoying users is to have a button which opens a resynch form, closes the current one and reopens after resynching.

Something like "You should Synchronise Your Data" - Opens a new form, closes the view form
"Click Synchronise" in new form.
Reopen Viewing form.

It's a bit of a faff but manageable.

[Terrymorgan]

I was already using resynch to no avail
form close and then reopen does not seem to work when added to the ontimer event, as it just seems to close the form but not reopen it, even with a sleep between
thanks

[Ted Giles]

Look at OBJECT.RESYNCH method in the documentation.
Else, quick and dirty you could freeze, close, open, unfreeze.

If your table is large, you will be waiting a long time I suspect to get a refresh.

[Terrymorgan]

I have moved a table from dbf to sql with an active link Table.
The Form with an embedded browse refreshed easily with the dbf but the only way i can get it to refresh with the active link table is to close & reopen the form.
I also notice just opening a default browse for an active link table does not refresh unless the browse is closed & reopened.
How do I get the form/embedded browse these to refresh programatically?
Thanks
Terry