1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
|
procedure TForm1.Button1Click(Sender: TObject);
begin
with ASQLite3Query2 do begin
Close;
SQL.Clear;
//SQL.Add('INSERT INTO books (isbn,language) VALUES (NULL,:a)');
SQL.Text := 'INSERT INTO books (isbn,language) VALUES (NULL,:a)';
Params[0].AsString := 'test';
ExecSQL;
end;
ASQLite3Query1.Refresh;
end;
procedure TForm1.FormActivate(Sender: TObject);
begin
With ASQLite3DB1 do begin
DefaultDir := ExtractFileDir(Application.ExeName);
Database := 'mybooks.sqlite';
Open;
SQLite3_ExecSQL('CREATE TABLE IF NOT EXISTS books (isbn INTEGER PRIMARY KEY, language VARCHAR)');
//SQLite3_ExecSQL('INSERT INTO books (isbn,language) VALUES (123,"english")');
end;
With ASQLite3UpdateSQL1 do begin
//BAD InsertSQL.Strings := 'INSERT INTO books *';
//InsertSQL.Add('INSERT INTO books *');
InsertSQL.Text := 'INSERT INTO books *';
end;
With ASQLite3Query1 do begin
Connection := ASQLite3DB1;
SQL.Text := 'SELECT * FROM books';
UpdateSQL := ASQLite3UpdateSQL1;
Open;
end;
With ASQLite3Query2 do begin
Connection := ASQLite3DB1;
SQL.Text := 'SELECT * FROM books';
UpdateSQL := ASQLite3UpdateSQL1;
Open;
end;
DataSource1.DataSet := ASQLite3Query1;
With NextDBGrid1 do begin
DataSource := DataSource1;
Columns[ASQLite3Query1.FieldCount-1].Options := NextDBGrid1.Columns[ASQLite3Query1.FieldCount-1].Options + [coAutoSize];
end;
end;
end. |
Partager