Mike Thank you very much, problem solved, I appreciate your help. Angelo To: [email protected] Subject: [RBASE-L] - Re: Commands with variables From: [email protected] Date: Sat, 24 Oct 2015 22:12:06 -0400
Yes. Declare and set the value of your variable appropriately and then when using it in a command precede it with an ampersand "&" instead of the normal "." i.e. SET VAR vtable TEXT = 'REJECT' SELECT * FROM &vtable You can do the same thing with columns as well. SET VAR vcolumns TEXT = 'DISPDATE,STCD_NO,STCD_DASH' SELECT &vcolumns FROM &vtable Hope that helps. Have a good evening and be sure to have fun with variables. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: <[email protected]> To: [email protected], Date: 10/24/2015 09:39 PM Subject: [RBASE-L] - Commands with variables Sent by: [email protected] Trying to run a command, ex:backup, browse, etc. using the table name as a variable (was prompted), possible? Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
