This is an old revision of the document!
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 |
|
call | Call Method | call xy [where |
|
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 | The term console usually refers to a log file[c:\tomcat\logs\ localhost……log] to monitor the status of the system. | 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 | ||
copy | copy filename(field=newvalue;field=newvalue;.. | ||
compute | compute a=expression | ||
decimal | Data Type | decimal x | |
delete | Delete Entry | 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 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 | |||
run | |||
schedule | scheduler stop/start | ||
set | |||
sftp | SFTP | ||
sms | |||
string | |||
test | |||
update | |||
vclear | |||
vtest | |||
vmsg | |||
comp |