Search options (Page 2 of 2)

This is what i used and get an error.

procedure Jobfiles_TableGrid2_OnCellDoubleClick (Sender: TObject; ACol, ARow: Integer);
begin

jobfiles.edit3.text:=jobfiles.TableGrid2.cells[jobfiles.TableGrid2.SelectedRow,1] ;

end;

Many thanks,

This is what i used

SQLexecute('update jobs  set cust_short = (SELECT address.short FROM address WHERE  jobs.record_count = "'+jobfiles.edit25.text+'"  AND address.id = '+jobfiles.Combobox1.sqlvalue+')');

And it worked fine except it still nulled all the other fields in the cust_short column, how ever it did enter it in the correct position.

Kindest regards
John

Thanks Derek.

Can do that, but this is the problem.

SQLExecute ('update temp set var1 = (select address.short from address where address.id = ('+jobfiles.Combobox1.sqlvalue+')) ');

SQLExecute ('update jobs set cust_short = (select var1 from temp where var10 = jobs.id ) ');

Here i'm just updating one line, putting the address id into a temp file, this updates jobs, but nulls all the columns except the columns i'm updating.

Many thanks Derek, i will give it a try.

Hi All,

Anyone on here know how to execute an external program, for example a database full of pdf and tiff files names and drive location, On click load pdf viewer and display the filename stored in the database.

Thanks in advance.

Hi Everyone,

Can anyone please tell me why this SQL script doesn't work.

SELECT
comp_name_address

FROM Companydata

WHERE comp_name_address like "{searchcompany}"

Many thanks in advance.

John