SQL Control Center: Difference between revisions

From eStream Software
No edit summary
 
(76 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.
=====Advance Form Design=====
 
=====Quick Form Design=====
 
===Item Fields===

Latest revision as of 10:48, 29 October 2015

Menu: Tools | DIY | SQL Control Center...

Introduction

This Additional Module where user can self

See also