《Visual FoxPro 5.0中文版易学易用专辑 命令、函数篇》求取 ⇩

第一章 数据库操作命令1

ADD TABLE1

APPEND1

APPEND FROM2

APPEND FROM ARRAY4

APPEND GENERAL5

APPEND MEMO6

APPEND PROCEOURES6

AVERAGE7

BLANK8

DISPLAY DLLS9

BROWSE9

CALCULATE15

CHANGE16

CLOSE17

COMPILE DATABASE18

CLOSE MEMO18

CONTINUE19

COPY MEMO19

COPY PROCEDURES20

COPY STRUCTURE20

COPY STRUCTURE EXTENDED20

COPY TO21

COPY TO ARRAY24

COUNT25

CREATE25

CREATE CONNECTION26

CREATE DATABASE26

CREATE FROM26

CREATE LABEL27

CREATE TRIGGER28

DELETE29

CREATE VIEW29

DELETE TRJGGER30

DELETE CONNECTION30

DELETE DATABASE30

DELETE VIEW31

DISPLAY31

DISPLAY CONNECTIONS32

DISPLAY DATABASE32

DISPLAY PROCEDURES33

DISPLAY STRUCTURE33

DISPLAY VIEWS34

DROP TABLE34

DISPLAY TABLES34

DROP VIEW35

EDIT35

EXPORT37

FIND38

FLUSH38

GATHER39

GO|GOTO40

LMPORT40

LIST41

INSERT41

JOIN41

LIST CONNECTIONS42

LIST DATABASE42

LIST PROCEDURES43

LIST TABLES43

LIST VIEWS43

MODIFY DATABASE44

LOCATE44

MODIFY CONNECTION44

MODIFY GENERAL45

MODIFY MEMO45

MODIFY PROCEDURE46

MODJFY STRUCTURE46

MODIFY VIEW47

OPEN DATABASE47

PACK47

PACK DATABASE47

REMOVE TABLE48

RENAME CONNECTION48

RECALL48

RENAME TABLE49

RENAME VIEW49

REPLACE49

REPLACE FROM ARRAY50

SCAN...ENDSCAN51

SCATTER51

SELECT53

SEEK53

SET DATASESSION54

SET DATABASE54

SET FIELDS55

SET EXCLUSIVE55

SET DELETED55

SET FILTER56

SET REIATION56

SET RELATION OFF57

SET SKIP57

SET WINDOW OF MEMO58

SKIP58

SUM59

TOTAL59

UPDATE60

USE60

ZAP62

VALIDATE DATABASE62

第二章 索引排序命令63

COPY TNDEXES63

COPY TAG63

DELETE TAG64

INDEX64

REINDEX66

SET COLIATE66

SET INDEX67

SET KEY68

SET ORDER68

SET UNIQUE69

SORT69

|\\71

第三章 数据格式化命令71

?|??71

@...BOX72

???72

@...CLASS73

@...CLEAR73

@...EDIT73

@...FILL73

@...GET-微调74

@...GET-选项按钮74

@...GET-文本框74

@...GET-透明按扭74

@...GET-命令按钮74

@...GET-列表框74

@..GET-复选框74

@...GET-组合框75

@...SAY-图片和OLE对象75

@... SCROLL75

@..TO75

ACCEPT75

CLEAR75

COMPILE FORM76

CREATE FORM77

DEFINE BOX77

DO FORM77

MODIFY FORM78

INPUT78

READ79

SCROLL79

SET BORDER79

SET FORMAT79

SET TEXTMERGE79

MODIFY SCREEN79

SET TEXTMERGE DEL LMITERS80

SHOW GET80

SHOW GETS80

SHOW OBJECT80

TEXT...ENDTEXT80

WAIT81

CREATE CLASS82

ADD CLASS82

第四章 面向对象命令82

CREATE CLASSLIB83

DEFINE CLASS83

DISPLAY OBJECTS85

LIST OBJECTS85

MODIFY CLASS86

RELEASE CLASSLIB86

REMOVE CLASS86

RENAME CLASS87

SET CLASSLIB87

WITH...ENDWITH88

DELETE FILE89

CD|CHDIR89

第五章 文件管理命令89

COPY FILE89

DISPLAY FILES90

ERASE90

MD|MKDIR90

MODIFY FILE91

RD|RMDIR91

RENAME92

RUN|！92

SET ALTERNATE92

TYPE93

DECLARE-DLL94

CREATE COLOR SET94

第六章 环境设置命令94

DIR|DIRECTORY95

DISPLAY STATUS96

LIST DLLS98

SET98

SET ANSI98

SET ASSERTS98

