Difference between revisions of "EXECSCRIPT()"

From Lianjapedia
Jump to: navigation, search
(Description)
 
(One intermediate revision by the same user not shown)
Line 9: Line 9:
  
 
==Description==
 
==Description==
The EXECSCRIPT() function runs multiple lines of code.  The lines of code are contained in <expC>, which can be a text constant, a character variable, or a character or memo field.  The EXECSCRIPT() function, unlike EXEC() can handle blocks of code, such as FOR...NEXT or DO WHILE...ENDDO loops.  Individual lines of code must be separated by a CHR(13) carriage return character.
+
The EXECSCRIPT() function runs multiple lines of code.  The lines of code are contained in <expC>, which can be a text constant, a character variable, or a character or memo field.  The EXECSCRIPT() function, unlike EXEC() can handle blocks of code, such as FOR...NEXT or DO WHILE...ENDDO loops.  Individual lines of code must be separated by a CHR(10) line feed character.
  
 
If the first statement in <expC> is a [[PARAMETERS]] statement, a comma-separated list of parameters can be included.
 
If the first statement in <expC> is a [[PARAMETERS]] statement, a comma-separated list of parameters can be included.
Line 21: Line 21:
 
use scripts
 
use scripts
 
append blank
 
append blank
replace script with "for i=1 to 10" + CHR(13) + "?i" + CHR(13) + "endfor" + CHR(13)
+
replace script with "for i=1 to 10" + CHR(10) + "?i" + CHR(10) + "endfor" + CHR(10)
 
execscript(script)
 
execscript(script)
  
 
// Text constant
 
// Text constant
execscript("for i=1 to 10" + CHR(13) + "?i" + CHR(13) + "endfor" + CHR(13))
+
execscript("for i=1 to 10" + CHR(10) + "?i" + CHR(10) + "endfor" + CHR(10))
  
 
// Memory variable
 
// Memory variable
m_script = "for i=1 to 10" + CHR(13) + "?i" + CHR(13) + "endfor" + CHR(13)  
+
m_script = "for i=1 to 10" + CHR(10) + "?i" + CHR(10) + "endfor" + CHR(10)  
 
execscript(m_script)
 
execscript(m_script)
  
 
// Including parameters
 
// Including parameters
execscript("parameters p1,p2"+chr(13)+"messagebox(p1+etos(p2))"+chr(13),"Hello ",2013)
+
execscript("parameters p1,p2"+chr(10)+"messagebox(p1+etos(p2))"+chr(10),"Hello ",2013)
 
</code>
 
</code>
  

Latest revision as of 06:58, 18 January 2023

Purpose

Function to run multiple lines of code

Syntax

EXECSCRIPT(<expC> [, <param1> [, ... <paramN>]])

See Also

COMPILE, EXEC(), EXECJAVASCRIPT(), EXECPHP(), EXECPYTHON()

Description

The EXECSCRIPT() function runs multiple lines of code. The lines of code are contained in <expC>, which can be a text constant, a character variable, or a character or memo field. The EXECSCRIPT() function, unlike EXEC() can handle blocks of code, such as FOR...NEXT or DO WHILE...ENDDO loops. Individual lines of code must be separated by a CHR(10) line feed character.

If the first statement in <expC> is a PARAMETERS statement, a comma-separated list of parameters can be included.

The EXECSCRIPT() function returns a logical true (.T.) unless its contents specifically return false (.F.).

Example

// Character field
create table scripts (script char(200))
use scripts
append blank
replace script with "for i=1 to 10" + CHR(10) + "?i" + CHR(10) + "endfor" + CHR(10)
execscript(script)
 
// Text constant
execscript("for i=1 to 10" + CHR(10) + "?i" + CHR(10) + "endfor" + CHR(10))
 
// Memory variable
m_script = "for i=1 to 10" + CHR(10) + "?i" + CHR(10) + "endfor" + CHR(10) 
execscript(m_script)
 
// Including parameters
execscript("parameters p1,p2"+chr(10)+"messagebox(p1+etos(p2))"+chr(10),"Hello ",2013)