My Visual Database — save a same datafield into two diffrent data base table

Re: save a same datafield into two diffrent data base table

null@example.com (alsu) — Wed, 19 Nov 2014 09:52:55 +0000

sir one more help.any sql script for showing more than two database table fields in a single table grid result.

eg; when click button2,
show table1, table2, table3 data in serach grid(table grid)

Re: save a same datafield into two diffrent data base table

null@example.com (DriveSoft) — Tue, 18 Nov 2014 10:45:28 +0000

procedure frmEmployee_Button2_OnClick (Sender: string; var Cancel: boolean);
begin
    SQLExecute ('INSERT INTO table1 (d1) VALUES ('+ frmEmployee.Edit1.sqlValue +')');
    SQLExecute ('INSERT INTO table2 (d2) VALUES ('+ frmEmployee.Edit1.sqlValue +')');

    Form1.TableGrid1.dbUpdate;
    Form1.TableGrid2.dbUpdate;
    frmEmployee.Close;
end;

Also i made example for you, please download here:

save a same datafield into two diffrent data base table

null@example.com (alsu) — Tue, 18 Nov 2014 05:15:15 +0000

sir any script for saving a particular text field (form1.edit1) into two diffrent database table click a single button.

database table name: table1 and table2
datafield : d1 and d2 respectevly