# 307 A Broken SQL Columns List is Causing an Error

---

A SELECT query with source column names broken between more than one line can open OK at design time, but at run time returns an error.

OK. This command (all source columns on one line):

SELECT t2.ClaimID, t2.FileID, t1.FirstName, t1.LastName, t1.SSN, t1.Phone, t2.WCBFileID, t2.InjuryDate, t2.EmployerOfficeID, t2.CarrierAgentID, t2.CarrierFileID
FROM people t1, claims t2 WHERE t1.PeopleID = t2.PeopleID
AND t2.CloseDate IS NULL

works OK at design-time and run-time. However this command (source column list broken between two lines):

SELECT t2.ClaimID, t2.FileID, t1.FirstName,
t1.LastName, t1.SSN, t1.Phone, t2.WCBFileID, t2.InjuryDate, t2.EmployerOfficeID, t2.CarrierAgentID, t2.CarrierFileID
FROM people t1, claims t2 WHERE t1.PeopleID = t2.PeopleID
AND t2.CloseDate IS NULL

results in an "Extended Predicate Operators Not Allowed in Source Column List" error.