How to use Browse "event"

[Peter.Greulich]

There is a browse event called "event". How does one use this? I can't seem to find any documentation on this.

And the broader question is, how can I code when a particular cell changes value in a browse where the user changes the value and uses the arrow keys to move up or down. Uing the browse OnFetch & OnChange doesn't seem to really help much.

[Al Buchholz]

Re: How to use Browse "event"

googled this - browse events site:alphasoftware.com

found this - http://wiki.alphasoftware.com/New+Browse+Controls+V9

___________

Remembered that v8 introduced some new functionality..

http://support.alphasoftware.com/Wha...e_Improvements

Browse Events - New Browse Events - Several new browse events are now supported for both stand alone and embedded browse layouts. OnSave - fires when a record in the Browse layout is saved. CanSave - fires when the user tries to save a record. The event can be cancelled by calling the cancel() function. <Column>_onChange - fires when data in a browse column is changed. The <Column> events are defined by inserting the appropriate functions calls into the Browse, Events script. For example, here is how to define an event handler for the 'lastname' column in a browse:

For a stand alone Browse, select Browse, Events, Events. For an embedded Browse, select Object, Event, Event, or right click on the Browse and select Events, Events

In the 'Events' script, define this function:

function lastname_OnChange as v ()

ui_msg_box("On Change Event for Browse. Browse name is: ",this.name())

end function

Note that the 'this' alias refers to the browse object that contains the browse column.

[Peter.Greulich]

Re: How to use Browse &quot;event&quot;

Thanks Al,

I did find that first link but it didn't help, but the 2nd one, of course, has the answer.

[Peter.Greulich]

Re: How to use Browse &quot;event&quot;

Unfortunately, that function seems to be fairly useless. It won't fire if you try to pass a value into it and it won't return a value since it is type "v".

[Al Buchholz]

Re: How to use Browse &quot;event&quot;

Unfortunately, that function seems to be fairly useless. It won't fire if you try to pass a value into it and it won't return a value since it is type "v".

That is not what you explained initially...

It is a UI event initiated when the user changes the value in a cell.

You can set a variable(s) to pass a value into it or out of the event.

[Peter.Greulich]

Re: How to use Browse &quot;event&quot;

You can set a variable(s) to pass a value into it or out of the event.

If you use global vars, which I did. So that works.

[Al Buchholz]

Re: How to use Browse &quot;event&quot;

If you use global vars, which I did. So that works.

So now it does what you want is elevated from 'fairly useless' to ?more useful?

The scope of the variables usually depend on where they are needed, but I use globals cuz it's easier than going back and making them global later...

[Stan Mathews]

Re: How to use Browse &quot;event&quot;

Don't let Ira hear you say that.

[Peter.Greulich]

Re: How to use Browse &quot;event&quot;

So now it does what you want is elevated from 'fairly useless' to ?more useful?

The scope of the variables usually depend on where they are needed, but I use globals cuz it's easier than going back and making them global later...

Here's what I mean:

This works:

function picked_OnChange as v ()	
	Dim Global vPicked as N
	trace.WriteLn(vPicked)
end function

This does not work/function won't even fire:

function picked_OnChange as v (vPicked as N)	
	trace.WriteLn(vPicked)
end function

[Al Buchholz]

Re: How to use Browse &quot;event&quot;

You're not calling the function and passing an argument.

Alpha calls the function when it detects a change in the field and it doesn't call with any arguments.

[martinwcole]

Re: How to use Browse &quot;event&quot;

This is interesting - quick question
with an embedded browse
say you have the fields product_code, gross_weight, tare_weight - in that order
if the user arrives at the tare_weight field, and has not filled in a gross_weight, how would you put code in an event to reposition the cursor at the gross_weight field?

[Peter.Greulich]

Re: How to use Browse &quot;event&quot;

This is interesting - quick question
with an embedded browse
say you have the fields product_code, gross_weight, tare_weight - in that order
if the user arrives at the tare_weight field, and has not filled in a gross_weight, how would you put code in an event to reposition the cursor at the gross_weight field?

Not sure you can. There is no "OnArrive" event for "events".

[martinwcole]

Re: How to use Browse &quot;event&quot;

Thanks Peter - I currently handle it in field rules, caneditfield

[Ray in Capetown]

Re: How to use Browse &quot;event&quot;

say you have the fields product_code, gross_weight, tare_weight - in that order
if the user arrives at the tare_weight field, and has not filled in a gross_weight, how would you put code in an event to reposition the cursor at the gross_weight field?

You have normal access to the browse, as with any function. You can address the gross_weight value as usual.
Here's a working example, when the line discount check is clicked applies a form discount on / off

function lncandisc_OnChange as v ()
if browse1:lnqty.value=0
		ui_dlg_box("OhOh","Requires a quantity")
		end
else if browse1:lncandisc.value=.t.
	browse1:lnprice.value=browse1:lnprice.value/(1+parentform:discountpc.value/100)
else
	browse1:lnprice.value=browse1:lnprice.value*(1+parentform:discountpc.value/100)
end if
end function

I cant do this with table rules. And I have an obsessive aversion to global variables.
AND the change occurs instantly as a table field rule would.

[martinwcole]

Re: How to use Browse &quot;event&quot;

Ray, in your test, if you don't enter a gross weight, what happens when it gets to the next field if the embedded browse?
in my case it has to auto-silently reposition itself at the gross weight field