SET AUTOSAVE99

SET BELL99

SET BLOCKSIZE99

SET CENTURY100

SET CLEAR100

SET BRSTATUS100

SET CARRY100

SET CLOCK101

SET COLOR OF101

SET COLOR OF SCHEME101

SET COLOR SET101

SET COLOR TO102

SET COMPATIBLE102

SET CONFIRM103

SET CONSOLE103

SET COVERAGB103

SET CPDIALOG104

SET CURRENCY104

SET CPCOMPILE104

SET CURSOR105

SET DATE105

SET DEBUG106

SET DEBUGOUT106

SET DECIMALS106

SET DEFAULT107

SET DELIMITERS107

SET DEVELOPMENT107

SET DEVICE107

SET DISPLAY108

SET DOHISTORY108

SET ESCAPE108

SET EVENTLIST108

SET EXACT109

SET EVENTTRACKING109

SET FIXED110

SET FULLPATH110

SET FUNCTION110

SET FDOW110

SET FWEEK111

SET HEADINGS111

SET HELP111

SET HELPFILTER112

SET HOURS112

SET INTENSITY112

SET KEYCOMP112

SET MARGIN113

SET MARK TO113

SET MACKEY113

SET MEMOWIDTH114

SET MESSAGE114

SET NEAR114

SET NOCPTRANS115

SET NOTIFY115

SET NULL115

SET NULLDISPLAY116

SET ODOMETER116

SET OLEOBJECT116

SET OPTIMIZE117

SET PALETTE117

SET PATH118

SET PDSETUP118

SET PRINTER119

SET POINT119

SET SAFETY120

SET RESOURCE120

SET SECONDS121

SET SEPARATOR121

SET SPACE121

SET STATUS121

SET STATUS BAR121

SET SYSFORMATS121

SET TALK122

SET TOPIC122

SET TOPIC ID122

SET VIEW123

MOUSE124

第七章 键盘和鼠标命令124

KEYBOARO124

ON ERROR125

ON ESCAPE126

ON KEY126

ON KEY=126

ON KEY LABEL126

ON SHUTDOWN127

PLAY MACRO128

POP KEY128

PUSH KEY128

RESTORE MACROS128

SET TYPEAHEAD129

SAVE MACROS129

@...MENU130

@...PROMPT130

第八章 菜单命令130

ACTIVATE POPUP132

CREATE MENU133

DEACTIVATE MENU134

DEACTIVATE POPUP134

DEFINE BAR134

DEFLNE MENU137

DEFINE PAD140

DEFINE POPUP142

MENU TO145

MODIFY MENU145

HIDE POPUP145

MENU145

HIDE MENU145

MOVE POPUP146

ON BAR146

ON EXIT BAR148

ON EXIT MENU148

ON EXIT PAD148

ON EXIT POPUP148

ON PAD148

ON SELECTION BAR149

ON SELECTION MENU149

ON SELECTION POPUP150

ON SELECTION PAD150

POP MENU151

POP POPUP151

PUSH MENU151

PUSH POPUP152

READ MENU152

RELEASE BAR153

RELEASE MENUS153

RELEASE PAD153

RELEASE POPUPS154

SET MARK OF154

SET SKIP OF155

SHOW MENU156

SET SYSMENU156

SHOW POPUP157

SIZE POPUP157

第九章 窗口命令158

ACTIVATE SCREEN158

ACTIVATE WINDOW158

CREATE SCREEN159

DEACTIVATE WINDOW159

DEFINE WINDOW160

HIDB WINDOW162

MODIFY WINDOW163

MOVE WINDOW164

RELEASE WINDOWS164

RESTORE SCREEN164

SAVE SCREEN165

RESTORE WINDOW165

SHOW WINDOW166

SAVE WINDOWS166

SICZ WINDOW167

ZOOM WINDOW168

第十章 程序控制命令170

#DEFINE...#UNDEF170

#IF...#ENDIF170

#IFDEF|#IFNDEF...#ENDIF172

#INCLUDE172

173

174

=174

ASSERT174

CANCEL175

COMPILE175

ASSIST175

CALL175

DEBUG176

DEBUGOUT176

DO177

DECLARE177

DIMENSION177

DO CASE...ENDCASE178

DO WHILE...ENDDO179

DOEVENTS179

ERROR179

EXTERNAL180

EXIT180

FOR...ENDFOR181

FOR EACH...ENDFOR182

PUNCTION184

GETEXPR184

IF...ENDIF185

LOAD185

LOCAL185

LPARAMETERS186

PARAMETERS186

PRIVATE187

RECIONAL188

QUIT188

