Report SQL

Hi All,
Can anyone tell me what I'm doing wrong here.

select jobs.id, jobs.cust_n, jobs.del_n, jobs.your_ref, jobs.our_ref,
           joblines.id, joblines.description, allocate.jobline, 
             allocate.location,allocate.id
   from jobs, joblines, allocate
     where jobs.id = '+jobsfiles.edit5.text+'                                 
     and joblines.id_jobs = jobs.id
      and allocate.jobline = joblines.id;
       

The error is in the  '+jobsfiles.edit5.text+'    statement, so not getting the value of edit5

Kind regards

John