new:manik
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
new:manik [2014/07/02 06:48] manik |
new:manik [2014/07/03 04:16] (current) manik |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| |activity | |Activity |activity shortname=xorg;;opp=xcuspo;;source="Engineering Customer Order";;type="Auto";;team=xteam;;note="Order No: "+xordernum+" updated."| | |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]| | |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 | | + | |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 | | |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 <del>xlocals</del> is table name] | | |buffer | |buffer to access and update cache, to reduce database file I/O. |buffer xlocals [where <del>xlocals</del> is table name] | | ||
| Line 15: | Line 15: | ||
| |convert | |convert from,to | | | |convert | |convert from,to | | | ||
| |command | |command expression | | | |command | |command expression | | | ||
| - | |commit | | | | | + | |commit | |A commit is the final step in the successful completion of a previously started transaction by begin |begin if err == 1 .or. #result .eq. "false" rollback else **commit** end if | |
| |copydir | |copydir source, target | | | |copydir | |copydir source, target | | | ||
| |copyfi | |copyfile source, target | | | |copyfi | |copyfile source, target | | | ||
| |copy | |copy filename(field=newvalue;field=newvalue;.. | | | |copy | |copy filename(field=newvalue;field=newvalue;.. | | | ||
| - | |compute | |compute a=expression | | | + | |compute | |A mathematical determination of the amount or number of something.|compute disc = 0.00+(xdiscf/totqty)*xqtyord | |
| |decimal | |Data Type |decimal x ["x" is a variable]| | |decimal | |Data Type |decimal x ["x" is a variable]| | ||
| - | |delete | |Delete Entry |Delete| | + | |delete | |Delete Entry |Delete fatrn[where <del>fatrn</del> is a table name]| |
| |dconsole | |Debug console | | | |dconsole | |Debug console | | | ||
| |dprint | |Debug print | | | |dprint | |Debug print | | | ||
| |double | |Data Type | double x ["x" is a variable]| | |double | |Data Type | double x ["x" is a variable]| | ||
| - | |error | | | | | + | |error | |It is about problems that occur during the execution of our program. | error " GL Interface for "+xtrnfa+" Catagory: "+astcategory+" Not Found -- Aborting " | |
| |float | |Data Type |float x ["x" is a variable]| | |float | |Data Type |float x ["x" is a variable]| | ||
| |format | | | | | |format | | | | | ||
| Line 32: | Line 32: | ||
| |history | | |history type="Bug";;object=xbug;;action="Assign";;status="1-New";;new="2-Assigned";;message=btbugs.xnote | | |history | | |history type="Bug";;object=xbug;;action="Assign";;status="1-New";;new="2-Assigned";;message=btbugs.xnote | | ||
| |int | |Data Type |int x ["x" is a variable]| | |int | |Data Type |int x ["x" is a variable]| | ||
| - | |insert | | | | | + | |insert | |insert data to database |insert fatrn [where <del>fatrn</del> is a table name]| |
| |init | | | | | |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 | | |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 | | ||
| Line 42: | Line 42: | ||
| |push | | | | | |push | | | | | ||
| |pop | | | | | |pop | | | | | ||
| - | |print | | | | | + | |print | |Display output, top of the page | print x [where <del>x</del> is a variable.] | |
| |run | | | | | |run | | | | | ||
| |schedule | |scheduler stop/start | | | |schedule | |scheduler stop/start | | | ||
| Line 48: | Line 48: | ||
| |sftp | |SFTP | | | |sftp | |SFTP | | | ||
| |sms | | | | | |sms | | | | | ||
| - | |string | | | | | + | |string | |Data Type |string x ["x" is a variable] | |
| |test | | | | | |test | | | | | ||
| - | |update | | | | | + | |update | |update data |update fatrn [where <del>fatrn</del> is a table name]| |
| |vclear | | | | | |vclear | | | | | ||
| |vtest | | | | | |vtest | | | | | ||
| |vmsg | | | | | |vmsg | | | | | ||
| - | |comp | | | | | + | |comp | |A mathematical determination of the amount or number of something.|comp disc = 0.00+(xdiscf/totqty)*xqtyord| |
/srv/www/htdocs/wiki/data/attic/new/manik.1404283681.txt.gz · Last modified: 2014/07/02 06:48 by manik
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
