SQL Control Center: Difference between revisions

From eStream Software
No edit summary
 
(40 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 if can as it will cause your database size increase very fast.
* 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.
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------
 
* 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
:5. Click the '''Freight Info''' (name create at '''Step 3''' above) on the left panel
::[[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.
|-
| cxDBSpinEdit || Data-aware Edit box that can display or edit integer or Float data from a currently active record.
|}
 
:::----------------------------------------------------------------------------------------------------------------------------------------------------
::::{|
|-
| [[File:Template.Tips-01.jpg|60px]]||
Normally we only use
:'''Standard''' Tab component
::- Label - For Labeling each field
:'''Data Controls''' Tab component
::- DBEdit - For String Data
::- DBRichEdit - For Memo Data
::- cxDBSpinEdit - For Currency, Float or Integer Data
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------
 
:6. Click the '''Standard''' Tab & select Label button place on thee right panel
:7. In the '''Object Inspector''' look for
::* '''Caption''' & set to the Caption you like (eg Container Number)
::* '''Font''' & set the '''Size''' to 12 or any size you prefer
::[[File:DIYField-08.jpg]]
:8. Click the '''Data Controls''' Tab & select DBEdit button place on thee right panel
:9. In the '''Object Inspector''' look for
::* '''DataField''' & set to the UDF field name (normally is UDF_FieldName) (eg UDF_ContainerNo)
::* '''Font''' & set the '''Size''' to 12 or any size you prefer
::[[File:DIYField-09.jpg]]
:10. Continue repeat '''Step 6''' till '''Step 9''' for rest of the UDF field.
:11. Click Save button after done.
 
=====Quick Form Design (Recommended)=====
This mode is for the user who don't known how to use the Delphi.
======Pros======
* Easy to Design
======Cons======
* Unable to freely adjust & place the component.
* Not support Rich Text Editor.<br /><br />
 
:2. Select '''New Quick Form Design'''
::[[File:DIYField-10.jpg]]
:3. Enter the name (eg Freight Info) this will shown in the Sales Invoice Data Entry
:4. Click OK
:5. Click the '''Freight Info''' (name create at '''Step 3''' above) on the left panel
::[[File:DIYField-11.jpg|700px]]<br />
:6. Click Customise button.
:7. Drag the UDF Field from the '''Available Item''' dialog box & drop to Right Panel
:8. Continue repeat '''Step 7''' for rest of the UDF field.
:9. Click Save button after done.
 
===Item Fields===
There is no layout need to be design for Item Field UDF. You can drag out all the UDF field in the '''Field Chooser''' in the data Entry
::[[File:DIYField-12.jpg|650px]]<br />
 
:1. Drag the UDF field from the '''Customization''' Dialog & Drop it the column you wanted to shown (eg In between Description & Qty)
 
==DIY Script==

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