
              ᮡ ७ ࣠樨 ⠡
                          dBase  Paradox.

           (ਠ  ⥬᪮ ᥬ  Delphi,
   ਫ 3 ᫠  ଠ Microsoft PowerPoint - IDPT.PPT)



                              
                              (᫠ 1)

 6    㯠⥫  롮 ⮫쭮  騬
䠪஬ 뫮, ࠡ⠥- த  ⠡栬 ଠ DBF,  .
ਨ⥫ ⠪ 﫨 । 롮஬ -  ᢮ த
xBase-ᮢ⨬  ଠ ,    "᪠" ॢ襣
ଠ,  ᯮ짮 ᮡ⢥ ଠ    ᥡ 
㤭  졥  த栬 xBase. ᫨ த ࠡ⠫ 
ᮡ⢥ ଠ⮬,  稥 /ᯮ DBF 뫮
易⥫.   祭 ६ ꥬ ଠ樨 , 
孮 /ᯮ ⠭   㤮. 
   த  ,   1991  Borland
  ⮬,  ᪮  IDAPI - Intergrated Database API,
 㯠  , ஥ 㤥 ᯥ稢 㭨ᠫ  
ଠ⠬ ⮫ . Microsoft ⠪   ᪥ Open
DataBase Connectivity - 㭨ᠫ쭮 SQL-䥩  ࠧ
ଠ⠬ . ODBC  ⥪騩   ⢮ IDAPI,
..  ॠ 樮 䥩  .  쬠
⢥, ⮬  ⢮ ਫ, ᠭ 
"樮" ⨫ 쭮 ,     
।     SQL-몠.

 饥 ६ IDAPI ॠ  BDE - Borland Database Engine.
BDE ।  㭪権,     ᢫
   ᨬ   ଠ -  樮
ᯮᮡ, ⠪    SQL-ࠦ. BDE ᯮ  
᫥ த Borland - Delphi, dBase V for Windows, Paradox
5.0 for Windows, Borland C++ & Database Tools  ⠪  
⤥쭮 த.

  ⠢  த  BDE 易⥫쭮 室 
ࠩ -  ⠡ dBase  Paradox.  ᯮ짮 㯠 
 १ SQL-ࠦ  ଠ 룫 .   
樮 㯠  ᪮쪮 ⫨. Borland ਫ 
ᨫ, ⮡ ⠢ 㭪樮쭮  ଠ⮢,  १
BDE ᮤন ᪮쪮 㭪権,  ࠡ  ⮫쪮  
ଠ⮬,  ࠡ  ࠧ  ᨬ  ଠ.
饥 設⢮ 㭪権 BDE ࠡ ᨬ  ଠ
,    ⠡, ODBC-  ⠡
SQL-ࢥ (१ SQL-Link).

 ᬮਬ ଠ dBase  Paradox ⤥쭮, ⮡ 
ᮡ .  쭥襬,  ࠧࠡ⪥ ਫ,  ᠬ
 - ᯮ짮  ᮡ    .


                            ଠ dBase
                              (᫠ 2)

 ଠ ।⠢ ᮡ  ᪨ 䠩 *.DBF. 
ᯮ  浪 , ᪮   
ᥣ   䠩. ᫨   ᬠਢ   浪,
⫨筮  ⢥,    ந . 
  B-ॢ, ⠬ ண  祢
祭   ᮮ⢥ ᥩ  DBF-䠩.  ࠧ,
 ᪥  ᬮ   ,    
, ᮮ⢥騩 ⭮ 祭 ,  ⢫
롮ઠ 㦭   DBF-䠩. ᫨   祢 祭
ᯮ ᫥⥫쭮,  ᮮ⢥騥    DBF -
ந쭮,   ⠪ ᯮᮡ 㯠 ந室 
६饭  䠩  ﬨ,  ᫮  ࠡ
(ਬ FILTER  Clipper)   ⮣,   ꥬ 
 ࠡ ⭮  ணࠬ  ࠪ᪨
ᯮ (  ⮬ 砥  ⮫쪮 ).

 㤠 ᥩ ਬ ᫥騩 室 - ⮡ 
⠢ ""  䠩 ᥩ,  㤠   
ਭ ᯥ樠쭮 祭, 饥,   㤠.
  ᪫  ᬮ,  - .
᫮,  ।⢠, 騥 ᬠਢ ⠡  
㤠묨 ﬨ,  ⠪ ⠭  (⬥ 䫠
㤠).

 ᥩ  ᮮ⢥騬 䨧᪨,  ᫨ 㤠
 N 5,   ᬮ     ࠬ 4  6.

 㯠 ⠡ 㤠   ﬨ,
