Command List

Command	Param	Description	Example
activity	Activity	activity shortname=xorg;;opp=xcuspo;;source=“Engineering Customer Order”;;type=“Auto”;;team=xteam;;note=“Order No: ”+xordernum+“ updated.”
array	array get(index,fields)	An array is a container object that holds set of Data	array get(i,clist) [i=index,clist=list of fields]
begin	BEGIN TRANSACTION represents a point at which the data referenced by a connection is logically and physically consistent.	begin if err == 1 .or. #result .eq. “false” rollback else commit end if
break	if we need to exit from a loop/command action in the point of Error then we use break.	Exm~01: buffer ppmps=#form set ppmps.xrevised=“” insert ppmps if #result .eq. “false” print “Cannot Insert new MPS – Cannot Revise” break end if Exm~02: str sql=“select xsup as sup from caitemsup i, pordt r where i.zid=r.zid and i.xitem=r.xitem and r.zid=”+#id+“ and r.xporeqnum='”+xporeqnum+“' group by xsup” int is=#sqlfill(sql) int i=0 int showrfq=0 while i < is array get(i,“sup”) int itemp=#sql(int,“select count(*) from porfq where xporeqnum='”+xporeqnum+“' and xsup='”+sup+“'”) if itemp == 0 set showrfq=1 break end if set i=i+1 end while
buffer	buffer to access and update cache, to reduce database file I/O.	buffer xlocals [where xlocals is table name]
call	Call Method	call xy [where xy is a Method name]
Clear	Clear existing data from form	Clear
captcha	CAPTCHA is the type of response test used to determine whether or not the user is human
console	console expression	console “Voucher ”+glexchap.xalcnum+“:”+glexchap.xalcrow+“:”+line+“:amount=”+amount
convert	convert from,to
command	command expression
commit
copydir	copydir source, target
copyfi	copyfile source, target
cop	copy filename(field=newvalue;field=newvalue;..
compute	compute a=expression
decimal	Data Type	decimal x
delete
dconsole	Debug console
dprint	Debug print
double	Data Type	double x
error
float	Data Type	float x
format
getmail
hashtable
history	history type=“Bug”;;object=xbug;;action=“Assign”;;status=“1-New”;;new=“2-Assigned”;;message=btbugs.xnote
int	Data Type	int x
insert
init
mail	mail from=#user;;to=xmember+“,”+xholder;;sub=“Bug ”+xbug+“ Assigned for Resolution”;;message=“The Bug No: ”+xbug+“ has been assigned to you for resolution.”+#char(10)+btbugs.xlong
makedir
mkdir
mandatory
matrixsave
move
push
pop
print
run
schedule	scheduler stop/start
set
sftp	SFTP
sms
string
test
update
vclear
vtest
vmsg
comp