第一篇 PowerScript语言

第1章 PowerScript语言初步

1.1 注释行

1.2 标识符

1.3 标号

1.4 特殊ASCII字符

1.5 空值(NULL)

1.6 保留字

1.7 代名词

1.8 续行和断句

1.9 空白(White Space)

第2章 数据类型

2.1 标准数据类型

2.2 系统对象数据类型

2.3 枚举类型

第3章 变量、常量、数组和外部函数的说明

3.1 变量和常量

3.2 说明变量和常量

3.3 变量和常量可见范围

3.4 说明数组

3.5 引用变量

第4章 操作符和表达式

4.1 操作符

4.2 操作符在表达式中的优先级

4.3 表达式的数据类型

4.4 赋值与表达式

第5章 语句

5.1 赋值语句

5.3 CHOOSE CASE

5.2 CALL

5.4 CONTINUE

5.5 CREATE

5.6 DESTROY

5.7 DO...LOOP

5.8 EXIT

5.9 FOR...NEXT

5.10 GOTO

5.11 HALT

5.12 IF...THEN

5.13 RETURN

6.1 在PowerScript中使用SQL语句

第6章 SQL语句

6.2 CLOSE

6.3 COMMIT

6.4 CONNECT

6.5 DECLARE

6.6 DELETE

6.8 EXECUTE

6.9 FETCH

6.7 DISCONNECT

6.10 INSERT

6.11 OPEN Cursor

6.12 ROLLBACK

6.13 SELECT

6.14 SELECTBLOB

6.15 UPDATE

6.16 UPDATEBLOB

6.17 动态SQL语句的使用

7.1.2 用户对象

7.1.1 对象的概念

7.1 对象

第7章 对象和结构

7.1.3 对象实例化

7.1.4 父对象和子对象

7.1.5 管理内存

7.2 结构体

7.3 行为类似于结构的用户对象

7.4 为对象和结构赋值

8.1.1 调用函数和事件

8.1 函数和事件

第8章 调用函数和响应事件

8.1.2 各种类型函数和事件响应函数

8.1.3 函数和事件的比较

8.2 PowerBuilder寻找和执行事件和函数

8.2.1 函数

8.2.2 事件

8.3 调用事件或函数

8.3.1 触发(triggering)和告知调用(posting)函数和事件

8.3.2 静态对动态调用

8.5 说明和调用外部函数

8.4 调用函数和事件语法

8.6 把DBMS的存储过程说明为远程过程调用

第二篇 PowerScript事件

第9章 事件概述

9.1 事件的类型

9.2 事件标识(Event Id)

9.3 参数(Argument)

9.4 返回值

9.5 祖先事件脚本的返回值

9.6 用户定义的事件

第10章 事件详解

10.1 Activate

10.2 BeginDrag

10.3 BeginLabelEdit

10.4 BeginRightDrag

10.5 ButtonClicked

10.6 ButtonClicking

10.7 Clicked

10.8 Close

10.9 CloseQuery

10.10 ColumnClick

10.11 ConnectionBegin

10.12 ConnectionEnd

10.13 Constructor

10.14 DataChange

10.15 DBError

10.16 Deactivate

10.17 DeleteAllItems

10.18 DeleteItem

10.20 DoubleClicked

10.19 Destructor

10.21 DragDrop

10.22 DragLeave

10.23 DragWithin

10.24 EditChanged

10.25 EndLabelEdit

10.26 Error

10.27 ExtemalException

10.28 FileExists

10.29 GetFocus

10.31 HotLinkAlarm

10.30 Hide

10.33 InputFieldSelected

10.32 Idle

10.34 InsertItem

10.35 ItemChanged

10.36 ItemChanging

10.37 ItemCollapsed

10.38 ItemCollapsing

10.39 ItemError

10.40 ItemExpanded

10.42 ItemFocusChanged

10.41 ItemExpanding

10.43 ItemPopulate

10.44 Key

10.45 LineDown

10.46 LineLeft

10.47 LineRight

10.48 LineUp

10.49 LoseFocus

10.50 Modified

10.51 MouseDown

10.52 MouseMove

10.53 MouseUp

10.54 Moved

10.55 Open

10.56 Other

10.57 PageDown

10.58 PageLeft

10.59 PageRight

10.60 PageUp

10.61 PictureSelected

10.62 PipeEnd

10.63 PipeMeter

10.64 PipeStart

10.65 PrintEnd

10.66 PrintFooter

10.67 PrintHeader