室騬 ᫥   浪. ..  ६⨫ (
  䨧᪨ 浪 ),   㦭
ந.

 १, ਥ ணࠬ   ᥩ DBF-䠩 
⪨ -  ᥩ   易  ᮤন ᥩ, 
  ᫥ 㯠 䠩.  堭  BDE 
ଠ DBF ᯮ   ᥩ, ..  ⠡ 
祭 ᥠ ࠡ,     ᯮ㥬 .

 樨 ᫥ ᮡ⥩ ᬮ ਬ EX1.DPR.


                           ଠ Paradox
                              (᫠ 3)

 ଠ  ᯥ樠쭮 ࠧࠡ⠭  ⮫쭮 ,
ᯮ饩 ࠢ () ५樮  .  ⨬
ࠢ ⠡   ࢨ , 㭨쭮
騩 . ,   ࢨ筮  -
। ᪫祭.

 DB  ࠭ ࣠ -  । 
࠭栬 () 䨪஢ ࠧ (1, 2  4 ),  
稨 ࢨ筮  ஢  浪 . ࢨ
 室  ⤥쭮 䠩 (*.PX)  ᮤন  ⢥
⮢ 祢  ࢮ    DB-䠩  
⮣ .  ࠧ,   祭 ࢨ筮  
  B-ॢ -  室 ࠭  䠩 PX,  ⥬
㦭   ࠭ DB-䠩.

  ⠢ ᥩ ந室 ᥣ  ࠢ 
-  浪 ࢨ筮 .  㣨 ᥩ  ⮬ 
,  ࠤ쭮     ॡ, .. 
࠭ ⮫쪮 뫪  ࠭,    ᠬ  ( ⮬
䠩 PX  ࠧ   ࠧ ᮮ⢥饣 䠩
DB).  㤠   㤠,  ᫥騥  
࠭ ७   . ࠭    ந,
᫨   ᫥  ࠭,     
ࢨ筮  ࠭  ଠ  ⢥ ᥩ  ⮬
, ⮬ ⠭ 㤠  -ࠢ 㤥
.

    ஥ ⮫쪮  稨 ࢨ筮,
..  ᭮뢠  ࢨ筮 .  饬 ࢨ 
।⠢ ᮡ  DB-PX, ⮫쪮  㣨 ७
(x??-y??,   xg?-yg?),  㣨 .
  筮  ᮤঠ:  ࢨ  - 
( ),  ஬ ஥   +  ࢨ筮
 ᠬ ⠡ (DB),      ⠡ (. 
  ).

 ᬮ ⠡  筮  冷 ᥩ ।
 ( ),  ஬ ஥ .  祭 
 䠩 DB  筮  롨ࠥ 祭 ࢨ筮
  DB-䠩,   ⮬ 祭 ந室   PX, 
⥬   DB-䠩. ᬮ  ,    ⥫쭮 
६ 樥, 롮ઠ ᥩ ந室 筮 .

  뢠  ⨯ - ⮬᪨  
(maintained  nonmaintained).  ⮬᪨   , 
ࠨ   䨪樨 ⠡. ᪮  
⮬᪮  뫠      ,  
ᯮ,   ன    ଠ樨 
ந室  饭  DB-䠩.   
뫮  ࢨ    ࠭ ।⢥ 뫪 
  䠩 DB.  १   ᢫ 祭
 ,  ⠭ "ࠪ묨"   䨪樨
⠡.     ⨢ ᪠ 
ਮ᪨ 䨪 ᯮ짮 ⮬᪨ ,
ࠨ  ᪮쪮  ࠡ  ,  
 䨪権 (㯯 ᥩ) ᯮ짮 
,  "⪫"  ६ 䨪樨  
ࠨ  ࢮ ᪠  ⠪ .

ᬮ  ,   ଠ Paradox    ⠡
ࠨ  ⮬᪨  ( ࢨ), 
  ࠡ ⮫쪮, ᪮쪮 .   ⮬, 
   ࠭  筮 ,   ⮣,
᪮஢  , ᨬ쭮  ஥ ᮢ
(ਬ  ᫮ ).  DBF-ଠ  ࠭ 
ப ।⠢,  ⮦   ந஢ 
८ࠧ,       ᪥,   
ॡ  室 . ਬ ᫮, ࠭  DB  8
 (numeric),  DBF 﫮-  18 .

