     11 

          

      

      ,   Delphi,     
   .  . Database Explorer 
(  ),     Delphi.  
, Data Dictionary ( ),    Professional- 
 Client/Server- Delphi.   SQL Monitor    
  Client/Server. 

     Database Explorer 

     Database Explorer     ,  
      .  
   ,   ,     
Windows Explorer (). 
     Database Explorer      
   Delphi.   Desktop      
   ( Paradox  dBASE),    Professional  
  ,    ODBC        
Local InterBase Server.   Client/Server  Explorer   
   Professional,     SQL- 
   SQL Links.  "Explorer"    
'Client/Server    "SQL Explorer",   , 
 ,   SQL,   .   
      Client/Server   Explorer, 
    . 

      Database Explorer 

    ^      ,  ||     Database 
Explorer         . 

      Data Dictionary 

     ,   Data Dictionary     
         . 

      SQL Monitor 

         SQL Monitor,   , 
       . 

    283 


    . 11.1.  Database Explorer 

     Explorer     (. 11.1).    
     ,   
 BDE,          .  
,   ,      
     . 

      

            ,  
   Borland Database Engine (BDE).   
 DBDemos, DefaultDD  IBLocal (   Professional  Client/Server). 

      

      ,        
    New   .      
 ,        .  
BDE    SQL Links    ODBC 2.0, 
   .      "^" 
  -    ,    
. 11.1.          
  .         
     Apply     Apply  . 

        

         ,      , 
   ,      (  SQL- 
  ODBC).      Explorer ,   
   ,   -    
    .  ,   . 11.1  
    DBDemos  IBLocal.     
     - .    
  ,     Explorer   
,          Close  
 . 

    284  III.     


        

       Explorer    ,   
  ,     .  . 11.1, ,  
,     DBDemos   ,     
IBLocal , , , , , ,  
 BLOB-. 
       Explorer       
   .        
   .  . 11.2    
 ORDERS . DB,        
 DBDemos.         
    , ,   , 
   ..        
  . 

    . 11.2.     

     . 11.1     ,    
           . 
 Explorer       ,   
  ,   INI- DBX. DBI,   DELPHI 3\BIN. 

     11.1.         

         

    dBASE, Paradox  
    DB2 
     , , , ,  , , 
   
    Informix , ,    
    InterBase 
    , , , , , ,   BLOB- 
    MS Access  
    MS SQL 

     , , , ,  , , 
, , ,    

     11.       285 


     . 11.1 

                      

    ODBC                           
    Oracle                          , , ,  
, ,  , , ,  
  
    Sybase                          , , , , 
 , , , , ,    
    

    . 11.3.    LIBS 

       ,     SQL-,  
     .       
,       Tables,   
   .  . 11.3   
  PARTS,     LIBS,   
  IBLocal.      ,   
 ,      ?    SQL 
   ,   ,  , 
   ,     . 

      

         ,    
.          
 ,         , 
    .    Definition 
(), Text (), Data ()  Enter SQL ( SQL). 

    286                                      III.     


     Definition 

         ,   
 .         
 .    . 11.1,    BDE 
(, IBLOCAL),  Definition    BDE  
 .    ,    Definition  
  ,    . 11.2. 
      ,    Definition, 
 .   ,     
^   Enter SQL    
"?'|^' .   
BDE-''^   ,      
 ( ,       
 ).                   ' 
      Definition,    ,  
  ( ),  ,   
,   . 

     Text 

          Client/Server Explorer.   
,        .  
    SQL     Text. 
            
 .     ,  
 SQL   Text   ,       
Enter SQL. 

     . 11.3   Text   PARTS  IBLocal. 


     Data 

     Data     Explorer     
    .     , 
        BLOB,  
  Memo-.    ,    
View^Blob Explorer        Memo-  
 Data.  . 11.4   Data  Blob-   
 BIOLIFE . DB     DBDemos.asai. Expioiei 

    . 11.4.   Database Explorer     Blob- 


     11.       287 


     Enter SQL 

     Enter SQL    Developer-  Client/Server- 
Delphi.     SQL    .   
    ,   ,  , 
      ..   SQL- 
          Execute Query 
(   ). 
       SQL-,  ,   
SELECT, Explorer       . 
   ,    