10.68 PrintPage

10.69 PrintStart

10.70 PropertyChanged

10.71 PropertyRequestEdit

10.72 RButtonDown

10.73 RButtonUp

10.74 RemoteExec

10.75 RemoteHotLinkStart

10.76 RemoteHotLinkStop

10.77 RemoteRequest

10.78 RemoteSend

10.79 Rename

10.80 Resize

10.81 RetrieveEnd

10.82 RetrieveRow

10.83 RetrieveStart

10.84 RightClicked

10.85 RightDoubleClicked

10.86 RowFocusChanged

10.87 RowFocusChanging

10.88 Save

10.89 ScrollHorizontal

10.90 ScrollVertical

10.91 Selected

10.92 SelectionChanged

10.93 SelectionChanging

10.94 Show

10.95 Sort

10.96 SQLPreview

10.97 SystemError

10.98 SystemKey

10.99 Timer

10.101 UpdateEnd

10.102 UpdateStart

10.100 ToolBarMoved

10.103 ViewChange

第三篇 基本函数篇

第11章 数组函数

11.1 LowerBound()

11.2 UpperBound()

第12章 Blob(大二进制对象)函数

12.1 Blob()

12.2 BlobEdit()

12.3 BlobMid()

12.4 Len()

12.5 String()

第13章 数据类型检查与转换函数

13.1 Asc()

13.2 Char()

13.3 Dec()

13.4 Double()

13.5 Integer()

13.6 Long()

13.7 Real()

13.8 Date()

13.9 DateTime()

13.10 IsDate()

13.11 IsNull()

13.12 IsNumber()

13.13 IsTime()

13.14 Time()

第14章 数值计算函数

14.1 Abs()

14.2 Ceiling()

14.3 Cos()

14.4 Exp()

14.5 Fact()

14.6 Int()

14.7 Log()

14.8 LogTen()

14.9 Max()

14.10 Min()

14.11 Mod()

14.12 Pi()

14.13 Rand()

14.14 Randomize()

14.15 Round()

14.16 Sign()

14.17 Sin()

14.18 Sqrt()

14.19 Tan()

14.20 Truncate()

第15章 字符串操作函数

15.1 Fill()

15.2 Left()

15.3 LeftTrim()

15.4 Lower()

15.5 Match()

15.6 Mid()

15.7 Pos()

15.8 Replace()

15.9 Right()

15.10 RightTrim()

15.11 Space()

15.12 Trim()

15.13 Upper()

第16章 系统与环境函数

16.1 Clipboard()

16.2 CommandParm()

16.3 DoScript()

16.4 GetApplication()

16.5 GetEnvironment()

16.6 GetFocus()

16.7 Post()

16.8 ProfileInt()

16.9 ProfileString()

16.10 Restart()

16.11 Run()

16.12 Send()

16.13 SetProfileString()

16.14 ShowHelp()

16.15 SignalError()

16.16 Yield()

17.1 Day()

17.2 DayName()

第17章 日期、时间函数

17.3 DayNumber()

17.4 DaysAfter()

17.5 Hour()

17.6 Minute()

17.7 Month()

17.8 Now()

17.9 RelativeDate()

17.10 RelativeTime()

17.11 Second()

17.12 Today()

17.13 Year()

第18章 注册函数

18.1 RegistryDelete()

18.2 RegistryGet()

18.3 RegistryKeys()

18.4 RegistrySet()

18.5 RegistryValues()

第19章 定时函数

19.1 CPU()

19.2 Idle()

19.3 Timer()

第20章 DDE客户函数

20.1 CloseChannel()

20.2 ExecRemote()

20.3 GetDataDDE()

20.4 GetDataDDEOrigin()

20.5 GetRemote()

20.6 OpenChannel()

20.7 RespondRemote()

20.8 SetRemote()

20.9 StartHotLink()

20.10 StopHotLink()

第21章 DDE服务器函数

21.1 GetCommandDDE()

21.2 GetCommandDDEOrigin()

21.3 GetDataDDE()

21.4 GetDataDDEOrigin()

21.5 RespondRemote()

21.6 SetDataDDE()

21.7 StartServerDDE()

21.8 StopServerDDE()

第22章 文件操作函数

22.1 FileClose()

22.2 FileDelete()

22.3 FileExists()

22.4 FileLength()

22.5 FileOpen()

22.6 FileRead()

22.7 FileSeek()

22.8 FileWrite()

22.9 GetFileOpenName()

22.10 GetFileSaveName()

