Genero Business Development Language
技術手冊
產品處 TIPTOP 產品部
Genero Business Development Language
技術手冊
作者/ TIPTOP 產品部
發行/ 鼎新電腦股份有限公司 產品處
地址/ 總公司:台北縣新店市中興路一段 222 號
產品處:台中市西區民權路 239 號 16 樓
網址/ http://www.dsc.com.tw
客服/ tiptop@dsc.com.tw
出版/ 2004 年 07 月初版、2005 年 07 月二版
版別/ 二版 (繁體中文 2.00 版)
聲明/ 本書繁體中文版、英文版版權為鼎新電腦股份有限公司所有,
未經本公司授權任意拷貝、引用均屬違法。
書中引用之商標及產品名稱分屬各原產公司所有,本書引用純
屬介紹之用,並無侵害之意。
(版權所有,翻印必究)
DataSystem
Genero BDL 技術手冊目錄
第一章 Genero BDL 架構
Genero BDL 概觀........................................................................................ 1 - 1
Genero BDL 程式組成................................................................................. 1 - 2
編譯(Compile)、連結(Link)執行(Execute)....................................... 1 - 4
第二章 畫面檔(FORM)組成
畫面檔(FORM)的組成............................................................................. 2 - 1
SCHEMA Section........................................................................................ 2 - 4
ACTION DEFAULTS Section ...................................................................... 2 - 5
TOPMENU Section ..................................................................................... 2 - 7
TOOLBAR Section....................................................................................... 2 - 8
LAYOUT Section......................................................................................... 2 - 9
0.畫面檔中的物件 .................................................................................... 2 - 11
1.GRID .................................................................................................... 2 - 12
2.SCROLLGRID ...................................................................................... 2 - 13
3.TABLE .................................................................................................. 2 - 16
4.GROUP ................................................................................................ 2 - 18
5.FOLDER、PAGE.................................................................................. 2 - 19
6.VBOX(HBOX) .................................................................................. 2 - 20
7.TAG ...................................................................................................... 2 - 22
TABLES Section ......................................................................................... 2 - 24
ATTRIBUTES Section ................................................................................. 2 - 25
1.BUTTON............................................................................................... 2 - 26
2.BUTTONEDIT....................................................................................... 2 - 27
3.CANVAS............................................................................................... 2 - 28
4.CHECKBOX ......................................................................................... 2 - 29
5.COMBOBOX ........................................................................................ 2 - 30
6.DATEEDIT............................................................................................ 2 - 31
7.EDIT ..................................................................................................... 2 - 32
8.GROUP ................................................................................................ 2 - 33
9.IMAGE.................................................................................................. 2 - 34
10.LABEL ................................................................................................ 2 - 35
11.PROGRESSBAR................................................................................ 2 - 37
12.RADIOGROUP................................................................................... 2 - 38
13.SCROLLGRID .................................................................................... 2 - 39
Genero BDL 技術手冊 目錄-1
Genero BDL 技術手冊目錄
14.TABLE ................................................................................................ 2 - 39
15.TEXTEDIT .......................................................................................... 2 - 40
INSTRUCTIONS Section ............................................................................ 2 - 41
第三章 變數及運算
變數的定義...................................................................................................... 3 - 1
變數的型態...................................................................................................... 3 - 2
變數的集合(Records) ................................................................................. 3 - 4
變數的設定...................................................................................................... 3 - 5
初始化一組變數的值 ....................................................................................... 3 - 5
預定義完成變數(PRE-DEFINED Variable) ................................................. 3 - 6
常數的定義(CONSTANT) ........................................................................... 3 - 6
預定義完成常數(PRE-DEFINED Constant)................................................ 3 - 6
運算式............................................................................................................. 3 - 7
全域變數指定.................................................................................................. 3 - 9
變數的生命週期 .............................................................................................. 3 - 10
USING ............................................................................................................ 3 - 11
第四章 程式控制流程
Module 程式架構............................................................................................. 4 - 1
MAIN()函式............................................................................................. 4 - 1
一般 FUNCTION()函式 ........................................................................... 4 - 3
報表結構 REPORT()函式........................................................................ 4 - 3
註解符號...................................................................................................... 4 - 3
CALL .............................................................................................................. 4 - 4
RETURN......................................................................................................... 4 - 4
IF .................................................................................................................... 4 - 6
CASE.............................................................................................................. 4 - 7
FOR................................................................................................................ 4 - 9
WHILE ............................................................................................................ 4 - 10
CONTINUE..................................................................................................... 4 - 10
EXIT ............................................................................................................... 4 - 11
SLEEP............................................................................................................ 4 - 12
第五章 WINDOWS 與 FORM
WINDOWS 與 FORM ..................................................................................... 5 - 1
OPEN WINDOW............................................................................................. 5 - 1
CLEAR ........................................................................................................... 5 - 2
Genero BDL 技術手冊 目錄-2
DataSystem
CLEAR FORM ................................................................................................ 5 - 2
CLOSE WINDOW........................................................................................... 5 - 3
CURRENT WINDOW ..................................................................................... 5 - 4
OPEN FORM.................................................................................................. 5 - 5
DISPLAY FORM ............................................................................................. 5 - 5
CLOSE FORM................................................................................................ 5 - 5
第六章 功能表
建立功能表...................................................................................................... 6 - 1
第七章 DISPLAY 與 INPUT
DISPLAY 與 INPUT......................................................................................... 7 - 1
DISPLAY 指令................................................................................................. 7 - 1
INPUT 指令..................................................................................................... 7 - 3
INPUT 架構..................................................................................................... 7 - 5
INPUT 控制點 ................................................................................................. 7 - 6
WITHOUT DEFAULTS.................................................................................... 7 - 7
PROMPT ........................................................................................................ 7 - 8
第八章 CURSOR 的應用
CURSOR 資料的查詢、修改 .......................................................................... 8 - 1
CONSTRUCT ............................................................................................. 8 - 1
PREPARE ................................................................................................... 8 - 3
資料的查詢...................................................................................................... 8 - 4
SCROLLING CURSOR............................................................................... 8 - 5
FETCH 敘述 ............................................................................................ 8 - 6
NON-SCROLLING CURSOR...................................................................... 8 - 8
FOREACH 敘述....................................................................................... 8 - 8
資料的鎖定...................................................................................................... 8 - 9
LOCKING CURSOR ................................................................................... 8 - 9
USING 的使用時機 ......................................................................................... 8 - 11
TRANSACTION.............................................................................................. 8 - 12
大量執行同一 SQL 指令(EXECUTE).......................................................... 8 - 13
大量執行新增指令(PUT…FLUSH) ............................................................. 8 - 14
Genero BDL 技術手冊 目錄-3
Genero BDL 技術手冊目錄
第九章 ARRAY 的應用
ARRAY(陣列) ............................................................................................. 9 - 1
INPUT ARRAY................................................................................................ 9 - 4
DISPLAY ARRAY............................................................................................ 9 - 9
第十章 REPORT 撰寫
REPORT 撰寫................................................................................................. 10 - 1
啟動 REPORT................................................................................................. 10 - 1
REPORT FUNCTION 的組成.......................................................................... 10 - 3
OUTPUT Section ........................................................................................ 10 - 4
ORDER BY Section .................................................................................... 10 - 4
FORMAT Section ........................................................................................ 10 - 5
FORMAT 內可用的指令............................................................................... 10 - 5
列印時可運用的運算式或函數......................................................................... 10 - 6
群組函數 ......................................................................................................... 10 - 6
第十一章 Debugger 的應用
Debugger 的使用 ........................................................................................... 11 - 1
除錯模式的常用指令 ....................................................................................... 11 - 1
附錄 A ATTRIBUTES 功能說明....................................................................... A - 1
附錄 B 相關參考資訊...................................................................................... B - 1
附錄 C 上課地點位置圖.................................................................................. C - 1
Genero BDL 技術手冊 目錄-4