AppsFramework
Definition Tab
In this section, we have define definition of forms in XML format.
Step-1 -> We can define definition of forms in XML format and used below tags.
Step-2 ->We can define combos using below xml codes.
2.1. Combos -> We can use tags for combos < combos > as starting tag < /combos > as ending tag.
2.2 Table -> We can use tags for table
2.3 Key -> We set key name for lookup sql between tags < key > and < /key >.
2.4 Sql -> We can put sql query between tags < sql > and < /sql >
Step-3 : We can map combo’s key with lookup key in this section :
3.1 Lookups -> -> We can map combo’s key with mainSql’s columns and childrensql’s columns under formatxml (between < formatxml > and < /formatxml >) or prepeditxml (between < prepeditxml > and < /prepeditxml >) section like this.
3.2 Key Field -> we can use tags for define key field using key word < KEY > as starting tag < /KEY > as ending tag.
3.3 Caption -> we can set caption for key field as per require using key word CAPTION.
E.g-> CAPTION="Customer"
3.4 Lookupkey -> we can set lookupkey as per define in columns between < KEY > and < /KEY > it should be unique and correct.
Define Lookupkey:
UseLookupKey:
Step-4 -> We can define vlists using below tags like this.
4.1 We can map vlist’s key with mainSql’s columns and childrensql’s columns under formatxml (between < formatxml > and < /formatxml >) or prepeditxml (between < prepeditxml > and < /prepeditxml >) section like this.
Step-5 -> We can define mainsql like this.
5.1 mainsql -> We can use tags for define mainsql < mainsql > as starting tag < /mainsql > as ending tag and put required sql query for my row between < mainsql > & < mainsql >.
5.2 IDField ->we can put idfied between tags < IDField > and < /IDField >.
5.3 ReqFields ->using this tag we can mention mandatory columns.
5.4 DescripTemplate -> using this tag we can columns for description.
5.5 formatxml -> using this tag we formatting of visible columns and set caption for columns as per requirement.
Step-6 -> We can define childrensql like this.
6.1 Children -> we can use tags for define children < children > as starting tag , as ending tag.
6.2 Child->under this tag we can define Children items properties < child> is starting tag is ending tag.
6.3 Key ->Using this tag we set key for children’s sql and < key> is starting tag is ending tag.
6.4 Sql -> we can use this tags for set sql query and used < sql > as starting tag < /sql > as ending tag and put required sql query between < sql > & < sql >.
6.5 ReqFields ->We can used this tag for mention mandatory columns same as main sql.
6.6 reversedirection ->using this tag we can set visibility of columns from left to right OR right to left.
6.7 formatxml -> using this tag we formatting of visible columns and set caption for columns as per requirement same as main sql.
6.8 prepeditxml ->using this tag we can set idfield for children’s sql query.
