《PowerBuilder 6.0函数、事件和属性精解 卷1》

第一篇函数及调用举例1

1.1对象函数2

1.1.1一般对象函数4

AcceptText4

AddColumn5

AddItem（格式1）6

AddItem（格式2）8

AddItem（格式3）9

AddItem（格式4）10

AddLargePicture12

AddPicture13

AddSmallPicture14

AddStatePicture16

Arrange18

ArrangeSheets20

CanUndo21

ChangeMenu21

Check22

CIassName（格式1）24

CIassName（格式2）25

Clear26

ClearValues27

Clipboard（格式1）29

Clipboard（格式2）30

Close（格式1）31

Close（格式2）32

Close（格式3）32

Close（格式4）33

CloseTab33

CloseUserObject34

CloseWithReturn35

CollapseItem36

Copy37

CopyRTF39

Create41

CrosstabDialog42

Cut44

DataSource45

DBCancel47

DBErrorCode48

DBErrorMessage50

DeletedCount51

DeleteColumn52

DeleteColumns53

DeleteItem（格式1）54

DeleteItem（格式2）55

DeleteItem（格式3）57

DeleteItems58

DeleteLargePicture60

DeleteLargePictures61

DeletePicture62

DeletePictures64

DeleteSmallpicture66

DeleteSmallPictures67

DeleteStatePicture68

DeleteStatePictures70

DeleteRow72

Describe74

DirList74

DirSelect76

Disable77

Drag79

DraggedObject82

Draw83

EditLabel（格式1）84

EditLabel（格式2）85

Enable85

EventParmDouble86

EventParmString87

ExpandAll87

ExpandItem89

Filter90

FilteredCount90

Find（格式1）92

Find（格式2）93

FindGroupChange95

FindItem（格式1）97

FindItem（格式2）99

FindItem（格式3）101

FindItem（格式4）103

FindNext105

FindRequired106

GetActiveSheet108

GetAlignment108

GetApplication109

GetBandAtPointer111

GetBorderStyle112

GetChild113

GetClickedColumn114

GetClickedRow115

GetColumn（格式1）116

GetColumn（格式2）117

GetColumnName119

GetData（格式1）120

GetData（格式2）122

GetEnvironment123

GetFirstSheet124

GetFocus125

GetFormat127

GetItem（格式1）128

GetItem（格式2）129

GetItem（格式3）131

GetItemDate132

GetItemDateTime133

GetItemDecimal135

GetItemNumber136

GetItemStatus136

GetItemString138

GetItemTime139

GetMessageText141

GetNextModified142

GetNextSheet144

GetObjectAtPointer146

GetOrigin147

GetParagraphSetting148

GetParent150

GetRow151

GetSelectedRow152

GetSpacing154

GetSQLPreview155

GetSQLSelect156

GetText157

GetTextColor159

GetTextStyle160

GetToolBar161

GetToolBarPos（格式1）163

GetToolBarPos（格式2）164

GetTrans165

GetUpdateStatus166

GetValidate168

GetValue168

GroupCalc170

Hide170

ImportClipboard（格式1）171

ImportClipboard（格式2）174

ImportFile（格式1）175

ImportFile（格式2）178

ImportString（格式1）179

ImportString（格式2）180

InputFieldChangeData181

InputFieldCurrentName182

InputFieldDeleteCurrent184

InputFieldGetData185

InputFieldInsert186

InputFieldLocate188

InsertColumn189

InsertDocument191

InsertItem（格式1）192

InsertItem（格式2）193

InsertItem（格式3）195

InsertItem（格式4）196

InsertItem（格式5）197

InsertItem（格式6）199

InsertItemFirst（格式1）200

InsertItemFirst（格式2）201

InsertItemLast（格式1）203

InsertItemLast（格式2）204

InsertItemSort（格式1）206

InsertItemSort（格式2）207

InsertPicture209

InsertRow211

IsArabic212

IsHebrew212

IsPreview213

