One caveat to Doug's code: the button would need to NOT be a "speed button", right? Because a speed button doesn't change focus?
Karen -----Original Message----- From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Feb 18, 2015 8:16 am Subject: [RBASE-L] - Re: PROPERTY PASTEFROMCLIPBOARD Great Doug, I thought you might go that way. Razzak’s method is great when the user might be pasting multiple times, building a final result. Your’s will assure that only the last paste populates your control. Dennis McGrath From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: Tuesday, February 17, 2015 6:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PROPERTY PASTEFROMCLIPBOARD OK, got it working. What we're doing is pasting an entire screen of mainframe data and then using certain fields for order entry, so the screen doesn't need to be edited. The most foolproof (and we know where this is gonna go...) is to use set var vPasteText = (CVAL('CLIPBOARDTEXT')) I've put it in a double-click EEP in the target variable memo control. That way I don't have to worry about changing focus; heck I don't even have to paste the text into the variable memo control, but it's good to show it for operator comfort level. It's cool - they copy the entire mainframe screen and double click on the memo control and - poof! It's all processed! Thanks Razzak, Karen and Dennis for your help. Doug On 2/17/2015 4:36 PM, Dennis McGrath wrote: PROPERTY VariableMemo PasteFromClipboard 'TRUE' PROPERTY VariableMemo SET_FOCUS 'TRUE' PROPERTY VariableMemo LASTCHAR 'TRUE' Property Btn_Paste SET_FOCUS 'TRUE' --pull focus away so variable gets updated Pause 1 using .vPasteText – looking good! From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, February 17, 2015 4:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PROPERTY PASTEFROMCLIPBOARD Doug, For PasteTextFromClipBoard.rff form, update the "On Click EEP" for [Paste Text from Windows Clipboard] button as follows: PROPERTY VariableMemo PasteFromClipboard 'TRUE' PROPERTY VariableMemo SET_FOCUS 'TRUE' PROPERTY VariableMemo LASTCHAR 'TRUE' This will also allow users to add further text at the end, if they wish. SHOW VARIABLE vPasteText should return the correct value. That's all there is to it! Have fun! Razzak -----Original Message----- From: Doug Hamilton <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 17 Feb 2015 16:05:06 -0600 Subject: [RBASE-L] - Re: PROPERTY PASTEFROMCLIPBOARD Yeah, that does it. Thanks Karen. But the pasting is done by a separate button that has the PasteFromClipBoard property. So to get it to work, I click the Paste button (which pastes the text into the variable memo control), then click the variable memo control and then tab off it. The variable vPasteText is then updated. After the PASTE property, I'll try programmatically setting focus on the Variable Memo and then off of it. Seems like extra horsing around - I tried RECALC VARIABLES but that didn't work. Is there an equivalent PROPERTY command? Hmm, maybe I'll put the PASTE property in a double-click EEP on the Variable Memo control itself and then programmatically advance to the next field. Doug On 2/17/2015 3:23 PM, Karen Tellef wrote: Doug: have you "moved off" the variable memo field? This has tripped me up before. Until you move off the field you haven't "saved" the value into the variable. You might have to have the eep advance to the next field after the paste? Karen -----Original Message----- From: Doug Hamilton <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Feb 17, 2015 3:15 pm Subject: [RBASE-L] - Re: PROPERTY PASTEFROMCLIPBOARD Thank you Razzak. I'm able to run the PasteTextFromClipBoard external form and text gets pasted into the Variable Memo control (variable = vPasteText) when I click the Paste button. But when I sho var, the variable vPasteText is null. Shouldn't it contain the pasted text? If I do a Ctrl-V and manually paste text into the Variable Memo control, the text gets pasted and the variable vPasteText contains the pasted text. That's what I'm trying to accomplish. Am I misunderstanding the PasteFromClipBoard property? Thanks much for your help. Doug 9.5.5.20214 (32) On 2/16/2015 6:37 PM, A. Razzak Memon wrote: At 06:47 PM 2/16/2015, Doug Hamilton wrote: I give up, how does it work? I've got a Variable Memo control for the variable vPasteText, component ID cidPasteText. On a DoubleClick EEP for the Variable Memo, I have: PROPERTY cidPasteText PASTEFROMCLIPBOARD TRUE As I TRACE, the text gets pasted into the Variable Memo control, but the variable vPasteText remains null. RECALC VARIABLES doesn't work and I've tried TRUE and 'TRUE'. Attributes Word Wrap, How Hint and Tab Stop are the only ones checked. None of the Cut, Copy and Paste Settings are checked to prevent the respective action. Here's a sample that illustrates the use of such property ... http://www.Razzak.com/SampleApplications/files/PasteTextFromClipBoard.zip This is an External Form File and you should be able to run from any R:BASE eXtreme 9.5 session regardless of the connected database. Have fun! Very Best R:egards, Razzak
