Refreshing Browses

[tlyon]

Good Morning!

I've wrestled with browses until I was blue in the face, but I've got it working in my application, finally.
The application is for live phone call tracking. The form is a popup form. When the operator picks up a call, it is entered into the browse. The technicians on the other workstations then see this call come in and can see if it is directed to them. I use the form's OnTimer event to refresh the browse. The interval can be anything, but since we have fairly fast machines here, I use an interval of 1 second. When the technician hangs up the call, it disappears from the browse list. I also have a flag that indicates whether or not the form is idle. If it is idle, then the refresh occurs. Otherwise, it waits to refresh until the delay counter reaches 0 or the form is idle.

This is the code I am using:

   tbl = table.current()
   query.description = "Calls"
   query.order = "LINENUMBER+INVERT(CDATE(CALLDATE))+INVERT(STARTTIME) "
   query.filter = "isblank('Done') "
   query.options = ""
   indx = tbl.query_create()
   :Callsset:browse1.index_set("Calls")
   :Callsset:browse1.resynch()
   :Callsset:browse1.refresh()
   :Callsset:browse1.fetch_goto(1)

I force the refresh routine to select the first record because I'm sorting in reverse order. The rest of the fields on the form (outside of the browse) are all refreshed individually depending on the idle flag. I've found that the tbl.fetch_*() method doesn't behave the same as using absolute addresses. Also, indexes do not refresh the same as queries. Indexes can be made to work, but it takes some tricks to do so and are time-consuming in operation.

Tom Lyon

[martinwcole]

RE: Refreshing Browses

thank's - I'm going to try this when I get a chance - previously, I had been closing the form when I was adding records with a childaddform and then reopening when i finished - the only reliable way I could get the browse to refresh

[whanigsberg]

RE: Refreshing Browses

Tom,

Perhaps I'm thick but where do you place this code.

Thanks,
Bill

[whanigsberg]

RE: Refreshing Browses

Let me rephrase. You enter data into a form and then you want to make sure that the embedded browse of a different table reflects the entry so you attach the code to the on_timer event of the form with the embedded browse.

Have I got it?

Thanks,
Bill

[tlyon]

RE: Refreshing Browses

That's pretty much it. In my case, the same form with embedded browse is open on all workstations. The OnTimer event handles the refreshing.

Tom Lyon

[Peter.Greulich]

RE: Refreshing Browses

I use the following script to refresh an embedded browse in the OnSave Form event:

Browse1.activate()
sys_send_keys("{F5}")

Always works for me.