TQuery의 묵시적 transaction 을 줄이기 위해.(cachedUpdate : false => true 로 전환)
unit test5; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, DB, DBTables, StdCtrls, Grids, DBGrids, ExtCtrls, DBCtrls; type TForm1 = class(TForm) Query1: TQuery; DataSource1: TDataSource; DBGrid1: TDBGrid; Edit1: TEdit; Button1: TButton; DBNavigator1: TDBNavigator; Button2: TButton; Button3: TButton; procedure Button1Click(Sender: TObject); proc..
DB 검색하기..
unit test2; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, ExtCtrls, DBCtrls, Grids, DBGrids, DB, DBTables, StdCtrls; type TForm1 = class(TForm) Query1: TQuery; DataSource1: TDataSource; DBGrid1: TDBGrid; DBNavigator1: TDBNavigator; Edit1: TEdit; Button1: TButton; Edit2: TEdit; procedure Button1Click(Sender: TObject); procedure Edit1KeyPress(Se..
예제]엑셀로 DB 떨어뜨리기
unit mainForm2; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, Grids, DBGrids, DB, DBTables, ExtCtrls, DBCtrls; type TForm1 = class(TForm) Table1: TTable; DataSource1: TDataSource; DBGrid1: TDBGrid; Button1: TButton; Button2: TButton; DBNavigator1: TDBNavigator; Button3: TButton; Button4: TButton; procedure Button1Click(Sender: TObjec..