Maintain DIY

Menu: Tools | DIY | Maintain DIY...

Introduction

This Additional Module(DIY Fields Module) where user can

Function	Description
Field and Quick Form	User can Self Create new User Define Field(s) & Design the Layout
Script	Customise the Application
Calculation	Override the build in Calculation (SQL Payroll ONLY)
View Template	For Advance Form Mode
Report Data	Deprecated

Field and Quick Form

• Available Data Field Type

Field Type	Definition
String	Text data of a fixed length (up to 8192 bytes)
Unicode String	A field representing a Unicode (16 bits per character) string.
Boolean	A Boolean value.
Integer	Whole numbers in the range of long integers (32 bits).
Currency	Currency values with the same range as the Real data type.
Bcd	Real numbers with a fixed number of digits after the decimal point.
Date	A date value.
Blob	Binary data with no size limit (BLOB stands for binary large object). The theoretical maximum limit is 2 GB.
Memo	Text of arbitrary length.

----------------------------------------------------------------------------------------------------------------------------------------------------

Only String data can increase the field size so plan properly before add the field. User can't change from 1 data type to another once it save.

----------------------------------------------------------------------------------------------------------------------------------------------------

• More Coming Soon...

See also

• SQL Control Center
• Others Customisation