SQL Control Center: Difference between revisions

From eStream Software
Line 62: Line 62:
* Set Display format for '''Float''', '''Currency''' & '''Integer''' Data Type
* Set Display format for '''Float''', '''Currency''' & '''Integer''' Data Type
|-
|-
| Load || Reload again the Script from the Database
| Load ||
* Reload again the Script from the Database (Only for DIY Script)
|-
|-
| Load From File || Load Script from the Text File
| 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
| Save ||
* Save Current Script/Field
* Don't do Delete, Rename & Insert in same time (Only for DIY Fields)
|-
|-
| Save To File || Save Current Script to Text File
| Save To File ||
* Save Current Script/Fields to Text File
|}
|}
===Header Fields===
===Header Fields===


===Item Fields===
===Item Fields===

Revision as of 07:25, 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
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Warning-01.jpg

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
DIYField-01.jpg
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

Header Fields

Item Fields