《汉字dBASEⅣ基础》求取 ⇩

目录1

概述1

第一章　基础3

1.1　本章概要3

1.1.1　dBASE　Ⅳ语言元素3

1.1.2　点提示符接口4

1.1.3　文件名和别名4

1.1.4　程序和过程7

1.2　使用命令9

1.2.1　表达式10

1.2.2　数据类型11

1.2.3　操作符12

1.2.4　操作符的优先级13

1.3　使用SET命令14

1.4　使用函数14

1.4.1　用户自定义函数14

1.4.2　宏替换16

1.5　使用系统内存变量16

1.5.1　打印格式文件17

第二章　命令19

2.1 ?/??19

2.2　???22

2.3　@23

2.4　@…CLEAR30

2.6　@…TO31

2.5　@…FILL31

2.7　ACCEPT32

2.8　ACTIVATE MENU33

2.9　ACTIVATE POPUP33

2.10 ACTIVATE SCREEN34

2.11 ACTIVATE WINDOW34

2.12　APPEND35

2.13　APPEND FROM36

2.14　APPEND FROM ARRAY37

2.15 APPEND MEMO38

2.16 ASSIST39

2.18 BEGIN/END TRANSACTION40

2.17 AVERAGE40

2.19 BROWSE43

2.20 CALCULATE46

2.21 CALL48

2.22 CANCEL49

2.23 CHANGE49

2.24 CLEAR50

2.25 CLOSE51

2.26 COMPILE51

2.27 CONTINUE54

2.28 CONVERT54

2.29 COPY55

2.30 COPY FILE57

2.32 COPY MEMO58

2.31 COPY INDEXES58

2.33 COPY STRUCTURE59

2.34 COPY STRUCTURE EXTENDED60

2.35 COPY TAG60

2.36 COPY TO ARRAY61

2.37 COUNT62

2.38 CREATE或MODIFY STRUCTURE63

2.39 CREATE FROM65

2.40 CREATE VIEW FROM ENVIRONMENT66

2.41 CREATE/MODIFY APPLICATION67

2.42 CREATE/MODIFY LABEL68

2.43 CREATE/MODIFY QUERY/VIEW69

2.44 CREATE/MODIFY REPORT71

2.45 CREATE/MODIFY SCREEN72

2.46 DEACTIVATE MENU73

2.47 DEACTIVATE POPUP74

2.48 DEACTIVATE WINDOW75

2.49 DEBUG75

2.50 DECLARE76

2.51 DEFINE BAR78

2.52 DEFINE BOX80

2.53 DEFINE MENU80

2.54 DEFINE PAD81

2.55 DEFINE POPUP82

2.56 DEFINE WINDOW83

2.57 DELETE84

2.58 DELETE TAG85

2.59 DIR86

2.60 DISPLAY Commands86

2.61 DO87

2.62 DO CASE89

2.63 DO WHILE90

2.64 EDIT92

2.65 EJECT93

2.66 EJECT PAGE94

2.67 ERASE95

2.68 EXPORT95

2.69 FIND96

2.70 FUNCTION98

2.71 GO/GOTO100

2.72 HELP101

2.73 IF102

2.74 IMPORT103

2.75 INDEX104

2.76 INPUT107

2.77 INSERT108

2.78 JOIN109

2.79 LABEL FORM111

2.80 LIST/DISPLAY112

2.81 LIST/DISPLAY FILES113

2.82 LIST/DISPLAY HISTORY114

2.83 LIST/DISPLAY MEMORY114

2.84 LIST/DISPLAY STATUS116

2.85 LIST/DISPLAY STRUCTURE117

2.86 LIST/DISPLAY USERS118

2.87 LOAD118

2.88 LOCATE120

2.89 LOGOUT121

2.90 MODIFY COMMAND/FILE121

2.91 MODIFY Commands122

2.92 MOVE WINDOW123

