DataModule2 , 3. 1
DataModule2
, IBDatabase1 IBTransaction1. DefaultAction IBTransaction1 TACOMMIT, . , , . , "IBTransaction1->Commit ()". , .
Transaction Editor Read Committed. DatabaseName, DefaultTransaction IBDatabase1 DefaultDatabase IBTransaction1. .
IBDatabase1
IBTransaction
.
, .
MainMenu, .
, . DBGrid, DataModule2 .
.
3. 6.
, "".
, , , : Button - Edit - , . . .
.
.
.
- .
.
, 3. 11.
.
|
|
1.
1. Button1 , . |
void __fastcall TForm1:: Button1Click (TObject *Sender) {DataModule2->INS_TOV->ParamByName ("NO_TOV") - >AsString=Edit1->Text; DataModule2->INS_TOV->ParamByName ("NO_USTR") - >AsString=Edit2->Text; DataModule2->INS_TOV->ParamByName ("NO_PROIZ") - >AsString=Edit3->Text; DataModule2->INS_TOV->ParamByName ("MODEL") - >AsString=Edit4->Text; DataModule2->INS_TOV->ParamByName ("SERIALNO") - >AsString=Edit5->Text; DataModule2->INS_TOV->ParamByName ("PARTNO") - >AsString=Edit6->Text; DataModule2->INS_TOV->ParamByName ("CENA") - >AsString=Edit7->Text; if ((Edit1->Text=="") || (Edit2->Text=="") || (Edit3->Text=="") || (Edit4->Text=="") || (Edit5->Text=="") || (Edit6->Text=="") || (Edit7->Text=="")) { ShowMessage (" "); Form1->Repaint (); } else { DataModule2->INS_TOV->Prepare (); // DataModule2->INS_TOV->ExecProc (); // DataModule2->IBTable1->Close (); DataModule2->IBTable1->Open (); // Edit1->Clear (); // Edit2->Clear (); // Edit3->Clear (); // Edit4->Clear (); // Edit5->Clear (); // Edit6->Clear (); // Edit7->Clear (); // DataModule2->IBTransaction1->Commit (); DataModule2->IBTable1->Close (); DataModule2->IBTable1->Open (); // ShowMessage (" "); }} // --------------------------------------------------------------------------- void __fastcall TForm1:: Button2Click (TObject *Sender) {DataModule2->UPD_TOV->ParamByName ("NO_TOV") - >AsString=Edit1->Text; DataModule2->UPD_TOV->ParamByName ("NO_USTR") - >AsString=Edit2->Text; DataModule2->UPD_TOV->ParamByName ("NO_PROIZ") - >AsString=Edit3->Text; DataModule2->UPD_TOV->ParamByName ("MODEL") - >AsString=Edit4->Text; DataModule2->UPD_TOV->ParamByName ("SERIALNO") - >AsString=Edit5->Text; DataModule2->UPD_TOV->ParamByName ("PARTNO") - >AsString=Edit6->Text; DataModule2->UPD_TOV->ParamByName ("CENA") - >AsString=Edit7->Text; if ((Edit1->Text=="") || (Edit2->Text=="") || (Edit3->Text=="") || (Edit4->Text=="") || (Edit5->Text=="") || (Edit6->Text=="") || (Edit7->Text=="")) { ShowMessage (" "); Form1->Repaint (); } else { DataModule2->UPD_TOV->Prepare (); // DataModule2->UPD_TOV->ExecProc (); // DataModule2->IBTable1->Close (); DataModule2->IBTable1->Open (); // Edit1->Clear (); // Edit2->Clear (); // Edit3->Clear (); // Edit4->Clear (); // Edit5->Clear (); // Edit6->Clear (); // Edit7->Clear (); // DataModule2->IBTransaction1->Commit (); DataModule2->IBTable1->Close (); DataModule2->IBTable1->Open (); // ShowMessage (" "); }} // --------------------------------------------------------------------------- void __fastcall TForm1:: Button3Click (TObject *Sender) {DataModule2->DEL_TOV->ParamByName ("NO_TOV") - >AsString=Edit1->Text; if (Edit1->Text=="") { ShowMessage (" "); Form1->Repaint (); } else { DataModule2->DEL_TOV->Prepare (); DataModule2->DEL_TOV->ExecProc (); DataModule2->IBTable1->Close (); DataModule2->IBTable1->Open (); Edit1->Clear (); DataModule2->IBTransaction1->Commit (); DataModule2->IBTable1->Close (); DataModule2->IBTable1->Open (); // ShowMessage (" "); }} |
|
|
Web-
ibase_connect (). " " , 2. $query, - $result, . .
2. |
<html> <head> <title></title> </head> <body bgcolor="E0FFFF"> <table align="center"> <td> <a href="INDEX.html"> </a><br> <table align=center border="0" cellpadding="0" cellspacing="0" class="tbl1" width="850" height="100" bgcolor="008B8B"> <td> <center> <font> <h2><font color="white"> <br> <br><i>""</i></h2></font> </td> </table> </td> </table> <table align="center" bgcolor="white"> <td> <? php $host='172. 23. 64. 64: // home/ftp/10/1410028/G141001_YUSHCHENKO. FDB'; /*$host='knit-614-01: D: /DB/G141001_YUSHCHENKO. FDB'; */ $dbcharset = 'WIN1251'; $usname = 'sysdba'; $pswrd = 'masterkey'; $db = ibase_pconnect ($host, $usname, $pswrd,$dbcharset); if (! $db) {echo ' '; exit; } $query="select * from TOVAR"; $result=ibase_query ($query); echo '<table border=1>'; echo '<tr><th bgcolor=\"#CCCCFF\"> </th>'. '<th bgcolor=\"#CCCCFF\"> </th>'. '<th bgcolor=\"#CCCCFF\"> </th>'. '<th bgcolor=\"#CCCCFF\"> </th>'. '<th bgcolor=\"#CCCCFF\"> </th>'. '<th bgcolor=\"#CCCCFF\"> </th>'. '<th bgcolor=\"#CCCCFF\"> </th>'. '<tr>'; $i=0; while ($row=ibase_fetch_row ($result)) {$i++; echo "<tr><td>$row [0] </td> <td>$row [1] </td> <td>$row [2] </td> <td>$row [3] </td> <td>$row [4] </td> <td>$row [5] </td> <td>$row [6] </td><tr>"; } echo "</table>"; ibase_free_result ($result); ? > </td> </table> </body> </html> |
|
|
, Web- Firebird 2.