Mapping "CTRL-D" to A Button

[ryland]

Hello,

I just discovered that a "CTL-Delete" with rows highlighted on an embedded browse will select multiple items. Instead of doing a control delete, can I map a button to perform the same function? Ryland

[Stan Mathews]

Re: Mapping "CTRL-D" to A Button

You chave a choice between SYS_SEND_KEYS() and the Action Scripting element "Send Keys".

[ryland]

Re: Mapping "CTRL-D" to A Button

Thanks Stan,

I looked that function over and it appears to map to other key functions with the send keys. Ordinarily that would be fine. What I would like to do is to have a "delete button" instead of a "CTL Delete" to delete rows of selected info in an embedded browse. My users are pretty simple, so I'm trying to keep user the application options on the screen. Ryland

[csda1]

Re: Mapping "CTRL-D" to A Button

Hi Stan,

You chave a choice between SYS_SEND_KEYS() and the Action Scripting element "Send Keys".

Sorry, but I have to disagree here with you. SYS_SEND_KEYS() sends keys into the keyboard buffer, and should always be the last resort, as it depends upon context of the current Windows (and that could be outside of A5's window too) to what it feeds keys to.

But the question is can a button do the delete? I'm not positive about the multiple select, but should be doable.

If a person want's to trap a hot key, use an ON_KEY (or ONKEY - depends if a form/browse or a dialog box) event handler to process the keys.

[Stan Mathews]

Re: Mapping "CTRL-D" to A Button

You might want to restate your intent because I'm confused, not unusual.

You want a button to delete a row or rows in an embedded browse but you don't want to use control-D?

[Tom Cone Jr]

Re: Mapping "CTRL-D" to A Button

If you have the record numbers corresponding to the rows the user has selected you could delete them, right? So here's a way to get the record numbers of the selected rows.

'This script tested on copy of Invoice form
'in AlphaSports.  It runs on a button push.
'It returns a crlf delimited list of records
'selected by the user in the Browse object on the form.

'Has not been tested for the case where no rows
'have been selected.

'User row selections are made with down arrow while
'holding down the Shift key.  Haven't found a way to 
'select rows with the mouse or Ctrl key.  

'get pointer to browse1 control on form
dim br_ptr as P
br_ptr = parentform.child("browse1")

'get record numbers of records selected in browse
trace.writeln(trim(br_ptr.selected_records()))

[ryland]

Re: Mapping "CTRL-D" to A Button

Sorry if I confused all. A button the would serve to delete 1 or multiple selected row instead of the "ctrl-delete" is what my client wants to do.

[Tbaker]

Re: Mapping "CTRL-D" to A Button

Building on the code Tom Cone has posted, this code will select the record numbers of the rows to be deleted, then using that list, opens the invoice items table in Alpha Sports and deletes those records that were highlighted.

There is no warning message that you are about to delete records, but that could be put in the code.

You first question about putting CTRL-D in a button will work for single records but will not work for multiple selections - if you do try it on multiple selections, it will only delete the last record highligted.

'This code builds upon what Tom C posted 
'using the invoice form from Alpha Sports
'it creates a list of the record numbers to be deleted
'then opens the table on which the child browse is based and deletes the records
'the same way using CTRL-D.

'Note  - there is no warning message telling you the records are being deleted
'it just deletes them - you could put your own code in for that

'get pointer to browse1 control on form
dim br_ptr as P
br_ptr = parentform.child("browse1")

'get record numbers of records selected in browse

lst=trim(br_ptr.selected_records())

msgbox("",lst)  'this just shows the record numbers from the selected_records() function
                     'it can be eliminated or you can put a warning that records are being deleted here
dim tbl as p

tbl=table.get("invoice_items") ' open the invoice items table in alpha sports on which the browse is based

'This code goes through the list and then delete each record from the invoice items table
for each foo in lst
	tbl.fetch_goto(val(foo)) 
	tbl.change_begin()
	tbl.delete()
	tbl.change_end()
next

Tom Baker


To: Tom Cone

Thanks for posting that small snipet of code - never thought of doing it that way.

Tom B

[G Gabriel]

Re: Mapping "CTRL-D" to A Button

I must be missing something here!
You could use Ctrl-D to delete multiple records.
And..
You can use Right-Click to do the same thing.
So, why are we re-inventing the wheel?

Incidentally, to highlight multiple records in a browse:
Drag the mouse down row selector.


Video legend:
Red circle: left-clk
Blue circle: Right-clk

[Tom Cone Jr]

Re: Mapping "CTRL-D" to A Button

Incidentally, to highlight multiple records in a browse:
Drag the mouse down row selector.

Agreed. Understood. No argument. Have been talking about something else. This will select multiple consecutive rows. Why can't we select every other row? That's the question.

[G Gabriel]

Re: Mapping "CTRL-D" to A Button

Tom:

'User row selections are made with down arrow while
'holding down the Shift key.  Haven't found a way to 
'select rows with the mouse or Ctrl key.

How do you select multiple non-consequetive rows with the down arrow while
holding down the Shift key?

[Mike Wilson]

Re: Mapping "CTRL-D" to A Button

Agreed. Understood. No argument. Have been talking about something else. This will select multiple consecutive rows. Why can't we select every other row? That's the question.

Tom,
sounds like your jumping to/refering to your other post:

https://forum.alphasoftware.com/showthread.php?t=77636

[Tom Cone Jr]

Re: Mapping "CTRL-D" to A Button

Yes, perhaps I'm getting them confused. Thanks for the info on how to use the mouse to select consecutive rows in a browse. The issue that prompted my wishlist submittal in the other forum was different. Sorry for the confusion.