SQL Control Center: Difference between revisions

From eStream Software
Line 113: Line 113:
| Edit || Example
| Edit || Example
|-
|-
| Example || Example
| Memo || Example
|-
|-
| Example || Example
| Button || Example
|-
|-
| Example || Example
| Check Box || Example
|-
|-
| Example || Example
| Radio Button || Example
|-
|-
| Example || Example
| List Box || Example
|-
|-
| Example || Example
| Combo Box || Example
|-
|-
| Example || Example
| Group Box || Example
|-
|-
| Example || Example
| Radio Group || Example
|-
|-
| Example || Example
| Panel || Example
|}
|}
::[[File:DIYField-07.jpg]]
::[[File:DIYField-07.jpg]]

Revision as of 08:12, 10 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 Data 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 Table 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
+ Button
  • Add New Field
- Button
  • Delete Selected Field

Header Fields

Below is the example for Sales Invoice

Add New Fields

DIYField-02.jpg
  1. At the left panel look for Sales Invoice | Header Fields
  2. Click the + Button on top to add New fields as above picture
  3. Click Save button

Design Layout

They are 2 ways to creating the Layout for new fields added.

  1. Right Click the Sales Invoice
DIYField-03.jpg
Advance Form Design

This mode is only for the user who known how to use the Delphi.

2. Select New Advance Form Design
DIYField-04.jpg
3. Enter the name (eg Freight Info) this will shown in the Sales Invoice Data Entry
4. Click OK
DIYField-05.jpg
DIYField-06.jpg
  • This component is just for Fixed labeling or decoration
  • Below is the detail of each button (From Left)
Button Name Properties
Label Example
Edit Example
Memo Example
Button Example
Check Box Example
Radio Button Example
List Box Example
Combo Box Example
Group Box Example
Radio Group Example
Panel Example
DIYField-07.jpg
Below is the detail of each button (From Left)
Quick Form Design

Item Fields