My Visual Database — save in to two tables from a single button

Re: save in to two tables from a single button

null@example.com (DriveSoft) — Sat, 04 Oct 2014 17:23:53 +0000

Please, send me your project with details, where you need that.
support@drive-software.com

Re: save in to two tables from a single button

null@example.com (alsu) — Sat, 04 Oct 2014 16:17:19 +0000

sir any script for showing two database tabla data in a single form including combo box?

Re: save in to two tables from a single button

null@example.com (DriveSoft) — Sat, 04 Oct 2014 16:09:23 +0000

This code for script page.

You can create event for form OnShow and read data from second database table using function SQLExecute and SQL query.

Re: save in to two tables from a single button

null@example.com (alsu) — Sat, 04 Oct 2014 15:59:28 +0000

sir i have one more doubt. the above code put in script page or choose sql query? and how to show two database table datas in a single form?

Re: save in to two tables from a single button

null@example.com (DriveSoft) — Thu, 02 Oct 2014 08:50:22 +0000

Because add is keyword of SQL, try this:

procedure frm2_Button1_OnClick (Sender: string; var Cancel: boolean);
begin

SQLExecute ('INSERT INTO main (jobno)  VALUES ("'+ frm2.Edit2.Text +'")');
SQLExecute ('INSERT INTO [add] (tag) VALUES ("' + frm2.Edit3.Text +'")');

end;

Re: save in to two tables from a single button

null@example.com (alsu) — Thu, 02 Oct 2014 08:28:46 +0000

sir i got two error messages
near "add syntax" error and near SQLExecute syntax error?

var
sHello: string;

procedure frm2_Button1_OnClick (Sender: string; var Cancel: boolean);
begin

SQLExecute ('INSERT INTO main (jobno) VALUES ("'+ frm2.Edit2.Text +'")');
SQLExecute ('INSERT INTO add (tag) VALUES ("' + frm2.Edit3.Text +'")');

end;

Re: save in to two tables from a single button

null@example.com (DriveSoft) — Thu, 02 Oct 2014 08:04:53 +0000

Please, look this topic.
http://myvisualdatabase.com/forum/viewtopic.php?id=459

save in to two tables from a single button

null@example.com (alsu) — Thu, 02 Oct 2014 05:33:31 +0000

sir how to save text field and cmbobox into two difrrent database table with a single button 'save' ? and how to show(edit form) this in a single form? any script