第23章 库管理函数

23.1 LibraryCreate()

23.2 LibraryDelete()

23.3 LibraryDirectory()

23.4 LibraryExport()

23.5 LibraryImport()

第24章 打印函数

24.1 Print()

24.2 PrintBitmap()

24.3 PrintCancel()

24.4 PrintClose()

24.5 PrintDataWindow()

24.6 PrintDefineFont()

24.7 PrintLine()

24.8 PrintOpen()

24.9 PrintOval()

24.10 PrintPage()

24.11 PrintRect()

24.12 PrintRoundRect()

24.13 PrintScreen()

24.14 PrintSend()

24.15 PrintSetFont()

24.16 PrintSetSpacing()

24.17 PrintSetup()

24.18 PrintText()

24.19 PrintWidth()

24.20 PrintX()

24.21 PrintY()

25.1 Close()

第25章 窗口操作函数

25.2 CloseWithRetum()

25.3 Open()

25.4 OpenSheet()

25.5 OpenSheetWithParm()

25.6 OpenWithParm()

第26章 字符集函数

26.1 Reverse()

26.2 ToAnsi()

26.3 ToUnicode()

27.2 ClassName()

27.1 Beep()

第27章 其他函数

27.3 DebugBreak()

27.4 IntHigh()

27.5 IntLow()

27.6 IsValid()

27.7 KeyDown()

27.8 MessageBox()

27.9 PixelsToUnits()

27.10 PopulateError()

27.11 RGB()

27.12 SetNull()

27.13 SetPointer()

27.14 SignalError()

27.15 UnitsToPixels()

第四篇 函数参考篇

第28章 函数参考

28.1 Activate

28.2 AddCategory

28.4 AddData

28.3 AddColumn

28.5 Addltem

28.6 AddLargePicture

28.7 AddPicture

28.8 AddSeries

28.9 AddsmallPicture

28.10 AddStatePicture

28.11 Arrange

28.12 ArrangeSheets

28.14 CanUndo

28.13 Cancel

28.15 CategoryCount

28.16 CategoryName

28.17 ChangeMenu

28.18 Check

28.19 ClassName

28.20 Clear

28.21 CloseTab

28.22 CloseUserObject

28.23 CloseWithReturn

28.25 ConnectToNewObject

28.24 CollapseItem

28.26 ConnectToObject

28.27 Copy

28.28 CopyRTF

28.29 Cut

28.30 DataCount

28.31 DataSource

28.32 Date

28.33 DateTime

28.34 DBHandle

28.36 DeleteColumn

28.35 DeleteCategory

28.37 DeleteColumns

28.38 DeleteData

28.39 DeletedCount

28.40 DeleteItem

28.41 DeleteItems

28.42 DeleteLargePicture

28.43 DeleteLargePictures

28.44 DeletePicture

28.46 DeleteSeries

28.45 DeletePictures

28.47 DeleteSmallPicture

28.48 DeleteSmallPictures

28.49 DeleteStatePicture

28.50 DeleteStatePictures

28.51 DirList

28.52 DirSelect

28.53 Disable

28.54 DisconnectObject

28.55 DoVerb

28.56 Drag

28.57 DraggedObject

28.58 Draw

28.59 EditLabel

28.60 Enable

28.61 EventParmDouble

28.62 EventParmString

28.63 ExecRemote

28.64 ExpandAll

28.66 Fact

28.65 ExpandItem

28.67 Find

28.68 FindGategory

28.69 FindItem

28.70 FindNext

28.71 FindSeries

28.72 GetActiveSheet

28.73 GetAlignment

28.74 GetAutomationNativePointer

28.75 GetColumn

28.76 GetData

28.77 GetDataPieExplode

28.78 GetDataStyle

28.79 GetDataValue

28.80 GetDynamicDate

28.81 GetDynamicDateTime

28.82 GetDynamicNumber

28.83 GetDynamicString

28.84 GetDynamicTime

28.85 GetFirstSheet

28.86 GetItem

28.87 GetNativePointer

28.88 GetNextSheet

28.89 GetOrigin

28.90 GetParagraphSetting

28.91 GetParent

28.92 GetRemote

28.93 GetSeriesStyle

28.94 GetSpacing

28.96 GetTextStyle

28.95 GetTextColor

28.97 GetToolbar

28.98 GetToolbarPos

28.99 Handle

28.100 Hide

28.101 ImportClipboard

28.102 ImportFile

28.103 ImportString

28.104 InputFieldchangeData

