Topic: fetch data from table

i have the table test
table test has a field name and the value x
how I fetch the name and attribute it to label or text field

Re: fetch data from table

You have to use a script, you can put any sort of character between the " " in the middle of the query.

procedure Form1_OnShow (Sender: TObject; Action: string);
var

name,value:string;

begin
    Form1.Label1.Caption := SQLExecute ('SELECT name ||'' ''||  value FROM test where id = 1');
end;

Re: fetch data from table

tcoton wrote:

You have to use a script, you can put any sort of character between the " " in the middle of the query.

procedure Form1_OnShow (Sender: TObject; Action: string);
var

name,value:string;

begin
    Form1.Label1.Caption := SQLExecute ('SELECT name ||'' ''||  value FROM test where id = 1');
end;

CAN YOU APPLY the code PLEASE ON THE
TABLE: master
field: name