IsSelected213

LineCount215

LineLength216

ModifiedCount216

Modify217

MoveTab220

Move221

Open（格式1）222

Open（格式2）223

Open（格式3）223

Open（格式4）225

Open（格式5）226

Open（格式6）227

Open（格式7）228

OpenTab（格式1）229

OpenTab（格式2）230

OpenTabWithParm（格式1）232

OpenTabWithParm（格式2）233

OpenUserObject（格式1）235

OpenUserObject（格式2）236

OpenUserObjectWithParm（格式1）238

OpenUserObjectWithParm（格式2）239

OpenWithParm（格式1）240

OpenWithParm（格式2）241

PageCount242

ParentWindow242

Paste242

PasteRTF244

PointerX246

PointerY246

PopMenu247

Position（格式1）248

Position（格式2）248

PostEvent249

Preview250

Print（格式1）251

Print（格式2）252

Print（格式3）253

Print（格式4）253

ReplaceText254

ReselectRow256

Reset（格式1）257

Reset（格式2）258

Reset（格式3）259

Reset（格式4）260

ResetUpdate261

Resize262

Retrieve263

Reverse265

RowCount266

RowsCopy266

RowsDiscard268

RowsMove270

SaveAS（语法1）272

SaveAS（语法2）273

SaveAS（语法3）274

SaveAS（语法4）276

SaveAS（语法5）277

SaveAS（语法6）277

SaveDocument279

Scroll280

ScrollNextPage（格式1）282

ScrollNextPage（格式2）283

ScrollNextRow（格式1）284

ScrollNextRow（格式2）285

ScrollPriorPage（格式1）286

ScrollPriorPage（格式2）287

ScrollPriorRow（格式1）289

ScrollPriorRow（格式2）289

ScrollToRow（格式1）290

ScrollToRow（格式2）291

SelectedColumn293

SelectedIndex294

SelectedItem295

SelectedLength296

SelectedLine298

SelectedPage300

SelectedStart301

SelectedText301

SelectItem（格式1）303

SelectItem（格式2）305

SelectItem（格式3）306

SelectRow307

SelectTab309

SelectText（格式1）310

SelectText（格式2）311

SelectTextAll312

SelectTextLine314

SelectTextWord315

SetActionCode317

SetAlignment318

SetBorderStyle319

SetChanges321

SetColumn（格式1）321

SetColumn（格式2）322

SetDetailHeight324

SetDropHighlight325

SetFilter327

SetFirstVisible328

SetFocus330

SetFormat331

SetFullState332

SetItem（格式1）333

SetItem（格式2）334

SetItem（格式3）335

SetItem（格式4）337

SetLevelPictures338

SetItemStatus340

SetMask340

SetMicroHelp341

SetOverlayPicture342

SetParagraphSetting345

SetPicture346

SetPosition（格式1）347

SetPosition（格式2）349

SetRedraw350

SetRow350

SetRowFocusIndicator351

SetSort352

SetSpacing354

SetSQLPreview356

SetSQLSelect356

SetState358

SetTabOrder359

SetText359

SetTextColor361

SetTextStyle362

SetToolBar364

SetToolBarPos（格式1）365

SetToolBarPos（格式2）367

SetTop368

SetTrans369

SetTransObject370

SetTransPool370

SetValidate371

SetValue373

ShareData375

SharedDataOff375

Show376

ShowHeadFoot376

Sort（格式1）378

Sort（格式2）378

Sort（格式3）380

SortAll381

State382

SyntaxFromSQL383

TabPostEvent384

TabTriggerEvent385

Text386

TextLine387

Top388

TotalItems388

TotalSelected389

TriggerEvent390

TypeOf391

Uncheck392

Undo394

Update394

UpdateLinksDialog395

WorkSpaceHeight396

WorkSpaceWidth396

WorkSpaceX396

WorkSpaceY397

1.1.2统计图对象函数397

AddCategory397

AddData（格式1）399

