

 1

 11

 1.   Delphi ? 12
     Delphi? 12
     14
    15
       16
    17

 2.   19
    19
       Delphi 21
      23
    Database Form Wizard 23
      28
       30
       35
    TDatabase 35
    BDE 36
     39
      "" 42
    46
    ... 46

 3.   47
       47
    Delphi 47
   (  program 48
    uses 49
    $R 49
   Application.CreateForm 49
   Application.Run '- 49
    49
     ^ 50
    interface 51
    implementation 51
      52
    initialization 52
    finalization  52
    52
     54
     54
    55
    56
    ... 56


 723

 4.  57
       Object Pascal 57
    57
    58
    58
     59
    59
    62
    62
    62
      62
       Object Pascal 63
    if-else 63
    begin-end 63
    64
       64
    65
     66
     67
    67
    68
    68
       68
    69
    69
       69
    70
       70
      70
    70
    71
    71
    71
    ... 74

 5. SQL    75
      76
     SQL 76
    76
      - 77
     77
     78
    SELECT 79
     '. 87
       87
    CONNECT , 88
    UPDATE * 88
    DELETE 88
    COMMIT  ROLLBACK *"* 88
    89
    ... <> 89

 6.     / 90
       90
        91
       91
      / 92
     / 93

724 

       93
      94
      94
          95
   CASE- 95
       99
       109
       125
    140
    ... 140

 7.    / 141
          142
         142
      143
       143
     145
        145
      145
     145
     145
     146
     146
      150
     151
      152
     152
            155
     156
    156
    ... 156

 II
     157
    8.    / 158
      159
      159
          160
       160
     "-" 164
       171
      ' 180
     180
      RENTMAN 180
    181
    ... ^ 181

 9.  182
      RENTfet^ 182
     ' 182
          183
      185
     Delphi 185
       186
     BDE 186
      188

 725

      188
      191
     199
    204
    ... 204

 10.     205
     Delphi   Silverrun-RDM 205
          205
      207
      209
     209
    EMPLOYEE Quick Entry/Edit Form 210
        Database Form Wizard 210
      211
        212
          213
       213
      214
    Work Type Quick Entry/Edit Form 214
    216
    ... 216

 11.   217
    TENANT 217
      218
       218
     220
      220
    RENTMAN     221
       224
     TENANT 225
      225
    PROPERTY 226
       226
       PROPERTY 227
         228
      228
      228
     PROPERTY 228
    LEASE 229
      230
       LEASE 230
      231
     LEASE 232
    WORDER ^ 233
     233
    WORDER  "" 239
         243
       Query Builder 246
    -,^ 249
    CALL '" 251
     251
     254
    258
    ... 258

726 

 12.   259
       Delphi 259
     259
   - Work Order 260
         260
    Print 261
    Object Browser 262
      ? 263
      264
       264
      - 264
    - 265
     PROPERTY Listing Report 265
       267
        268
     TaskListlClick 271
      TaskListlClick 273
      273
    273
    ... 274

 13.   275
      275
         277
      278
        278
        279
      &^>
        287
    -  287
      288
      289
      About 291
       293
      293
    294
    ... 294

 14.  295
     295
        296
      297
       297
       301
     303
    ^ 303
    ... 304

 III

 ^ 305

 15. Microsoft SQL Server 305
    SQL Server 306
      306
      307
         Microsoft SQL Server 307
     BDE 308
  
 727

      BDE 309
   APPLICATION NAME 309
   CONNECT TIMEOUT 309
   HOST NAME 309
   NATIONAL LANG NAME 309
   TDS PACKET SIZE 309
   DATABASE NAME 310
   BLOB EDIT LOGGING 310
   MAX QUERY TIME 310
    SQL 310
      310
    USE 311
     311
    312
     313
     313
    UPDATE "" 314
    DELETE 314
     314
    SELECT 315
   GROUP BY 318
   HAVING 318
   ORDER BY 318
     319
     319
    319
     320
    323
    324
    325
    ... 325

 16. Oracle 326
     326
      326
     BDE 327
         Oracle 328
    SQL 329
      330
    CONNECT ' 330
     330
    332
     333
     '- 333
     333
    UPDATE ^ 334
    DELETE 334
     334
    SELECT '* 335
   GROUP BY 338
   HAVING ^.. 338
   ORDER BY '"* 338
     338
     339
    339
     340
    341
    341
  

728 

    342
     342

 17. InterBase 343
     343
      343
     BDE 344
         InterBase 344
    SQL 345
      346
    346
    CONNECT 347
     347
    350
     351
     351
    UPDATE 352
    DELETE 353
     353
    SELECT 353
   GROUP BY 357
   HAVING 357
   ORDER BY 357
     358
     358
    358
     359
     361
    361
    362
    363
      InterBase 365
      365
      365
      366
      367
       368
      369
      369
     - 370
    370
    ... 370

 18. Sybase SQL Server 371
     371
      371
    422  Net Library/Open Client   Windows NT 371
     372
   SYBPING -*. 372
    Windows . 373
     BjQE 373
     ^ BDE 374
   APPLICATION NAME 374
   CONNECT TIMEOUT 374
   HOST NAME 374
   NATIONAL LANG NAME 374
   TDS PACKET SIZE 374
   DATABASE NAME 375
   BLOB EDIT LOGGING 375


 729

   MAX QUERY TIME 375
      Sybase SQL Server 375
         Sybase 375
    SQL 376
      376
    USE 377
     377
    378
     379
     379
    UPDATE 380
    DELETE 380
     381
    SELECT 381
   GROUP BY 384
   HAVING 384
   ORDER BY 385
     385
     385
    386
     386
    390
    390
    392
    ... 392


 IV
   393

 19.  394
     394
     EMPLOYEE . GDB 394
    Customer List Report 394
    Customer Group Report 397
     "-" 399
     401
     403
         407
      408
   QRChart 408
   DecisionGraph 409
     411
    ' 412
    ... 413

 20. -     414
    - ^ 415
    -   416
        416
     ^^  417
        417
        418
     -     419
     -     419
    -   419
       419
      420


730 

      421
     421
       421
    422
    422
     422
    423
    ... 423

 21. -   424
    - 425
      - 425
      425
      426
    426
    TField  - 427
      427
       427
    -   TField 428
      - 429
   OnNewRecord 429
   BeforeDelete 430
   BeforePost 430
    431
    ... 431

 22.     432
   Remote Data Broker 432
     434
       434
       435
    436
    ... 436

 23.     437
     437
        437
       438
        TDatabase 438
    Translsolation      439
       SQL 439
      442
      442
      443
       445
      ,     445
      446
    447
    ... '* 447

 24.    SQL 448
   DDL  DML ^^ 449
     DDL 449
     449
       449
    450
      451
    452
     454

 731

     456
    457
     458
    459
    460
     DML 460
   SELECT 460
     461
    461
   - 461
     461
   SELECT INTO 462
   INSERT 462
   DELETE 462
   UPDATE 463
    463
    SQL 464
    SQL 464
    466
    476
    ... 476

 25.    / 477
     " " 477
      477
      477
      478
      478
        478
      SQL 480
    TField 484
      484
   DBText       484
       484
      490
      490
     491
      494
    495
    ... . 495

 26. Borland Database Engine 496
      BDE  ODBC 496
    , 497
      497
      498
     ^ 498
     498
     BLOB^. 498
    498
     498
    SQL ^^. 498
    Restructure "^ 498
      499
      499
       499
     499
     SQL 499
     499


732 


     499
      499
      BDE 499
     500
     BDE 500
         BDE 502
     BDE   Delphi 505
       508
        BDE 509
     512
    BDE 513
      BDE   SQL 513
    514
    ... 514

 27.     s\s
        515
   TArrayTable 516
        519
   TLiveQuery 520
    CreateViewSQL 522
    DropViewSQL 522
    TableNameFormat 522
    524
    524
    SetQuery 524
    CreateTemporaryView 525
    DoBeforeOpen 526
    DropTemporaryView 526
    DoAfterClose 526
    TDBNavSearch 529
    ZoomDIg 542
       549
      ZoomDIg 549
    550
    ... 550

 28.     Internet 551
     : Web- 552
      554
     :   Web- 560
      561
     563
     Web- 567
     Web- 572
     :  ActiveForm 573
     573
     575
     576
     :    578
     :       590
    "'"^ 611
    ... 611

 29.   612
     ,    612
       612
         612


 733


         613
         613
     613
     614
     InstallShield  Delphi 616
       618
       619
       621
       621
      621
    621
     622
     623
   ,  623
     624
     InstallShield  Delphi 626
       628
       631
       632
       632
      632
     633
      633
       633
    634

 . Delphi    635
     C++ 635
        Object Pascal   636
    1 636
    2 637
    3 637
     Windows ' 639
     639
    4 643
    5 644
          DLL 644
    646
PowerBuilder 646
     646
     648
    655
Visual Basic  Access 655
     655
     "'' 665
    669
 xBase: dBase, Clipper, FoxPro   670
       670
    ^ 670
     673
    :  674
      '^^Si^ - 679
       679
    679
      679
      680
    681
    681


734 