2.93 NOTE/*/ 123

2.94 ON ERROR/ESCAPE/KEY124

2.95 ON PAD127

2.96 ON PAGE127

2.98 ON SELECTION PAD129

2.97 ON READERROR129

2.99 ON SELECTION POPUP130

2.100 PACK131

2.101 PARAMETERS131

2.102 PLAY MACRO132

2.103 PRINTJOB/ENDPRINTJOB133

2.104 PRIVATE134

2.105 PROCEDURE135

2.106 PROTECT136

2.107 PUBLIC139

2.108 QUIT140

2.109 READ140

2.110 RECALL141

2.111 REINDEX142

2.112 RELEASE142

2.113 RENAME143

2.114 REPLACE144

2.115 REPORT FORM145

2.116 RESET146

2.117 RESTORE147

2.118 RESTORE MACROS147

2.119 RESTORE WINDOW148

2.120 RESUME148

2.121 RETRY149

2.122 RETURN149

2.123 ROLLBACK150

2.124 RUN/！151

2.125 SAVE151

2.126 SAVE MACROS152

2.127 SAVE WINDOW152

2.128 SCAN153

2.129 SEEK154

2.130 SELECT155

2.131 SHOW MENU156

2.132 SHOW POPUP156

2.133 SKIP157

2.134 SORT158

2.135 STORE160

2.137 SUSPEND162

2.136 SUM162

2.138 TEXT163

2.139 TOTAL164

2.140 TYPE165

2.141 UNLOCK165

2.142 UPDATE166

2.143 USE167

2.144 WAIT170

2.145 ZAP170

第三章 SET命令172

3.1 SET172

3.2 SET ALTERNATE172

3.4 SET BELL174

3.3 SET AUTOSAVE174

3.5 SET BLOCKSIZE175

3.6 SET BORDER175

3.7　SET CARRY176

3.8 SET CATALOG177

3.9　SET CENTURY180

3.10 SET CLOCK181

3.11 SET COLOR181

3.12 SET CONFIRM186

3.13 SET CONSOLE186

3.14 SET CURRENCY186

3.15 SET CURRENCY LEFT/RIGHT187

3.17 SET DEBUG188

3.16 SET DATE188

3.18 SET DECIMALS189

3.19 SET DEFAULT189

3.20 SET DELETED190

3.21 SET DELIMITERS190

3.22 SET DESIGN191

3.23 SET DEVELOPMENT192

3.24 SET DEVICE192

3.25 SET DISPLAY193

3.26 SET DOHISTORY193

3.27 SET ECHO193

3.29 SET ESCAPE194

3.28 SET ENCRYPTION194

3.30 SET EXACT195

3.31 SET EXCLUSIVE196

3.32 SET FIELDS196

3.33 SET FILTER199

3.34 SET FIXED200

3.35 SET FORMAT200

3.36 SET FULLPATH201

3.37 SET FUNCTION202

3.38 SET HEADING203

3.39 SET HELP203

3.40 SET HISTORY204

3.41 SET HOURS204

3.42 SET INDEX205

3.43 SET INSTRUCT206

3.44 SET INTENSITY207

3.45 SET LOCK207

3.46 SET MARGIN209

3.47 SET MARK210

3.48 SET MEMOWIDTH210

3.49 SET MENU210

3.50 SET MESSAGE211

3.51 SET NEAR211

3.52 SET ODOMETER212

3.53 SET ORDER213

3.54 SET PATH214

3.57 SET PRECISION215

3.56 SET POINT215

3.55 SET PAUSE215

3.58 SET PRINTER216

3.59 SET PROCEDURE218

3.60 SET REFRESH219

3.61 SET RELATION220

3.62 SET REPROCESS222

3.63 SET SAFETY222

3.64 SET SCOREBOARD223

3.65 SET SEPARATOR223

3.66 SET SKIP224

3.67 SET SPACE225

3.69 SET STATUS226

3.68 SET SQL226

3.70 SET STEP227

3.71 SET TALK227

3.72 SET TITLE228

3.73 SET TRAP228

3.74 SET TYPEAHEAD229

3.75 SET UNIQUE229

3.76 SET VIEW230

3.77 SET WINDOW231

第四章 函数233

4.1 233

4.2 ABS(　)233

4.3 ACCESS(　)234

4.4 ACOS(　)235

4.5 ALIAS(　)236

4.6 ASC(　)236

4.7 ASIN(　)236

4.8 AT(　)237

4.9 ATAN(　)237

4.10 ATN2(　)238

4.11 BAR(　)239

4.12 BOF(　)239

4.13 CALL(　)240

4.14 CDOW(　)241

4.15 CEILING( )241

4.17 CHR( )242

4.16 CHANGE ( )242

4.18 CMONTH( )243

4.19 COL( )243

4.20 COMPLETED( )244

4.21 COS( )245

4.22 CTOD( )245

4.23 DATE( )246

4.24 DAY( )246

4.25 DBF( )247

4.26 DELETED( )247

4.27 DIFFERENCE( )248

4.29 DMY( )249

4.28 DISKSPACE( )249

4.30 DOW( )250

4.31 DTOC( )250

4.32 DTOR( )251

4.33 DTOS( )251

4.34 EOF( )252

4.35 ERROR( )253

4.36 EXP( )253

4.37 FIELD( )254

4.38 FILE( )254

4.39 FIXED( )255

4.40 FKLABEL( )255

4.42 FLOAT( )256

4.41 FKMAX( )256

4.43 FLOCK( )257

4.44 FLOOR( )257

4.45 FOUND( )258

4.46 FV( )258

4.47 GETENV( )259

4.48 IIF( )260

4.49 INKEY( )260

4.50 INT( )264

4.51 ISALPHA( )264

4.52 ISCOLOR ( )264

4.53 ISLOWER( )265

4.54 ISMARKED( )265

4.56 KEY( )266

4.55 ISUPPER( )266

4.57 LASTKEY( )267

4.58 LEFT( )267

4.59 LEN( )268

4.60 LIKE( )268

4.61 LINENO( )269

4.62 LKSYS( )270

4.63 LOG( )270

4.64 LOG10( )271

4.65 LOOKUP( )271

4.66 LOWER( )272

4.67 LTRIM( )273

4.68 LUPDATE( )273

4.70 MDX( )274

4.69 MAX( )274

4.71 MDY( )275

4.72 MEMLINES( )275

4.73 MEMORY( )276

4.74 MENU(　)276

4.75 MESSAGE(　)277

4.76 MIN(　)277

4.77 MLINE( )278

4.78 MOD(　)278

4.79 MONTH(　)279

4.80 NDX(　)279

4.82 ORDER(　)280

4.81 NETWORK(　)280

4.83 OS(　)281

4.84 PAD( )281

4.85 PAYMENT(　)282

4.86 PCOL ( )282

4.87 PI(　)283

4.88 POPUP( )283

4.89 PRINTSTATUS(　)284

4.90 PROGRAM(　)284

4.91 PROMPT( )285

4.92 PROW(　)285

4.93 PV(　)286

4.94 RAND(　)286

4.95 READKEY(　)287

4.96 RECCOUNT(　)288

4.97 RECNO(　)289

4.98 RECSIZE(　)289

4.99 REPLICATE( )290

4.100 RIGHT(　)291

4.101 RLOCK(　)/LOCK(　)291

4.102 ROLLBACK( )292

4.103 ROUND(　)292

4.104 ROW(　)293

4.105 RTOD(　)293

4.106 RTRIM(　)294

4.107 SEEK(　)294

4.108 SELECT(　)295

4.109 SET(　)296

4.110 SIGN(　)296

4.111 SIN(　)297

4.112 SOUNDEX(　)298

4.113 SPACE( )298

4.114 SQRT( )299

4.115 STR(　)299

4.116 STUFF(　)300

4.117 SUBSTR(　)300

4.118 TAG(　)301

4.119 TAN(　)301

4.120 TIME(　)302

4.121 TRANSFORM(　)302

4.122 TYPE(　)303

4.123 UPPER(　)304

4.124 USER(　)305

4.125 VAL(　)305

4.126 VARREAD(　)306

4.127 VERSION(　)307

4.128 YEAR(　)307

第五章 系统内存变量308

5.1 _alignment308

5.2 _box308

5.3 _indent309

5.4 _lmargin310

5.5 _padvance311

5.6 _pageno312

5.7 _pbpage313

5.8 _pcolno314

5.9 _pcopies315

5.10 _pdriver316

5.11 _pecode317

5.12 _peject318

5.13 _pepage318

5.14 _pform319

5.15 _plength319

5.16 _plineno320

5.17 _ploffset320

5.18 _ppitch321

5.20 _pscode322

5.19 _pquality322

5.21 _pspacing323

5.22 _pwait324

5.23 _rmargin324

5.24 _tabs325

5.25 _wrap326

第六章　定做dBASE　Ⅳ327

6.1　Config.sys327

6.2　Config.db328

6.2.1　设置命令328

6.2.2　内存块长分配333

6.2.3　功能键334

6.2.5　颜色设置335

6.2.4　SET　命令335

6.3　DBSETUP　工具菜单338

6.3.1　显示磁盘利用率338

6.3.2　测试磁盘性能339

6.3.3　查看系统配置339

附录A：错误信息341

附录B：dBASE　Ⅳ技术指标373

附录C：样本文件376

附录D：文件扩展名382

附录E：数据库（.dbf）文件的结构385

附录F：打印驱动程序387

附录G：ASCII字符编码表392

附录H：dBASE Ⅳ与dBASE Ⅲ PLUS的区别396