Go From Browse To Form

[Wallo]

I want to show records in a browse for viewing purposes only and after selecting record to edit I want to open the form with selected record's data for editing purposes. Can't find way to do this. Any ideas?

Thanks

Wallo

[Keith Hubert]

Re: Go From Browse To Form

How about you put a button on the browse to open a form for that record?

[DRW]

Re: Go From Browse To Form

Use the browse�s OnRowDblClick event to define the appropriate action(s). You can have the event call a new form for editing purposes. Or you can have the event alter the data entry style and/or data entry restrictions properties of the parent form for the embedded browse to permit direct editing of the record with the browse focus and being simultaneously displayed by the form.

[Wallo]

Re: Go From Browse To Form

Thanks Keith for the idea, but since browses only show columns I can't find the way or the place to add a button, any suggestion.

[Wallo]

Re: Go From Browse To Form

I have already tried this but it does not work.
Although I am confident that code for opening form was right I'll verify it again. I get no response when doubleclicking.

Thanks

[Wallo]

Re: Go From Browse To Form

Ok DRW, the trick is that the browse has to be embedded in a form, this way dobleclking the row will work. In a stand alone browse it does not.

Thanks again

[DRW]

Re: Go From Browse To Form

No, it doesn't just apply to embedded browses unless something has changed from V9 to V10 (I'm using V9). You can open a saved browse (i.e. stand alone) and use the browse OnRowDblClick event to open a form for editing the record contents.

[goldberg2727]

Re: Go From Browse To Form

I use Browses with embedded buttons all the time for the exact purpose you mentioned.

Here is an example...

First setup the button in the browse. Here is a video that shows you how...

http://www.ajaxvideotutorials.com/vi...y/BuildBrowse/


Once you add the button to the browse view take the browse into design mode. Click the "Browse" button at the top of the screen next to the File, Edit, etc. Then select "Events", and then Select "Events" again.(shown in the picture) Once you click the Events button Then you will see a button_click function has already been added to the code. HEre is the code I use to open the form I want and show the record I clicked the button for.

Let me know if you have any questions. The video does a good job of explaining everything.

FUNCTION DATE_END_ButtonClick AS V ( event AS C, data AS C , row AS N )
'DESCRIPTION: Fired when a button is clicked on a column.
'Arguments:	event	- the name of the event that is fired
'			data	- the data in the column cell
'			row		- the row number in the browse
	'this.SetViewport_Row() sets the current row to the row with the button that was clicked.
	this.Set_Viewport_row(row)

	dim tbl as p
	dim id as c
	tbl = table.current()
	id = tbl.po_num
	'ui_msg_box("id",str(id))
	
	form.view("fAll")
	fAll.index_set("po_num")
	fAll.find(id)
	
'Close the Browse
brwproj.close()
END FUNCTION

[Tbaker]

Re: Go From Browse To Form

Here is another alterative - using a UDF and creating a button on a field in the named browse.

Download the zip file and extract it to a folder. The open with V10 and open form_fc_test.

The form has a named browse called BRW1 with a button on the name field that shows only when you activate that field in a row. There explanations on the form and the code is in the form's init event as well as the browse's event event.

FWIW

Tom Baker

[Keith Hubert]

Re: Go From Browse To Form

Hi Tom,

This is very neat. I like it.

Is there a problem with a5.System_Mode_Set("field_popup_button_position","inside") as this does not seem to work as expected. ie image Inside field.

[Tbaker]

Re: Go From Browse To Form

Keith

I had found the same thing. That is why it was in the OnInit code but it made no differnce whether you had Inside or Outside, the button would remain outside.

It must be something with named browses. If you create a named browse with say a date field and leave it a type in field, the Inside mode just does away with the little calendar icon. If you use outside, it is outside.

If you change the field from type in to calendar then the inside - outside holds.

I don't think it is a bug since it worked that way in Ver 9 and I know that there were a few posts on the forum about that.

It is only a minor inconvenience since as soon as the field loses focus the icon disappears.

What do you think - maybe we should start a new thread.

Tom

[Keith Hubert]

Re: Go From Browse To Form

Hi Tom,

I don't know about starting a new thread but just out of curiosity this works too.

a5.System_Mode_Set("field_popup_button_position","")

So, is this a bug or not?

[Tbaker]

Re: Go From Browse To Form

Keith

a5.System_Mode_Set("field_popup_button_position","")

is probably a default as it sets the mode to Outside

Don't know whether it is a bug or not.

Tom

[Tbaker]

Re: Go From Browse To Form

Keith

I thought I would send in a bug report on the a5.system_mode_set problem with inside outside.

I received the following from Cian Chambliss

The 'field_popup_button_position' option was added to control just the memo & image fields that had existed before. The only reason this setting was added was for backwards compatibility, because people were complaining because we moved the memo-edit buttons OUTSIDE the cell.
While what you describe would be a nice feature, It goes beyond the original intent.

Just for the record, I did write back that somewhere on this forum, there was discussion about the inside outside and someone from Alpha (don't remember who) chimed in with the A5.system_mode_set() function. I know it was in relation (I believe) to the calendar popping up with a "date" and type in field.

Just wanted to complete this post.

Tom

[Larry Ternowski]

Re: Go From Browse To Form

[quote=goldberg2727;533068]I use Browses with embedded buttons all the time for the exact purpose you mentioned.

Here is an example...

First setup the button in the browse. Here is a video that shows you how...

http://www.ajaxvideotutorials.com/vi...y/BuildBrowse/


Lee, thanks for the idea, I have been struggling with issues since upgrading from V9 to V10, had to go back to V9 as I lost some built in functionality. This idea looks like it will get me moving forward with V-10.