AddData（格式2）400

AddSeries401

CategoryCount403

CategoryName404

DataCount405

DeleteCategory407

DeleteDa ta408

DeleteSeries409

FindCategory410

FindSeries412

GetDataPieExplode413

GetDataStyle（格式1）414

GetDataStyle（格式2）414

GetDataStyle（格式3）415

GetDataValue415

GetSeriesStyle（格式1）417

GetSeriesStyle（格式2）418

GetSeriesStyle（格式3）418

GetSeriesStyle（格式4）419

InsertCategory419

InsertData421

InsertSeries422

ModifyData（格式1）423

ModifyData（格式2）425

ObjectAtPointer426

ResetDataColors428

SeriesCount429

SeriesName430

SetDataPieExplode431

SetDataStyle（格式1）434

SetDataStyle（格式2）435

SetDataStyle（格式3）437

SetSeriesStyle（格式1）438

SetSeriesStyle（格式2）439

SetSeriesStyle（格式3）441

SetSeriesStyle（格式4）442

1.2支持动态SQL的函数443

GetDyna m icDate443

GetDynamicDateTime443

GetDynamicNumber444

GetDynamicString444

GetDynamicTime445

SetDyanmicParm445

1.3动态数据交换函数（DDE函数）452

1.3.1DDE客户函数452

CloseChannel452

ExecRemote（格式1）453

ExecRemote（格式2）454

GetRemote（格式1）455

GetRemote（格式2）457

OpenChannel457

SetRemote（格式1）458

SetRemote（格式2）458

StartHotLink459

StopHotLink460

1.3.2DDE服务器函数466

GetcommandDDE466

GetcommandDDEorigin467

GetdataDDE467

GetdataDDEOrigin468

Respon dRemote469

SetdataDDE470

StartServerDDE471

StopServerDDE472

1.4日期函数474

Day474

DayName475

DayNumber475

DaysAfter476

Month477

RelativeDate477

RelativeTime478

Today478

Year479

1.5时间函数480

Hour480

Minute480

Now480

Second481

SecondsAfter481

1.6字符串处理函数482

Asc482

Fill483

Left483

LeftTrim484

Len484

Lower485

Mid485

Pos487

Replace487

Right488

RightTrim489

Space489

Trim489

Upper490

1.7数字处理类型函数490

Abs491

Ceiling491

Cos492

Exp492

Fact493

Int493

Log494

LogTen494

Max495

Min495

Mod496

Pi496

Rand497

Randomize497

Round498

Sign498

Sin499

Sqrt499

Tan500

Truncate500

1.8二进制大对象处理函数（Blob类型函数）501

Blob501

BlobEdit501

BlobMid502

1.9数据类型转换函数503

Char503

Date（格式1）504

Date（格式2）504

Date（格式3）505

DateTime（语法1）505

DateTime（语法2）506

Dec506

Double507

Integer507

Real508

String（格式1）508

String（格式2）509

Time（格式1）509

Time（格式2）510

Time（格式3）510

1.10打印函数（Print函数）511

Print（格式1、2、3、4）511

PrintBitmap511

PrintCancel（格式1）513

PrintCancel（格式2）513

PrintClose513

PrintDataWindow514

PrintDefinedFont514

PrintLine515

PrintOpen515

PrintOval516

PrintPage517

PrintRect517

PrintRoundRect518

PrintScreen518

PrintSend519

PrintSetFont519

PrintSetSpacing520

PrintSetup520

PrintText521

PrintWidth522

PrintX522

PrintY522

1.11文件支持函数523

FileClose523

FileDelete524

FileExists524

FileLength526

FileOpen526

FileRead527

FileSeek528

FileWrite529

1.12邮件函数530

mailAddress530

mailDeletemessage532

mailGetmessages534

mailHandle537

mailLogoff537

mailLogon537

mailReadMessage539

mailRecipientDetails541

mailResolveRecipient543

mailSaveMessage544

mailSend545

