Action script in a browse?

[Glenn Chandler]

How do I place an action script into a browse? The browse is used on a set form, and I want to get out of the browse without clicking the mouse into another field on the form. In the form layout the browse is just a single object, so I can't see how to add a script to a field within that object. The browse is a child in a set.

[Bill Harriff]

RE: Action script in a browse?

Glen,

I've just done something like I think you want to do. Open your form for editing, bring the tabbed page to the foreground that has the embedded browse, click the browse to make the selection box active and then right click inside the boundry of the selection box to bring up the context menu and "Actions..." should be the 2nd choice from the top.

Hope this helps...

Bill

[Glenn Chandler]

RE: Action script in a browse?

Hi Bill,

Thanks for your help. What I want is to enter over the last field of the browse and be returned back to the form. At the moment, entering creates a in the browse ... I need to click the mouse on another field of the form to get out of the browse. This is too inefficient with alot of records to edit.

Your suggestion appears to allow an action on the browse itself, whereas I want an action on or after a particular field in the browse.

Glenn

[Glenn Chandler]

RE: Action script in a browse?

Correction -
2nd line ... entering creates a new record in the browse.

[Mick Magnuson]

RE: Action script in a browse?

Hi Glen
You could use the forms OnKey event to jump to on object on the form. Focus changes by pressing a key rather then mouse click.

My scenario below: Form with an embedded browse (object name BROWSE1), date field on the form (object name DATE). OnKey set for the F10 down action to jump from the browse to the date field *only* if you are in the browse table.

if parentform.active()="browse1"
select
case a_user.key.value = "{f10}".and.a_user.key.event = "down"
a_user.key.handled = .T.
date.activate()
end select
end if

This is a very generic script that just switches focus, and does not handle any errors. If the user presses F10 in the middle of an entry in the browse, it saves and jumps to date. You can build more safety features in as needed.

Mick

[Mick Magnuson]

RE: Action script in a browse?

Me again - to the best of my knowledge you cannot associate an action for a particular field in a browse. Actions can only be executed on the browse object, not the fields contained within them.

At least in my travels I have never found a way to do it.
Mick

[whanigsberg]

RE: Action script in a browse?

The active previous drilldown method in V5 will take care of this for us. Meanwhile, you can code it manually in V4 using the browse double click event to react conditionally based on which column of the browse is active.

I used this to sort on the active browse field which the users like.

Bill

[whanigsberg]

RE: Action script in a browse?

Here is a script which does react to a field in an embedded browse object. As I mentioned it runs a query based on the value of a field in the browse. It then retitles the form's window to display the selection criterion.

So if you double click on the lastname field and the field contains "Jones" the browse will be filtered and the window title will read
Lastname="Jones"
which is not too interesting. But if you click on the department field and it contains English the window will read
Department="English"
and the browse will show only members of the English department.

The script is attached to the browse's row double click event. Writing it taught me a few things about object references.

Bill

[Steven Devaney]

RE: Action script in a browse?

can you repost the attachment... i get the error:

The requested URL /alphaphorum/files/200204/a5_ver4/02/57402/Filter was not
found on this server.

[martinwcole]

RE: Action script in a browse?

there is a way to respond to user entries in a browse for a particular field in a particular form - put code in field rules:

here is an example from my program. Although this code is at the caneditfield, you also have onedit, canwrite, and onwrote events to work with:

'on the form, in an embedded browse, the user fills in info for sales to be returned

if is_object(":returnforcredit")
tbl=table.get("payment history") 'undelying table to browse
if tbl.payment_date=date()
message="You cannot currently sell and return a Hearing Aid (or any charge or payment) on the same day. It will cause the daily report to be erroneous. You have two ways to deal with this. (1) Delete the charge or payment, (2) Enter the Return tomorrow - I intend to deal with this obscure possibility later. Martin, the programmer."
ui_msg_box("Error",message)
cancel()
:returnforcredit:button1.activate()'****put focus where you want it
end
end if
end if