add download link on click result

I added a new field in the database with the download link

now I guess that I should use the OnCellDoubleClick function
but what would be the parameter to pull the Database Id cell's download link cell ?

In answer to your last question PM, that is quite easy to do.

Below I'm using a label to display a URL on a form and the label has got the URL from a database field. I then click on the label to open a webpage.

procedure frmMain_lbWebpage_OnClick (Sender: TObject);
var
    webpage:string = 'http://www.mywebsite.com/'; {assign fixed text to a string}
begin
  
  webpage := webpage + frmMain.lbWebpage.Caption; { add the database information to the existing string}
  OpenURL(webpage); 
end;

Obviously you don't have to use a display label as I have, you could just use another string variable to contain the database information or a hidden text box.

frmMain.lbWebpage.Caption := sqlexecute('SELECT suppliers.webpage FROM suppliers where id =' +frmMain.tgSuppliers.sqlvalue);

Substitute frmMain.lbWebPage.Caption with a local string variable if you wish.

There are a few variations on the way you could use variables and or constants to this theme.

sorry I can't get it working

may I get some more help please ?

I didn't get it how to use your code

if you would be so kind and make me a example, the I would understand
sorry

so to be clear
I have a long list of names in the database
in a search box, you can type numbers
and in the large text box you'll get all names that fit to what you search

now as all files are in the same only folder on the http server
it could be as simple as:  for download pull the file name and add http  /mydomain.com  before

double click and it downloads

thank you very much for your kindness !

Thank you very much for all your help !

I tried and nearly succeed but after I tried again I didn't end up with success

Problem is that I have no integer,  and want one colum only

file names are made from letters, underscore, dots and numbers as in test database
search works great

I pasted you my project here so maybe you would be kind enough to integrate your download function

I uploaded the listed test files on server and pasted the http ip in the script  so you can test it

thank you, you are great !

PM, I'm a little confused, in your database you have just the one field - file.

So, will you be searching using just the file name or is there going to be some other column such as person name or person number?

Updated script.