• john
  • Member
  • Offline
  • Registered: 2020-07-30
  • Posts: 38

Topic: update jobs set cust_short = (select address.short from address where

Could anyone look at this, the edit25 thats a text box in a form and tell me what syntax i need, tried every combination i can think off.

update jobs  set cust_short = (select address.short from address where address.id = ('+jobfiles.Combobox1.sqlvalue+') and jobs.record_count = edit25 )

2 Reply by sibprogsistem (edited by sibprogsistem 2020-10-08 16:48:00)

  • From: Нефтеюганск
  • Registered: 2018-04-11
  • Posts: 1,775

Re: update jobs set cust_short = (select address.short from address where

SQLexecute('SELECT address.short FROM address WHERE  jobs.record_count = "'+Form_name.edit25.text+'"  AND address.id = '+jobfiles.Combobox1.sqlvalue);
  • john
  • Member
  • Offline
  • Registered: 2020-07-30
  • Posts: 38

Re: update jobs set cust_short = (select address.short from address where

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