PUBLIC188

PROCEDURE188

RELEASE189

RELEASE LIBRARY189

RELEASE PROCEDURE190

RESTORE FROM190

RESUME190

RETRY191

RETURN191

SAVE TO191

SET ECHO192

SET LIBRARY192

SET LOGERRORS192

SET TRBETWEEN193

SET STEP193

SET PROCEDURE193

SET READBORDER193

SET UDFPARMS194

STORE194

SUSPEND194

第十一章 应用管理命令195

BUILD APP195

BUILD DLL195

BUILD EXE195

BUILD PROJECT196

CREATE PROJECT197

CREATE QUERY197

MODIFY PROJECT198

HELP198

DISPLAY MEMORY198

MODIFY QUERY199

第十二章 网络命令200

BEGIN TRANSACTION200

CREAIE SQL VIEW200

END TRANSACTION201

ROLLBACK201

SET LOCK202

SET MULTILOCKS202

SET REFRESH202

SET REPROCESS203

UNLOCK203

ALTER TABLE-SQL204

第十三章 SQL命令204

CREATE CURSOR-SQL207

CREATE TABLE-SQL209

DELETE-SQL212

INSERT-SQL213

SELECT-SQL213

UPDATE-SQL220

第十四章 打印命令222

CREATE REPORT222

CREATE REPORT-快速报表222

EJECT223

EJECT PAGE223

LABEL224

MODIFY REPORT225

MODIFY LABEL225

ON PAGE226

PRINTJOB...ENDPRINTJOB226

REPORT227

第十五章 操作符229

:作用域操作符229

$230

%230

日期和时间操作符231

数值操作符231

字符操作符231

逻辑操作符232

关系操作符232

第十六章 字符函数233

ALLTRIM( )233

ASC( )233

AT( )233

AT_C( )234

ATC( )234

ATCC( )235

ATCLINE( )235

ATLINE( )236

BETWEEN( )237

CHRSAW( )237

CHRTRAN( )237

DIFFERENCE( )238

CHRTRANC( )238

EVALUATE( )239

INLIST( )239

ISALPHA( )239

ISBLANK( )240

ISDIGIT( )241

ISLEADBYTE( )241

ISLOWER( )241

ISUPPER( )241

LEFT( )242

LEFTC( )242

LEN( )242

LENC( )242

LIKEC( )243

LIKE( )243

LTRIM( )244

NORMALIZE( )244

LOWER( )244

OCCURS( )245

PADL( )|PADR( )|PADC( )245

PROPER( )245

RAT( )246

RATC( )246

PATLINE( )247

PEPLICATE( )247

RIGHT( )247

SOUNDEX( )248

SPACE( )248

RTRIM( )248

RIGHTC( )248

STR( )249

STRCONV( )249

STRTRAN( )249

STUFF( )250

STUFFC( )250

SUBSTR( )251

SUBSTRC( )251

TRANSFORM( )251

TRIM( )252

TXTWIDTH( )252

TYPE( )253

UPPER( )254

第十七章 类型转换函数255

BINTOC( )255

CHR( )255

CREATEBINARY( )256

CTOBIN( )256

CTOD( )256

DTOC( )257

DTOS( )257

MTON( )258

NTOM( )258

TTOD( )259

TTOC( )259

NVL( )259

第二十八章 日期和时间函数260

CDOW( )260

CMONTH( )260

DATE( )260

DATETIME( )261

DAY( )261

DMY( )261

DOW( )261

DTOT( )262

FDATE( )262

MINUTE( )263

MDY( )263

GOMONTH( )263

HOUR( )263

MONTH( )264

SEC( )264

SECONDS( )264

TIME( )264

WEEK( )265

YEAR( )265

ABS( )266

ACOS( )266

ASIN( )266

ATN2( )267

BITAND( )267

ATAN( )267

BITCLEAR( )268

BITLSHIFT( )268

BITNOT( )268

BITOR( )269

BITRSHIFT( )269

BITSET( )269

BITTEST( )269

BITXOR( )270

CEILING( )270

COS( )271

DTOR( )271

EXP( )271

FLOOR( )271

INT( )272

LOG( )272

FV( )272

LOG10( )273

MAX( )273

MIN( )273

MOD( )273

PAYMENT( )273

PI( )274

PV( )274

RAND( )275

ROUND( )275

RTOD( )275

SIGN( )275

TAN( )276

VAL( )276

SQRT( )276

SIN( )276

第二十章 数据库操作函数278

ADATABASES( )278

ADBOBJECTS( )278

AFIELDS( )279

ALIAS( )280

AUSED( )280

BOF( )281

