SQL Control Center

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
Load From File	Load Script from the Text File
Save	Save Current Script
Save To File	Save Current Script to Text File