char *insert_delcand =
"INSERT INTO DelCandidates "
"SELECT JobId, PurgedFiles, FileSetId FROM Job "
- "WHERE JobType='%c' "
+ "WHERE Type='%c' "
"AND JobTDate<%s "
"AND ClientId=%u";
"FROM Job,DelCandidates "
"WHERE Job.JobTDate>%s "
"AND Job.ClientId=%u "
- "AND Job.JobType='B' "
+ "AND Job.Type='B' "
"AND Job.Level='F' "
"AND Job.JobStatus='T' "
"AND Job.FileSetId=DelCandidates.FileSetId";
"FROM Job,DelCandidates "
"WHERE Job.JobTDate>%s "
"AND Job.ClientId=%u "
- "AND Job.JobType='V' "
+ "AND Job.Type='V' "
"AND Job.Level='V' "
"AND Job.JobStatus='T' "
"AND Job.FileSetId=DelCandidates.FileSetId";
"FROM Job,DelCandidates "
"WHERE Job.JobTDate>%s "
"AND Job.ClientId=%u "
- "AND Job.JobType='R'";
+ "AND Job.Type='R'";