CANDIDATE( )281

CDX( )281

CPDBF( )282

CURSORGETPROP( )283

CREATEOFFLINE( )283

CURSORSETPROP( )285

CURVAL( )286

DBC( )287

DBF( )287

DBGETPROP( )287

DBSETPROP( )292

DBUSED( )292

DELETED( )293

DESCENDING( )293

DROPOFFLINE( )294

EMPTY( )294

FCOUNT( )295

EOF( )295

FIELD( )296

FILTER( )296

FLDLIST( )296

FOR( )296

FOUND( )297

GETFLDSTATE( )297

GETNEXTMODIFIED( )298

HEADER( )299

JDXCOLLATE( )299

INDBC( )300

ISEXCLUSIVE( )301

ISREADONLY( )301

KEY( )301

LOOKUP( )302

KEYMATCH( )302

LUPDATE( )303

MDX( )303

MEMLINES( )304

MLINE( )304

NDX( )305

ORDER( )305

PRIMAPY( )305

RECCOUNT( )306

RECNO( )306

RECSIZE( )307

REFRESH( )307

RELATION( )307

SEEK( )308

SELECT( )309

SETFLDSTATE( )309

SQLCANCEL( )310

SQLCOLUMNS( )311

SQLCOMMTT( )312

SQLCONNECT( )312

SQLDISCONNECT( )313

SQLEXEC( )313

SQLGETPROP( )314

SQLMORERESULTS( )315

SQLPREPARE( )316

SQLROLLBACK( )316

SQLSETPROP( )317

SQLSTRINGCONNECT( )318

SQLTABLES( )319

TAG( )320

TAGCOUNT( )321

TAGNO( )321

TARGET( )321

UNIQUE( )322

USED( )322

第二十一章 环境设置函数323

ANSITOOEM( )323

CPCONVERT( )323

CPCURRENT( )323

GETCP( )324

GETEW( )324

GETCOLDR( )324

HOME( )325

IMESTATUS( )325

ISCOLOR( )326

OEMTOANSI( )326

OS( )326

VERSION( )326

第二十二章 SYS( )函数328

SYS( )函数浏览328

SYS(0)-网络机器信息329

SYS(1)-儒略历系统日期329

SYS(2)-自午夜开始以秒计的时间329

SYS(3)-自动生成合法的文件名329

SYS(9)-Visual Fox Pro系列号330

SYS(7 )-当前格式文件330

SYS(5 )-默认驱动器330

SYS(10)-儒略历日期转换为公历日期的字符串330

SYS(6 )-当前打印设备330

SYS(11)-将公历日期转换为儒略历日期331

SYS(12)-可用内存的字节数331

SYS(13)-打印机状态331

SYS(14)-索引表达式332

SYS(15)-字符变换332

SYS(16)-正在执行的程序的文件名332

SYS(17)-正在使用的中央处理器333

SYS(18)-当前控件333

SYS(20)-转换德文文本333

SYS(21) -主控索引号333

SYS(22)-主控索引标识或索引名333

SYS(23)-Visual Foxpro的EMS内存用法334

SYS(24)- Visual Foxpro EMS内存限制334

SYS(100)-控制台设置334

SYS(101)-设备设置334

SYS(1001)- Visual Foxpro内存335

SYS(1016)-用户对象内存使用335

SYS(102)-打印机设置335

SYS(1023)-启用帮助诊断模式335

SYS(103)-对话设置335

SYS(1024)-终止帮助诊断模式336

SYS(1037)- 页面设置 对话框336

SYS(1270)-返回指定位置的对象的引用336

SYS(1500)-激活一个菜单项337

SYS(1272)-对象层次337

SYS(1271)-对象的.SCX或.VCX文件337

SYS(2000)-返回与文件梗概匹配第一个(下一个)文件338

SYS(2001)-SET...命令状态338

SYS(2002)-显示或不显示插入点338

SYS(2003)-当前目录或文件夹338

SYS(2004)-Visual FoxPro启动目录或文件夹339

SYS(2005)-当前资源文件339

SYS(2006)-当前图形适配卡339

SYS(2007)-字符串的求和校验值339

SYS(2010)-CONFIG.SYS文件设置340

SYS(2011)-当前锁定状态340

SYS(2012)-备注字段块大小340

SYS(2013)-系统菜单名称字符串340

SYS(2015)-唯一的过程名341

SYS(2016)-返回SHOW GETS WINDOW中的窗口名称341

SYS(2017)-显示启动屏幕341

SYS(2014)-最小化路径341

SYS(2019)-配置文件的名称和位置342

SYS(2020)-缺省磁盘空间342