1.13外部函数支持函数547

Handle547

IntHigh548

IntLow548

Long（格式1）549

Long（格式2）549

1.14PowerBuilder库管理函数550

LibraryCreate550

LibraryDelete550

Libra ryDirectory551

LibraryExport551

LibraryImport552

SetLibraryList552

1.15其它函数553

Beep553

CommandParm554

CPu555

DBHandle555

DebugBreak556

Doscript556

FindClassDefinition556

Find FunctionDefinition557

FindMatchingFunction557

FindTypeDefinition558

GarbageCollectGetTimeLimit558

GarbageCollectSetTimeLimit559

Ga rbageCollect559

GetFileOpenName559

GetFileSaveName561

Idle563

IsDate564

IsNull564

IsNumber565

IsRowModified565

IsRowNew566

IsSelected567

IsTime567

IsValid568

KeyDown568

LowerBound569

Match570

MessageBox570

OpenSheet572

OpenSheetWithParm573

PixelsToUnits574

Post574

ProfileInt576

ProfileString577

ResetTransObject578

Restart578

RGB578

Run579

Send579

SetNuH580

Setpointer581

SetProfileString581

ShowHelp582

SignalError583

Start（格式1）583

Stop583

SystemRoutine584

Timer584

UnitsToPixels585

UpperBound585

Yield586

1.16在数据窗口中使用的统计函数587

Avg587

Count aggregate588

CrosstabAvg aggregate589

CrosstabCount aggregate589

CrosstabMax aggregate590

CrosstabMin aggregate590

CrosstabSum aggregate591

CumulativePercent591

CumulativeSum592

First593

Large593

Last594

Max595

Median596

Min597

Mode598

Percent599

Small600

StDev602

StDevP603

Sum603

Var604

VarP604

1.17对象连接与嵌入（OLE）函数606

Activate606

ConnectToNewObject608

ConnectToNewRemoteObject612

ConnectToObject613

ConnectToRemoteObject616

DisconnectObject617

DoVerb617

GetAutomationNativePointer618

GetNativePointer618

InsertClass619

InsertFile620

InsertObject622

Length624

LinkTo625

MemberDelete626

MemberExists627

MemberRename627

OLEActivate628

PasteLink629

PasteSpecial630

Read（格式1）632

Read（格式2）633

ReleaseAutomationNativePointer633

ReleaseNativePointer634

Save634

Seek634

SelectObject635

SetAutomationLocale636

SetAutomationPointer636

SetAutomationTimeout637

SetData637

Write638

1.18数据管道（Data PipeLine）函数639

Cancel639

Repair639

Start（格式2）640

1.19分布式（Distributed）应用函数648

CreateInstance648

GetChanges649

GetFullState650

GetServerinfo650

GetStateStatus650

Listen651

RemoteStopConnection652

SharedObjectDirectory652

SharedObjectGet653

SharedObjectRegister654

SharedObjectUnregister654

SetConnect654

StopListening655

CreateInstance656

1.20Internet/Intranet服务657

GenerateHTMLForm657

GetArgElement658

GetCompanyName658

GetContextKeywords658

GetContextService659

GetHostObject659

GetLastReturn660

GetMajorVersion660

GetMinorVersion660

GetName673

GetShortName673

GetURL674

GetVersionName674

HyperlinkToURL675

InternetData675

PopulateError676

PostURL676

ResetArgElements677

SetArgElement677

1.21Trace678

BuildModel678

ClassList678

DestroyModel679

EntryList679

GetChildrenList680

IncomingCallList680

LineList681

NextActivity681

Open（格式8）681

OutgoingCallList682

RoutineList683

SetTraceFileName683

TraceBegin684

TraceClose684

TraceDisableActivity684

TraceEnableActivity685

TraceEnd686

TraceError687

TraceOpen687

TraceUser688

1.22系统注册表函数688

RegistryDelete688

RegistryGet688

RegistryKeys689

RegistrySet689

RegistryValues690