Hi,
a Toshiba Tac can choose the fields imported from dicom worklist.
Disabled the request of AccessionNumber conquest generate sql error
[ROBERTO] Issue Query on Columns: , DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.ReqProcDes, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.ReqProcID
[ROBERTO] Values: DICOMWorkList.ScheduledA LIKE 'TM_CT_CMW_V3.00' and DICOMWorkList.StartDate = '20080417'
[ROBERTO] Tables: DICOMWorkList
[ROBERTO] Sorting (DICOMWorkList.PatientNam) DoSort := 1
[ROBERTO] Query Distinct Tables: DICOMWorkList
[ROBERTO] Columns : , DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.ReqProcDes, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.ReqProcID
[ROBERTO] Where : DICOMWorkList.ScheduledA LIKE 'TM_CT_CMW_V3.00' and DICOMWorkList.StartDate = '20080417'
[ROBERTO] Order : DICOMWorkList.PatientNam
[ROBERTO] ***Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DI' at line 1
[ROBERTO] C-Find (Modality Work List) located 0 records
[ROBERTO] UPACS THREAD 4: ENDED AT: Thu Apr 17 16:08:06 2008
[ROBERTO] UPACS THREAD 4: TOTAL RUNNING TIME: 0 SECONDS
The "select" query start with comma and generate sql error.