new:manik
This is an old revision of the document!
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 |
|
| call | Call Method | call xy [where |
|
| Clear | |||
| captcha | |||
| console | console expression | console “Voucher ”+glexchap.xalcnum+“:”+glexchap.xalcrow+“:”+line+“:amount=”+amount | |
| conv | 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 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 |
/srv/www/htdocs/wiki/data/attic/new/manik.1404275771.txt.gz · Last modified: 2014/07/02 04:36 by manik
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
