Interbase , InterBase/FireBird, .
: IBProvider, InterBase Express (IBX), Devrace FIBPlus.
IBProvider (OLE DB for InterBase) , . IBProvider - API InterBase. , OLE DB- . OLE DB , , IBProvider.
IBPrvider :
- InterBase, 4. InterBase 6 FireBird Yaffil. gds32.dll InterBase 4;
- InterBase;
- . , ;
- SQL-. , 64- ;
- SQL, ;
- , , .
InterBase Express (IBX) Delphi C++ Builder, InterBase. FreeIBComponents Borlabd Delphi/C++ Builder Enterprise Edition.
IBX :
- ;
- ;
- ;
- .
Devrace FIBPlus Borland Delphi 5-7, C++ Builder 5-6, Kylix 3, InterBase FireBird InterBase API. FIBPlus , .
FIBPlus:
- InterBase, InterDase 4.0 FireBird 1.0;
- db- ;
- ;
- . TpFIBDataSet 30-40% TIBDataSet IBX, 60-70% ;
|
|
|
- : , , , .
Delphi 7 IBX, FireBird. IBX FireBird, , . IBX FireBird Borland FireBird, .. FireBird InterBase .
IBProvider FIBPlus , .
FireBird 2.1 Devrace FIBPlus -, Delphi 3-7 FireBird .
FIBPlus . 1 FIBPlus. BDE. Table Query. FIBPlus - pFIBDataSet pFIBQuery, SQL.
2 FIBPlus Services. Services API, InterBase 6. , InterBase Firebird.
1. FibPlus
| pFIBDatabase | |
| pFIBDataSet | dataset . |
| pFIBTransaction | . |
| pFIBQuery | SQL. |
| pFIBStoredProc | . |
| pFIBUpdateObject | SQL- , pFIBDataSet. |
| DataSetsContainer | dataset. |
| pFIBErrorHandler | . |
| pFIBStatistic | . |
| SibFIBEventAlerter | InterBase. |
| FIBSQLMonitor | SQL-, . |
2. FibPlus Services
| pFIBServerProperties | . |
| pFIBConfigService | , sweep-, , . (shadow). |
| pFIBLicensingService | . |
| pFIBLogService | - . |
| pFIBStatisticalService | , OIT, OAT, . |
| pFIBBackupService | . |
| pFIBRestoreService | . |
| pFIBValidationService | . |
| pFIBSecurityService | , . |
| pFIBInstall | InterBase Firebird. |
| pFIBUninstall | InterBase Firebird. |
FIBPlus - , InterBase / Firebird. . FIBPlus - , . SQL- . . FIBPlus InterBase Firebird , .
|
|
|
FIBPlus - Delphi, C++ Builder Kylix, InterBase Firebird. FIBPlus API , pFIBDataSet TDataSet Delphi, C++Builder Kylix.
FIBPlus , db- , TDataSet-TDataSourse. , , FIBPlus FireBird, .
Delphi 7 FIBPlus.
:
: SYS$USERS ( ), FST_MAILLOGIN ( ). , , , . , , , . .
: FST_MESSAGE ( ), FST_L_PERSDATA_MESSAGE (- ). .
8 , 3 :
1. , ;
2. ;
3. .
: X_SOURCE (). : FST_PERS_DATA ( ), FST_FROM ( ), X_EDUCATION ( ). : STU_KL_SPECIALIZATION (), STU_KL_FACULTY (), FST_FPROF (- ) STU_KL_PAY_FORM ( ). , , .
.
, . (), , . 3.
|
|
|
3. .
| ID_USER | ||
| NAME_USER | ||
| FULL_NAME | ||
| PASSWORD_NAME |
. , , , SMTP, , . 4.
4. .
| ID | ||
| AUTHENTICATIONTYPE | ||
| HOST | ||
| USERNAME | ||
| MAILLOGIN | ||
| PORT | SMTP | |
| USER_ID | ||
| PASS |
4.3.
. , , , , , . 5.
5. .
| ID | ||
| THEME | ||
| TEXT | ||
| ENCLOSURE | ||
| USER_ID | ||
| DATE_CREATE |
4.4. -
- . . 6.
6. - .
| PERS_DATA_ID | ||
| MESSAGE_ID | ||
| DATE_SEND |
4.5. ,
. , . 7.
7. , .
| ID | ||
| SOURCE | ||
| DATE_CREATE |
4.6.
. , , , , , , , , , , email, , , , , , , , . 8.
8. .
| ID | ||
| SURNAME | ||
| NAME | ||
| SECOND_NAME | ||
| SEX | ||
| HOSTEL | ||
| SOURCE_ID | ||
| EDUCATION_ID | ||
| EDUCATION_LIVING | ||
| PAY_FORM_ID | ||
| HOME_PHONE | ||
| MOBILE_PHONE | ||
| DATE_REG | ||
| NAME_EDUCATION | ||
| USER_ADD | ||
| FROM_ID | ||
| BERTHDAY | ||
| DIRECTING | ||
| REPEAT |
|
|
|
4.7.
, . , . 9.
9. .
| ID | ||
| GFROM | ||
| SYS$DATE | ||
| SYS$USERS_ID |
4.8.
, . 10.
10.
| ID | ||
| EDUCATION |
4.9.
. 11.
11.
| ID | ||
| NAME |
4.10.
. . 12.
12.
| ID | ||
| FACULT_ID | ||
| NAME | ||
| CODE |
4.11. -
- , . . 13.
13. -
| SPEC_ID | ||
| FST_PD_ID | ||
| FACULT_ID | ||
| ID |
4.12.
. 14.
14.
| ID | ||
| DESCRIPTION |
1.
.1
