|
|
| (64 intermediate revisions by the same user not shown) |
| Line 3: |
Line 3: |
| ==Introduction== | | ==Introduction== |
| This Additional Module where user can self | | This Additional Module where user can self |
| * Create new field (DIY Fields Module) | | * Create new field ([[DIY Fields]] Module) |
| * Modified the SQL Accounting (DIY Script Module) | | * Modified the SQL Accounting ([[DIY Script]] Module) |
|
| |
|
| ==DIY Fields== | | ==See also== |
| * Available Data Field Type | | * [[Maintain DIY]] |
| :: - Boolean
| | * Others [[Customisation]] |
| :: - Currency
| |
| :: - Date
| |
| :: - Float
| |
| :: - Integer
| |
| :: - Memo
| |
| :: - Picture
| |
| :: - String
| |
| | |
| * For Explanation for Each Data Type may refer to http://www.w3schools.com/sql/sql_datatypes_general.asp
| |
| | |
| :::----------------------------------------------------------------------------------------------------------------------------------------------------
| |
| ::::{|
| |
| |-
| |
| | [[File:Template.Warning-01.jpg|80px]]||
| |
| 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 Table had the below interface
| |
| ::[[File:DIYField-01.jpg|700px]]
| |
| | |
| ::{| class="wikitable"
| |
| |-
| |
| ! 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
| |
| |-
| |
| |'''+''' Button ||
| |
| * Add New Field
| |
| |-
| |
| |'''-''' Button ||
| |
| * Delete Selected Field
| |
| |}
| |
| ===Header Fields===
| |
| Below is the example for Sales Invoice
| |
| ====Add New Fields====
| |
| ::[[File:DIYField-02.jpg|700px]]
| |
| # At the left panel look for '''Sales Invoice | Header Fields'''<br />
| |
| # Click the '''+''' Button on top to add New fields as above picture<br />
| |
| # Click Save button<br />
| |
| | |
| ====Design Layout====
| |
| They are 2 ways to creating the Layout for new fields added.<br />
| |
| # Right Click the '''Sales Invoice'''
| |
| ::[[File:DIYField-03.jpg]]
| |
| =====Advance Form Design=====
| |
| This mode is only for the user who known how to use the Delphi.<br />
| |
| ======Pros======
| |
| * Freely adjust & place the component.
| |
| ======Cons======
| |
| * Not Easy to design
| |
| * Not support Date Data Type<br /><br />
| |
| | |
| :2. Select '''New Advance Form Design'''
| |
| ::[[File:DIYField-04.jpg]]
| |
| :3. Enter the name (eg Freight Info) this will shown in the Sales Invoice Data Entry
| |
| :4. Click OK
| |
| ::[[File:DIYField-05.jpg|650px]]<br />
| |
| | |
| ::[[File:DIYField-06.jpg]]
| |
| ::* This '''Standard''' component is just for Fixed labeling or decoration
| |
| ::* The detail of each button can be refer to http://www.delphibasics.co.uk/Article.asp?Name=Standard
| |
| | |
| ::[[File:DIYField-07.jpg]]
| |
| ::* This Data Controls component is use for Variable data which can be use at Data Entry
| |
| ::* Below is the detail of each button (From Left)
| |
| | |
| ::{| class="wikitable"
| |
| |-
| |
| ! Component !! Purpose
| |
| |-
| |
| | DBText || Data-aware label that can display a field from a currently active record.
| |
| |-
| |
| | DBEdit || Data-aware edit box that can display or edit a field from a currently active record.
| |
| |-
| |
| | DBMemo || Data-aware memo box that can display or edit text BLOB data from a currently active record.
| |
| |-
| |
| | DBImage || Data-aware image box that can display, cut, or paste bitmapped BLOB images to and from a currently active record.
| |
| |-
| |
| | DBListBox || Data-aware list box that can display values from a column in a table.
| |
| |-
| |
| | DBCheckBox || Data-aware check box that can display or edit a Boolean data field from a currently active record.
| |
| |-
| |
| | DBRichEdit || Data-aware Rich Text Editor that can display or edit text BLOB data from a currently active record.
| |
| |-
| |
| | DBSpinEdit || Data-aware Edit box that can display or edit integer data from a currently active record.
| |
| |}
| |
| | |
| =====Quick Form Design (Recommended)=====
| |
| | |
| ===Item Fields===
| |
