| Line 30: | Line 30: | ||
* In each Field had the below interface | * In each Field had the below interface | ||
::[[File:DIYField-01.jpg|700px]] | ::[[File:DIYField-01.jpg|700px]] | ||
::{| class="wikitable" | |||
|- | |||
! Header text !! Header text | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|- | |||
| Example || Example | |||
|} | |||
===Header Fields=== | ===Header Fields=== | ||
===Item Fields=== | ===Item Fields=== | ||
Revision as of 05:02, 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
Header text Header text Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example Example