May 11, 2001
=======================================================================
>From the Edge: Using CLIPBOARD Command in R:BASE 2000 for Windows
Section: New SET Commands
Chapter: Running R:BASE Your Way!
Platform: R:BASE 2000 (ver 6.5++) for Windows
Build: 1.840JxRT03 and Higher ...
=======================================================================
Among NEW COMMANDS and ENHANCEMENTS in R:BASE 2000 (ver 6.5++) for
Windows, now you can collect data from any form or select statement
in a command file to windows clipboard and then paste to your favorite
word processor by using the new SET CLIPBOARD command.
Syntax:
SET CLIPBOARD <'Text String'>
Example 01:
Assuming you have already created a MS Word Document (TestDoc.DOC)
or WordPerfect Document (TestDoc.WPD).
-- ClipBrd.RMD
CONNect ConComp
SET VAR vAddressBlock TEXT = NULL
SET VAR vCustID INTEGER = 100
SELECT (Company+(CHAR(10))+CustAddress+(CHAR(10)) +
+CustCity+','&CustState&CustZip+(CHAR(10))) +
INTO vAddressBlock INDIC IvAddressBlock +
FROM Customer WHERE CustID = .vCustID
SET CLIPBOARD .vAddressBlock
LAUNCH TestDoc.DOC
or
LAUNCH TestDoc.WPD
Once the MS Word or WordPerfect is launched and the document is
opened, you could either use Edit > Paste or Ctrl+V to paste the
windows clipboard text!
The resulting pasted block of text would look like:
Pc Distribution Inc.
3200 Westminster Way
Boston, MA 02178
Above example could be used in your application command file
or in an EEP.
Stay tuned for more ...
Very Best Regards,
Razzak.