襮ᠭ ࣠ 䠩    ᮢ ਢ
 ⮬,  冷 ᯮ ᥩ (  㬥) 㤥
  ⮣ ,  ஬   ⠡. ਬ,
᫨ ६   ⠡   ࢨ筮   
筮 ,      ࠧ   
  ।⠢.


㬥 ᥩ  浪 ⥪饣  㤭  ⪮,
  १ 䨪 ⠡ ந室 . 
⠡ ⮫쪮  ⭮ , ..   祭
⥪饣 ,     (  ⠡  
 ,   ६   㯠 DBF  ⠭ 
㠫묨).

 樨 ᫥ ᮡ⥩ ᬮ ਬ EX2.

  ᮡ "" ଠ Paradox  ⮬,  
 ᯥ稢 ᥬ  뫮 楫⭮ 
 ஢  IDAPI (BDE). 筮 ।  ᮧ 
ਧ樨 ⠡ 㭪 Validity Checks  Referental
Integtity,  BDE 㤥 ᠬ ᫥ ࠢ쭮 祭 
⠡ ᨬ  ⮣,  ᯮᮡ  뢠  ⠡
(  室  䠩 *.VAL). Validity Checks ᯥ稢
஫ ᨬ쭮, 쭮, 㬮⥫쭮 祭 , 
⠪ ᮮ⢥⢨  祭 ஬ 蠡. Referental
Intergity  ⠭   ﬨ ⠡ (master-
detail),  㤥 ஫஢  祭 易  
᫨ ਫ 뫮 ᥣ   易 ⠡ (. 
  稪  ⠡ 稪  㤥 ४⭮
   易  ⮩  ᥩ  ⠡ ).

 ᢮⢠ (ࢨ , ஫ , ஫
뫮筮 楫⭮)  ਡ ஢  
ᯮ짮 ⠡ Paradox  ஢   SQL-ࢥ,
  ᫥騩 ७  .
ଠ DBF ⮬  ᯮᮡ    , ⮬ 
 ᥣ   ணࠬ⮢, ࠡ⠢  Clipper, 
஡  室  SQL-ࢥ 孮.


襮ᠭ ଠ ஬ ⮨     䥪⮢.
  ,    ⠫ - ࠭筠 ࣠
DB-䠩:
 ᮧ ⠡, BDE 롨ࠥ ࠧ ࠭ ⨬
ࠧ  ࠧ  ( ⠪   ᥪ ࠭
࠭,  ᫥⥫쭮   4).  ⨬,   
稫 ⠡  ࠧ஬ ࠭ 2. ⥬, ᫨
ਧ஢ ⠡,     , ࠧ
  ॢ 騩 ࠧ ࠭  ⠡ 
㤥 ਧ஢ (ᮮ饭  訡). 稭 ⭠ -
騩 ࠧ ࠭    .

 ⠪  室 ᮧ ᮢ襭  ⠡,
᪮஢    ன (borrow),  㦥 ⮬ 
  -  ᮧ ⠡ 㤥  ( ) 
ࠧ ࠭. ᫥ ᥣ  ७    
⠡.

 ,  ࠭ ⢮ ஡ ⠭
ᯮ祭  -  뫮  ⮫쪮   Paradox 5.0
for Windows -  ᮤন TUTILITY.DLL,   ண 
ࠢ ⠡.  ஬  祭 娢 
TUTILITY.DLL, 䥩ᮬ ᯮ짮 (4   Delphi) 
ணࠬ-ਬ஬.


                             祭

  ଠ⮢   ⮨⢠,  ⪨.  BDE
(IDAPI)    ଠ,     , 
३    㣮.

DBF   ᮢ⨬ ࠪ᪨  ᥬ xBase-த⠬, 
࠭稢  롮 ⨯   ࠭ .

DB   ଠ⮬, .. ஬ ⥪ Borland 祣 
⨬ ଠ⮬ ࠢ쭮  ࠡ⠥.  DB ।⠢ ப
 ⨯    BLOb  ந 㯮  
 BLOb, ஫ 뫮筮  ᥬ᪮ 楫⭮  
஢  BDE.

,       ᮡ 
ଠ⮢,     ᢮ ணࠬ.



ਠ   Borland InterBase ⮢ 쬥 ਩,
㤭  , .㣠.

p.s.  ࠡ  ᯨ᪠ BDE,  ⮬ ᫥ ValChecks 
RefIntegrity,     BDETABLE.PAS,   
ਬ  Delphi (Z:\DELPHI\DEMOS\DB\TOOLS).  BDETABLE
 ᬮ    ⠫  ਠ ⮣ ᥬ.



