[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Running TCL commands programmatically (AREV Specific) ====
=== At 04 JAN 2011 10:35:14AM Charles Steadham wrote: ===
{{tag>"AREV Specific"}}
I've a fairly simple question that I can't seem to resolve by looking at the documentation.
I have a command that will run if entered at the TCL (Speficially, ATTACHTABLE) in ARev 3.1 but am unsure how to run this command from a subroutine. How is this accomplished?
----
=== At 04 JAN 2011 11:01AM Warren Auyong wrote: ===
Use the RBasic EXECUTE or PERFORM statements. The difference between them is PERFORM is recursive and will return an active cursor or select list.
Syntax:
PERFORM/EXECUTE tcl/rlist statement in quotes or a variable
e.g.
PERFORM "SELECT VOC WITH TYPE EQ 'S'"
or
stmt=SELECT VOC WITH TYPE EQ "S"'
PERFORM stmt
Be mindful of the proper nesting of single and double quotes.
----
=== At 04 JAN 2011 05:21PM Eric wrote: ===
If I recall there was an attachtable_sub() routine. Will explore further.
----
=== At 04 JAN 2011 07:32PM Warren Auyong wrote: ===
Correct, but only in v3.1x and maybe v3.0x.
Parameters are Volume Name, Table List (@FM delimited), Options
----
=== At 05 JAN 2011 03:30PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote: ===
You can download the knowledgebase which documents all of these routines [url=http://www.revelation.com/knowledge.nsf/461ff2bd5a8ddeed852566f50065057d/cbc7524470f2204f8525666600775041?OpenDocument]here[/url].
[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]
[url=http://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]
[i]World leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 05 JAN 2011 05:16PM Eric wrote: ===
It doesn't document the popular completely_paralytic_under_the_table()
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=9B3AD68BDAC9FF838525780E00559FBD|View this thread on the forum...]]