Record selector in Embedded browse

[barry685]

Is it possible when selecting multiple records by dragging on the record selector (in an embedded browse), to use Action scripting to process those records? For instance I want to append those records to another table.

[Mike Wilson]

Re: Record selector in Embedded browse

There was a thread on this board maybe a couple of years ago where, I believe, G Gabriel came up with a method to do this. I am still looking for it, but I am not very good at searching this board for old subjects, so I may not ever find it.

[barry685]

Re: Record selector in Embedded browse

One option might be to select them and mark them, and then process the marked records.

[Stan Mathews]

Re: Record selector in Embedded browse

Maybe CURRENT_HIGHLIGHTED_RECORDS()

[barry685]

Re: Record selector in Embedded browse

will try that Stan

[Mike Wilson]

Re: Record selector in Embedded browse

I tied it using the example in the Docs for CURRENT_HIGHLIGHTED_RECORDS() on alphasport. It doesn't work in my hands.

[Mike Wilson]

Re: Record selector in Embedded browse

Barry,
you could use a method of marking the first and last record and have a script mark the in between records and copy them to the other table (see example attached).

[barry685]

Re: Record selector in Embedded browse

Hi Mike,
The script is not necessary. Once you select the records pressing ctrl+m will mark them all.

[martinwcole]

Re: Record selector in Embedded browse

I use a custom right click menu for an embedded browse - where the user drags to highlight a group of rows, right clicks and makes a selection which then processes a custom script

'Date Created: 30-Sep-2009 06:39:34 AM
'Last Updated: 01-Jun-2011 07:05:29 PM
'Created By  : martin cole
'Updated By  : martin cole
on error goto errors
'parentform.commit()
t1=table.current()
t=t1.get_cursor()
gpc=browse1.selected_records()
if gpc=""
	msgbox("Note","No records selected - try again.")
	end 
end if 
n=w_count(gpc,crlf())
for i=1 to n 
	t.fetch_goto(val(word(gpc,i,crlf())))
	t.change_begin()
		t.mark()
	t.change_end()
next
browse1.restrict_edit=.f.
browse1.restrict_editing=.f.
browse1.restrict_change=.f.
browse1.refresh()
rec_mkd.refresh()
cond1.refresh()
end 
errors:
err_msg = error_text_get(error_code_get())
line = error_line_number_get()
script = error_script_get()
ui_msg_box("Error", err_msg+" Error occurred at line "+alltrim(str(line,4,0))+ " in script: "+script)
end

[martinwcole]

Re: Record selector in Embedded browse

I've been posting images here for years - and now I can't get it attach an image - how do I do it?

[martinwcole]

Re: Record selector in Embedded browse

Well ... I give up - I made another png file, and selected it to upload in manage attachments - and it would not upload, apparently - have tried this about 15 times with the same results

[barry685]

Re: Record selector in Embedded browse

Hi Martin,
I don't know xbasic. So I am working with AS. I can with a button, using AS and marking, mark all the selected records (but it's slow) and continue working with those records. There is something I have to do at the end of the sequence that I don't know how to accomplish. I will upload a video explaining what I am trying to accomplish.

[Mike Wilson]

Re: Record selector in Embedded browse

it would also be helpful to attach a copy of your application so we can see what the steps you are taking and what the forms and tables involved are.

[joshw]

Re: Record selector in Embedded browse

If you have several records selected in the browse, is it possible for CURRENT_HIGHLIGHTED_RECORDS() to return the value of a specific field on the first record selected?

[MoGrace]

Re: Record selector in Embedded browse

It might be easier to add a logical field to your table to display in your browse as a checkbox. Then when you have your highlighted records selected use the right click menu to play a script that will toggle or untoggle the checkbox and also show only checked or all records in the browse. Then you can append only the selected records, and clear the boxes when you are finished. This is another one of those things Alpha does in their dock panels/ dialogs but doesn't share with us!