en-USnl-NL
You are here:   Forum
  |  Login
You have to register on this website to be able to post in this forum.
Registration is completely free, so this does by no means oblige you to pay any licence fee.
The licence fee is only for the use of the ApplicationBuilder DNN and will expire after the timeframe date is past.
For information about the licences see: TimeFrame Licences

Feel free to comment on any topic; we need your input!

 
JumpStart ForumJumpStart ForumJumpStartJumpStartFunctions in ve...Functions in ve...Functions in Version 1.03.03 DatabaseBuilderFunctions in Version 1.03.03 DatabaseBuilder
Disabled 
Previous
 
Next
 Disabled
New Post
 10/13/2011 12:21 PM
 
## Fieldtype SQL type ExtentionCode Remarks per extention and the use of them
1 Selection<TableName> varchar(50) _DDL _DDL is the extention that creates a dropdownlist from the data from the the tablefield it points to.
2 SQL SelectionField varchar(50) _SQLSEL _SELSQL is the extention on the fields on the table where the _DDL points to. There can be more than one _SQLSEL extentions. However: these fields need counterpartfields in the table that uses it. These fields must have the same name as the _SQLSEL fieldnames, and they must be in the same order.
3 <General integer> all SQL integer Fields _INX _INX is the extention that lets the content of this integerfield to be transferred to the field that the _LNK extention points to.
4 <General decimal> all SQL decimal numbers Fields _DEX _DEX is the extention that lets the content of this decimalfield to be transferred to the field that the _LNK extention points to.
5 KeyField all SQL types _KEY _KEY is he extention that create an unique tablefield. For example a searchfield or a personal social security number.
6 SearchField-Result varchar(110) _ZKN _ZKN extention for the creation of a searchfield. It combines the fields wit the _SB extention to a non-editable unique field.
7 SearchField-Argument varchar(50) _SB _SB extention for the fields that have to be put together to form a _ZKN search field. The order of the fieldcombination is top-down.
8 IdentificationFields integer _INX _INX is the extention that sets the content of this integerfield to be transferred to the field that the _LNK extention points to.
9 DateFunctionFielden integer _DTF _DTF is the extention for a datefield that will be updated by adding the number of days that are in the combined _DTX /_INT extentions of that date in this table. One _DTF allowed!
10 DateField varchar(10) _DTE _DTE is the extention of a  datefield. The field itself has the datatype of CHAR(10).
11 DateField varchar(10) _DTX _DTX is the extention that transfers this datefield to the corresponding datefield in another table.
12 AmountField money _DEC _DEC extention will set money fields as type Decimal in the database.
13 AmountField money _DEX _DEC extention will set money fields as type Decimal in the database and will be copied to an other database table with the same fieldname.
14 DescriptionField varchar(500) _OMS _OMS extention will set a VarChar type to size 500 and creates a multiline variabele type in the HTML code.
15 PortalsystemField varchar(50) _DNN _DNN extention will generate a dropdownlist from the DNN portal userlist.
16 PortalUsersField varchar(50) _USR _USR extention will generate a dropdownlist from the DNN portal userlist.
17 StandardUnits varchar(10) _ISO _ISO extention will create a dropdownlist with standard ISO units.
18 StandardUnits varchar(10) _ISX _ISX extention will create a dropdownlist with standard ISO units that will be transferred to another database table with the same fieldname.
19 StatusField varchar(15) _STS _STS extention will create a status field selection.
20 Websites varchar(200) _URL _URL extention will create a link to another website.
21 E-mailField varchar(50) _MAIL _MAIL extention will force an active email field.
22 Select as Mail parameter All Varchar field types _MPM _MPM Extention is used for SQL fields that have to be substituted in the mail subject and mail body fields. Goes together with the _MAIL extention.
23 IndexedField all SQL types _IDX De index verwijst naar het labelbestand in de Fieldnaam.
24 ChoiseField RadioBotton varchar(50) _SQLRBT _SQLRBT will invoke a radiobutton in the GUI.
25 ChoiseField CheckBox varchar(50) _SQLCHK Hierdoor wordt een selectiemenu in een CheckBox geactiveerd.
26 linkField CREATE varchar(50) _CRT _CRT extention links another SQL tablefield from this field and create a new record in the other table.
27 linkField CONNECT varchar(50) _CNT _CNT extention links another SQL tablefield from this field in another existing tablerecord.
28 linkField RECEIVE varchar(50) _CNR Hierdoor wordt een andere tabelwaarde op dit Field gelinkd.
29 linkField FROM varchar(50) _CNF Hierdoor wordt een andere tabelwaarde van dit Field gelinkd. Uitsluitend voor 0_ID indexFielden gebruiken!
30 Templatetable INDIRECT varchar(50) _CNFX Selecteerd een Templatetabel op indirecte wijze; FieldnaamContent = TemplateNaam.
31 Templatetable DIRECT varchar(50) _CLRX Selecteerd een Templatetabel op directe wijze; Fieldnaam = TemplateNaam.
32 Templatetable DIRECT varchar(50) _CID _CID selects the IndexField that belongs to the Templatetabel. Always come together with _CLR.
33 Show Popup General Edit all SQL types _PPFDT _PPFDT is the extention that comes in the tablefield that POINT TO the table from wich the popupdata will be gathered. _PPFDT is always in combination with the_DDL and the _LNK extention. DT stands for General Edit.
34 Tabel linkFieldKey varchar(50) _PPFVW _PPFVW is the popup extention on the field in the table where the data comes from. This field will be shown in the popup on the requesting tablefield. It combines with the _INQ extention. The user can view the content of this secundary table record.
34 Tabel linkField varchar(50) _LNK _LNK is the extention that creates a link to another table. Applying the _LNK extention willl force an extra line in this table wich holds the recordID rom the record in the table it points to.
35 Tabel linkFieldKey varchar(50) _PPP _PPP is the popup extention on the field in the table where the data comes from. This field will be shown in the popup on the requesting tablefield. It combines with the _INQ extention. The user can edit the content of this secundary table record.
36 Tabel ContentField varchar(50) _INQ _INQ is the extention that are fitted on the fields wich will be displayed in the popup on the requesting tablefield.
37 Show PopUp Exclusive Edit all SQL types _INQXD _INQXD is the extention that comes in the tablefield that POINT TO the table from wich the popupdata will be gathered. XD stands for Exclusive Edit.
38 SQL WHERE Field varchar(50) _SQLWHR _SQLWHR is teh extention to use when a specific selectioncriterium for specific records are needed.
39 SQL Sort Field varchar(50) _SQLSRT Dit Field geeft het sorteercriterium aan; ASC of DESC.
40 ChioseField  Man/Vrouw varchar(6) _SEX Hierdoor wordt een M/V checkbox of radiobutton geactiveerd.
41 DossierField all SQL types _DSR _DSR is the extention that creaes a dossiertable that goes with this table. For example a dossier on a client or organisation.
42 TextFields integer _STX _STX is the extention that transfers the content of this stringfield to the corresponding stringfield in the table that the _LNK extention points to.
43 ChoiseField  Titel varchar(6) _TTL Hierdoor wordt een titel checkbox of radiobutton geactiveerd.
44 Tabel First start all SQL types _TBLFSRT Hierdoor wordt een Tabel op een blok Fielden gestart.
45 Tabel start all SQL types _TBLSRT Hierdoor wordt een Tabel op een blok Fielden gestart.
46 ChoiseField YesNo tabel varchar(6) _TBLOnOff Hierdoor wordt een Tabel op een blok Fieldenaan aan of uit gezet.
47 Tabel stop all SQL types _TBLSTP Hierdoor wordt een Tabel op een blok Fielden gestopt.
48 Tabel last stop all SQL types _TBLLSTP Hierdoor wordt een Tabel op een blok Fielden gestopt.
49 ChoiseField YesNo varchar(6) _YesNo Hierdoor wordt een J/N checkbox of radiobutton geactiveerd.
50 CalculationField Integer en Decimal _CLC Dit Field wordt door een (externe/functie) calculatie gevuld.
51 EditField all SQL Field types _NMS Dit Field wordt NIET in het Mutatiescherm getoond.
52 GridField all SQL Field types _GRD Dit Field wordt WEL in het ViewGrid getoond.
53 TarifType Field varchar(50) _TSF Tariefsoort Fielden worden in berekeningen gebruikt.
54 TarifType Field varchar(50) _TSX Tariefsoort Fielden die naar andere tabellen worden gecopieerd.
55 TarifField Decimal _TRF TariefFielden worden in berekeningen gebruikt.
56 TarifField Decimal _TRX Berekdende tariefFielden die naar andere tabellen worden gecopieerd.
57 VAT Field percentage Decimal _BPW BTW percentage Fielden worden in berekeningen gebruikt.
58 VAT Field percentage Decimal _BPX BTW percentage Fielden die naar andere tabellen worden gecopieerd.
59 VAT Field amount Decimal _BTW BTWFielden worden in berekeningen gebruikt.
59 VAT Field amount Decimal _BTX BTWFielden die naar andere tabellen worden gecopieerd.
60 ValutaField Decimal _CRC ValutaField voor deze prijzen.
61 Specific listselection Integer _SPF _SPF is the extention for specific userview on their own records. It applies only to integer SQL fields and registered users.
62 Grid- en EditField all SQL Field types _TMPL _TMPL geeft een dat deze tabel een template met defaultwaarden is
63 EditField all SQL Field types _NDT _NDT extention prohibits any user from editing this field.
64 PayPalPaymentField Money _PPLPY _PPLPY extention marks a PayPal paymany amount. It triggers all code for the PayPal functions and the PayPal checkout.
65 ProductnameField Varchar(50) _PPLPRD Deze extentie geeft een PayPal productnaam aan; het gekochte product.
66 ProductPiceField Money _PPLPRP Deze extentie geeft een PayPal productprijs aan; de waarde van het product.
67 PayPal ValutaField Varchar(6) _PPLCRR Deze extentie geeft een PayPal valuta aan; de valuta waarin betaald moet worden.
68 PayPal VAT Field Decimal _PPLTX Deze extentie geeft een PayPal BTW aan, het percentage BTW te betalen in _PPCRR valuta.
69 PayPal ChoiseField YesNo Varchar(6) _PPLTYN Deze extentie geeft een PayPal BTW aan, Iniclusief of exclusief BTW.
70 PayPal Update fields All SQL field types _PPPDT _PPPDT: This PayPal field will be updated when a transaction is succesfully closed. Decimals and Integers will be set to 0 if unsuccesful; Strings will be set to [empty] and booleans will be "False".
71 PayPal Payment OK Varchar(6) _PPLPOK _PPLPOK: This PayPal field will be updated when a transaction is succesfully closed. The paymentconfirmationfield will be set to Yes.
72 PayPal Payment Licence OK Varchar(6) _PPLLOK _PPLLOK: This PayPal field will be updated when a transaction is succesfully closed. The licence date will be set.
73 Select Anonymus user All Varchar field types _SPN _SPN extention is used for the selection of a record of a NON-Portal user; a GUEST that signed in for some kind of event or purchase.
74 Labeltext varchar(100) _LBL _LBL extention will set "fixed text" in the screen.
75 Reverse datagrid record view all SQL Field types _RSR _RSR is the RevertShowRecord extention. This record will NOT be shown in a datagrid when "True". This and can be reverted in the setup.
76 Licencefields Integer and Decimal field types _LCN _LCN fields are fields that are designed to hold licence information. It is a NUMERIC field and if it holds 0 (ZERO) than it will be ignored in the datagrid table. (i.e. will NOT show). _LCN has to be set on the Primary table as well!. Usually this is the "Licence" field in this table. It triggers the ApplicationGenerator to create the SQL accordingly.
77 --- all SQL Field types _XXX This field will NOT be compiled!
78 --- all SQL Field types _XXX This field will NOT be compiled!
79 --- all SQL Field types _XXX This field will NOT be compiled!
80 --- all SQL Field types _XXX This field will NOT be compiled!
81 --- all SQL Field types _XXX This field will NOT be compiled!
82 --- all SQL Field types _XXX This field will NOT be compiled!
83 --- all SQL Field types _XXX This field will NOT be compiled!
84 --- all SQL Field types _XXX This field will NOT be compiled!
85 --- all SQL Field types _XXX This field will NOT be compiled!
86 --- all SQL Field types _XXX This field will NOT be compiled!
87 --- all SQL Field types _XXX This field will NOT be compiled!
88 --- all SQL Field types _XXX This field will NOT be compiled!
89 --- all SQL Field types _XXX This field will NOT be compiled!
90 OperandField all SQL Field types _ΩP _ΩP extention to mark an Operand field.
91 CalculationField Result Integer Integer _ξSFαIntβMultΩp1xxΩp2yy _ξSF(ServerFunction)αDec(Result SQL-Type)βMult(Multiply)Ωp1xx(1stOperand)Ωp2yy(2ndOperand). Example: Public Function SFαMult(ByVal Op1 As Decimal, ByVal Op2 As Decimal) As Integer
92 CalculationField Result Decimal Decimal _ξSFαDecβMultiΩp1xxΩp2yy _ξSF(ServerFunction)αDec(Result SQL-Type)βMult(Multiply)Ωp1xx(1stOperand)Ωp2yy(2ndOperand). Example: Public Function SFαMult(ByVal Op1 As Decimal, ByVal Op2 As Decimal) As Decimal
93 --- all SQL Field types _XXX This field will NOT be compiled!
94 --- all SQL Field types _XXX This field will NOT be compiled!
95 --- all SQL Field types _XXX This field will NOT be compiled!
96 --- all SQL Field types _XXX This field will NOT be compiled!
97 --- all SQL Field types _XXX This field will NOT be compiled!
98 --- all SQL Field types _XXX This field will NOT be compiled!
99 --- all SQL Field types _XXX This field will NOT be compiled!
100 --- all SQL Field types _XXX This field will NOT be compiled!
101 --- all SQL Field types _XXX This field will NOT be compiled!
102 --- all SQL Field types _XXX This field will NOT be compiled!
Type Math Uppercase Character Lowercase Character Remark on the use
Int Mult (Multiply; Op1 * Op2) Ξ ξ Start parameter: Xi Always in front of the Function.
Dec Div (Divide; Op1 / Op2) Α α 1st parameter: Alpha. Always in front of the FieldType
Bool Add (Add; Op1 + Op2) Β β 2nd parameter: Beta. Always in front of the Math
Date Subt (Subtract; Op1 - Op2) Γ γ  
  Sum (Op1 + Op2 + Op3 + Op4….) Δ δ  
  Perc (Percentage; Op1) Ε ε  
    Ζ ζ  
    Ω ω Calculation parameter: Omega. Always in front of the calculation operand(#). xx or yy substute for SQL-FieldNumber.
         
         
         
Disabled 
Previous
 
Next
 Disabled
JumpStart ForumJumpStart ForumJumpStartJumpStartFunctions in ve...Functions in ve...Functions in Version 1.03.03 DatabaseBuilderFunctions in Version 1.03.03 DatabaseBuilder