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
My Visual Database → SQL queries → 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
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;
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
My Visual Database → SQL queries → fetch data from table
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi