| Line 62: | Line 62: | ||
* Set Display format for '''Float''', '''Currency''' & '''Integer''' Data Type | * Set Display format for '''Float''', '''Currency''' & '''Integer''' Data Type | ||
|- | |- | ||
| Load || Reload again the Script from the Database | | Load || | ||
* Reload again the Script from the Database (Only for DIY Script) | |||
|- | |- | ||
| Load From File || Load Script from the Text File | | Load From File || | ||
* Load Script/Fields from the Text File. | |||
* Be careful as system will delete the existing field before load the file to the system | |||
|- | |- | ||
| Save || Save Current Script | | Save || | ||
* Save Current Script/Field | |||
* Don't do Delete, Rename & Insert in same time (Only for DIY Fields) | |||
|- | |- | ||
| Save To File || Save Current Script to Text File | | Save To File || | ||
* Save Current Script/Fields to Text File | |||
|} | |} | ||
===Header Fields=== | ===Header Fields=== | ||
===Item Fields=== | ===Item Fields=== | ||
Revision as of 07:25, 9 September 2015
Menu: Tools | DIY | SQL Control Center...
Introduction
This Additional Module where user can self
- Create new field (DIY Fields Module)
- Modified the SQL Accounting (DIY Script Module)
DIY Fields
- Available field type
- - Boolean
- - Currency
- - Date
- - Float
- - Integer
- - Memo
- - Picture
- - String
- For Explaination for Each Data Type may refer to http://www.w3schools.com/sql/sql_datatypes_general.asp
- ----------------------------------------------------------------------------------------------------------------------------------------------------
Avoid use Picture data as it will cause your database size increase very fast.
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- User can create DIY Fields either at Header Fields or Item Fields
- In each Field had the below interface
Name Description Name - Field name
- Only Alphanumeric & no spacing
Data Type - Type of Field
Size - The Field Size
- Only applicable for Float, Integer & String Data Type
Sub Size - The Field Sub Size normally is the Decimal Point
- Only applicable for Float Data Type
Caption - Field name to be shown at user interface.
Required - To tell the system the current field MUST not empty
Default Value - Default Value to insert on New record
Display Format - Set Display format for Float, Currency & Integer Data Type
Load - Reload again the Script from the Database (Only for DIY Script)
Load From File - Load Script/Fields from the Text File.
- Be careful as system will delete the existing field before load the file to the system
Save - Save Current Script/Field
- Don't do Delete, Rename & Insert in same time (Only for DIY Fields)
Save To File - Save Current Script/Fields to Text File