tion^Query,      Query Options,    
  Request live queries. 

    . 11.5.      Database Explorer 

            
 .      ,   
          
     ,     .  
. 11.5   Enter SQL,      
SELECT      CUSTOMER   IBLocal. 

     Data Dictionary 

     Data Dictionary ( )     
Delphi Developer  Client/Server.   Data Dictionary   
 Database Explorer,   Dictionary   . 
 Data Dictionary     
 -    .   - 
  ,   "   
1<,   ,     
.  : 11.6  .7     Data 
Dictionary.  Data Dictionary     : 
Databases  Attribute Sets. 

    288  III.     


    Sf SQL Exploiei 

    . 11.6.  Data Dictionary     


     Databases 

      Databases    BDE-,  
,   ,    Dictionary.   Data 
Dictionary   DBDemos.      
,       ,    
 Dictionary^lmport from Database.       
Import Database,    BDE-,    . 
     . 11.7    ,    . 
,     Explorer    
Definition.     Definition  Attribute 
Set.          Attribute 
Set.  ,   . 11.6  Discount  ITEMS 
   Percent. 

     Attribute Sets 

      Attribute Sets      
(attributes) .   ,    
: ,    , , 
  .. 
              
  ,        ,  
          . 
   ,    
      . 
     . 11.7    Percent  Attribute Sets.  
 Definition        
 .     ,  Based 
On.           
  ,     - 
.    ^ ,   
. "  . ,  TaxRate   
 Percent ^. 

     11.       289 
    10  Delphi 3.   


    . 11.7.  Data Dictionary     

          Database Explorer 

       ,    Database Explorer.   
    Attribute Sets  ,   
 ^^^     Object^New. 
         ^ Alignment 
(). Readonly (  ). Required ()  
Visible ().  ,    TControlClass,  
 Delphi   ,  ,   
        . 

         Delphi 

         Delphi   
 TField,        . 
      TField   
 (Fields Editor)    ,    
      Save attributes   
.                    
       Delphi        
.           
Associate   .       
,    Data Dictionary. 

     SQL Monitor 

     SQL Monitor     Delphi Client/Server  
    Delphi 2.0.       
  .      
 BDE   DLL     .   
 ,    , , , 
  ..     -   ,  
Delphi   ,   . 

    290  III.     


      Monitor 

     Monitor     ,    .  
 ,     :  
 SQL Monitor    BDE,   . 
   SQL Monitor   Delphi IDE   
Database, SQL Monitor.   ,     
Delphi 3.0. 
           Clients   Clients  
   ,     .  
   BDE (   ),   
 .      . 

    . 11.8.  SQL Monitor 

     . 11.8  SQL Monitor    , 
  Explorer  . 11.5.   SELECT   
  .        
.      ,     
     . 

      

         ,    
   .  , 
  . 11.8,      .  
  ,  ,      
,   .  . 11.2  11  , 
  .   ,    Trace 
Options    Options^Trace Options. 

     11.2.    SQL Monitor 

      ^ 

    Prepared Query Statements      
    Input Parameters        
    Fetched Data  ,    


     11.       291 


     	 

    Executed Query Statements	     
    Statement Options	  ,   ALLOCATE, 
PREPARE, EXECUTE  FETCH 
    Connect/Disconnect	,        
   
    Transactions	,    
    Blob 1/0	  Blob- 
    Miscellaneous	  
    Vendor Errors	  ,  .   
   ,     
    Vendor Calls	 API-    DLL  


      

      SQL Monitor      
.    ,    Delphi 2.0,  
      .  
    (?)    SELECT,   
        ,  ,  
  . 
     . 11.9         
 Delphi,      , ,  
  ,   : 

    select * from CUSTOMER where CUSTNO > :pl      
    2000. 
    ISQLMomtoi 

    . 11.9.       SQL Monitor 


    292                                                 III.     


      

           .  
 ,   ,    
     .     
      .    
   ,  Time Stamp ( )   
   ,      . 
         , 
   ,    ,    
  BDE  .

     

     Delphi        
.  Database Explorer, Data Dictionary  SQL Monitor,   
    , , , , 
  ..,  - ,    
     DLL    . 
     -    
   . 

     11.       293 
