Topic: 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