SYS(2018)-错误信息参数342

SYS(2022)-磁盘簇(块)大小343

SYS(2023)-临时文件存储路径343

SYS(2021)-索引的筛选表达式343

SYS(2029)-表类型344

SYS(3004)-返回环境ID值345

SYS(3005)-设置环境ID值345

SYS(2333)-ActiveX双重界面支持345

SYS(3006)-设置语言和环境ID值346

SYS(3050)-设置缓冲内存大小347

SYS(3051)-设置锁定重试间隔347

SYS(3052)-忽略SET REPROCESS锁定347

SYS(3053)-ODBC环境句柄348

SYS(3054)-Rushmore优化级348

SYSMETRIC( )349

第二十三章 文件管理函数351

CURDIR( )351

DIRECTORY( )351

DISKSPACE( )352

FCHSIZE( )352

FCLOSE( )352

FCREATE( )353

FERROR( )354

FEOF( )354

FFLUSH( )355

FGETS( )356

FTLE( )356

FOPEN( )357

FPUTS( )358

FREAD( )358

FSEEK( )359

FSIZE( )360

FTIME( )360

FWRITE( )361

GETDIR( )361

FULLPATH( )361

GETFILE( )362

GETPICT( )363

LOADPICTURE( )364

LOCFILE( )364

PUTFILE( )365

SAVEPICTURE( )366

SYS(1269)-属性信息366

第二十四章 网络函数367

FLOCK( )367

ISFLOCKED( )368

ISRLOCKED( )368

LOCK( )368

OLDVAL( )370

REQUERY( )371

RLOCK( )371

TABLEREVERT( )373

TABLEUPDATE( )374

TXNLEVEL( )375

第二十五章 键盘和鼠标输入函数376

CAPSLOCK( )376

FKLABEL( )376

FKMAX( )376

INKEY( )377

LASTKEY( )379

MCOL( )379

ISMOUSE( )379

INSMODE( )379

MDOWN( )380

MROW( )380

MWINDOW( )380

NUMLOCK( )381

第二十六章 菜单和菜单栏函数382

BAR( )382

BARCOUNT( )383

BARPROMPT( )384

CNTBAR( )384

CNTPAD( )386

GETBAR( )386

GETPAD( )387

MENU( )388

MRKBAR( )389

MRKPAD( )389

PAD( )390

POPUP( )391

PRMBAR( )391

PRMPAD( )392

PROMPT( )393

SKPBAR( )393

SKPPAD( )393

第二十七章 打印函数394

APRINTERS( )394

GETPRINTER( )394

PROW( )395

PCOL( )395

PRINTSTATUS( )395

PRTINFO( )396

第二十八章 窗口函数400

SCOLS( )400

SROWS( )400

WBORDER( )400

WCHILD( )401

WCOLS( )401

WEXIST( )402

WFONT( )402

WLAST( )403

WLCOL( )403

WMINIMUM( )404

WMAXIMUM( )404

WLROW( )404

WONTOP( )405

WOUTPUT( )405

WPARENT( )406

WREAD( )407

WROWS( )407

WTITLE( )407

WVISIBLE( )408

第二十九章 程序管理函数409

ACLASS( )409

AINSTANCE( )410

AMEMBERS( )410

COMPOBJ( )411

ASELOBJ( )411

CREATEOBJECT( )412

DODEFAULT( )413

ERROR( )414

GETOBJECT( )414

GETPEM( )415

LINENO( )415

MESSAGE( )416

MESSAGEBOX( )416

OBJNUM( )418

OBJTOCLIENT( )418

OBJVAR( )421

ON( )421

PARAMETERS( )422

PCOUNT( )423

PEMSTATUS( )424

PROGRAM( )424

SET( )425

第三十章 变量处理函数427

ACOPY( )427

ADEL( )428

ADIR( )428

AELEMENT( )429

AERROR( )430

AINS( )431

ALEN( )432

ASCAN( )432

ASORT( )433

ASUBSCRIPT( )434

MEMORY( )435

第三十一章 DDE函数436

DDE函数436

DDEAbortTrans( )437

DDEAdvise( )437

DDEEnabled( )439

DDEExecute( )439

DDEInitiate( )440

DDELastError( )441

DDEPoke( )442

DDERequest( )443

DDESetService( )444

DDESetOption( )444

DDESetTopic( )446

DDETerminate( )448

第三十二章 其它函数449

AFONT( )449

COL( )449

FONTMETRIC( )449

GETFONT( )450

IIF( )451

ISNULL( )451

RGB( )451

RGBSCHEME( )452

ROW( )452

SCHEME( )452