Topic: Can anyone help me with this please.

As you can see i know very little sql
I am displaying a database address.* and want to copy an address into a database jobs.*
Any help would be greatly appreciated.



insert into jobs (cust_n)
   values ("edit4")

Re: Can anyone help me with this please.

Hi John,
The basic syntax is as follows (in this example, it's triggered by a button click procedure).
procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
  sqlexecute('insert into yourtablename (yourfieldname1, yourfieldname2) values ("'+form1.edit1.text+'", "'+form1.edit2.value+'")');
end;
If you have any problem, attach your project (zip it minus the .exe) and I'm sure someone will be able to take a look.
Derek.

Re: Can anyone help me with this please.

Many thanks Derek, i will give it a try.