28.106 InputFieldGetData

28.105 InputFieldCurrentName

28.107 InputFieldInsert

28.108 InputFieldLocate

28.109 InsertCategory

28.110 InsertClass

28.111 InsertData

28.112 InsertColumn

28.113 InsertDocument

28.115 InsertItem

28.114 InsertFile

28.116 InsertItemFirst

28.117 InsertItemLast

28.118 InsertItemSort

28.119 InsertObject

28.120 InsertPicture

28.121 InsertSeries

28.122 IsPreview

28.123 Length

28.125 LineCount

28.124 LibrayCreate

28.126 LineLength

28.127 LinkTo

28.128 LowerBound

28.129 mailAddress

28.130 mailDeleteMessage

28.131 mailGetMessages

28.132 mailHandle

28.133 mailLogoff

28.134 mailLogon

28.135 mailReadMessage

28.136 maiRecipientDetails

28.137 mailResolveRecipient

28.138 mailSaveMessage

28.139 mailSend

28.140 Match

28.141 MemberDelete

28.142 MemberExists

28.143 MemberRename

28.144 ModifyData

28.145 Move

28.146 MoveTab

28.147 ObjectAtPointer

28.148 OpenTab

28.149 OpenTabWithParm

28.150 OpenUserObject

28.151 OpenUserObjectWithParm

28.152 PageCount

28.153 ParentWindow

28.154 Paste

28.155 PasteLink

28.156 PasteRTF

28.157 PasteSpecial

28.158 PointerX

28.159 PointerY

28.160 PopMenu

28.161 Position

28.162 PostEvent

28.163 Preview

28.164 Read

28.166 ReleaseNativePointer

28.165 ReleaseAutomationNativePointer

28.167 Repair

28.168 Replace

28.169 ReplaceText

28.170 Reset

28.171 ResetDataColors

28.172 Resize

28.173 RespondRomote

28.174 Restart

28.175 Save

28.176 SaveAs

28.177 SaveDocument

28.178 Scroll

28.179 ScrollNextPage

28.180 ScrollNextRow

28.181 ScrollPriorPage

28.182 ScrollPriorRow

28.183 ScrollToRow

28.184 SecondsAfter

28.185 Seek

28.186 SelectedColumn

28.187 SelectedIndex

28.188 SelectedItem

28.189 SelectedLength

28.190 SelectedLine

28.191 SelectedPage

28.192 SelectedStart

28.193 SelectedText

28.194 SelectItem

28.195 SelectObject

28.196 SelectTab

28.197 SelectText

28.198 SelectTextAll

28.199 SelectTextLine

28.200 SelectTextWord

28.201 SeriesCount

28.202 SeriesName

28.203 SetAlignment

28.204 SetAutomationLocale

28.205 SetColumn

28.206 SetData

28.207 SetDataPieExplode

28.208 SetDataStyle

28.209 SetDropHighlight

28.210 SetDynamicParm

28.211 SetFirstVisible

28.212 SetFocus

28.213 SetItem

28.214 SetLevelPictures

28.215 SetLibraryList

28.216 SetMask

28.217 SetMicroHeIp

28.218 SetOverlayPicture

28.219 SetParagraphSetting

28.220 SetPicture

28.221 SetPointer

28.222 SetPosition

28.223 SetRedraw

28.224 SetRemote

28.225 SetSeriesStyle

28.226 SetSpacing

28.227 SetState

28.229 SetTextColor

28.228 SetTabOrder

28.230 SetTextStyle

28.231 SetToolbar

28.232 SetToolbarPos

28.233 SetTop

28.234 SetTrans

28.235 SetTransPool

28.236 Show

28.237 ShowHeadFoot

28.238 ShowHelp

28.240 Sort

28.239 Sign

28.241 SortAll

28.242 Start

28.243 State

28.244 StopServerDDE

28.245 String

28.246 SyntaxFromSQL

28.247 TabPostEvent

28.248 TabTriggerEvent

28.250 TextLine

28.249 Text

28.251 Time

28.252 Timer

28.253 Top

28.254 TotalColumns

28.255 TotalItems

28.256 TotalSelected

28.257 TriggerEvent

28.258 TypeOf

28.259 Uncheck

28.260 Undo

28.261 UpdateLinksDialog

28.262 UpperBound

28.263 WorkSpaceHeight

28.264 WorkSpaceWidth

28.265 WorkSpaceX

28.266 WorkSpaceY

28.267 Write

附录 名词术语英中文对照表