? "asdfasdfasf;
1234567"
becomes? "asdfasdf1234567"
extend that several lines and you can see how the 255 limit is exceeded.? SQLPREPARE(m.nConnectionHandle,; "SELECT TOP 100 PERCENT " +; "cast(dbo.EmployeeHours.EmployeeId as TinyInt) as EmployeeID, " +; "RTRIM(dbo.EmployeeList.FirstName) + ' ' + RTRIM(dbo.EmployeeList.LastName) AS Name," + ; "more" +; "etc"which is essentially the same as what you did, except the concatenation prevents the error.
>Declare @cCostCode varchar(30) >SET @cCostCode = '11708' >SELECT TOP 100 PERCENT cast(dbo.EmployeeHours.EmployeeId as TinyInt) as EmployeeID, RTRIM(RTRIM(dbo.EmployeeList.FirstName) + ' ' + RTRIM(dbo.EmployeeList.LastName)) > AS Name, SUM(ROUND({ fn HOUR(dbo.EmployeeHours.TimeOut) } + CAST({ fn MINUTE(dbo.EmployeeHours.TimeOut) } AS DECIMAL) / 60, 2) > - ROUND({ fn HOUR(dbo.EmployeeHours.TimeIn) } + CAST({ fn MINUTE(dbo.EmployeeHours.TimeIn) } AS DECIMAL) / 60, 2)) AS Hours1 >FROM dbo.EmployeeHours INNER JOIN > dbo.EmployeeList ON dbo.EmployeeHours.EmployeeId = dbo.EmployeeList.EmployeeId >WHERE (dbo.EmployeeHours.CostCode = @cCostCode) >GROUP BY dbo.EmployeeHours.EmployeeId, RTRIM(RTRIM(dbo.EmployeeList.FirstName) + ' ' + RTRIM(dbo.EmployeeList.LastName)) >ORDER BY dbo.EmployeeHours.EmployeeId >>To work in VFP9sp2, my VFP Code looks like:
> >cCostCode = '11708' >m.nConnectionHandle = SQLCONNECT('TimeClockPlus') >? SQLPREPARE(m.nConnectionHandle,; > "SELECT TOP 100 PERCENT cast(dbo.EmployeeHours.EmployeeId as TinyInt) as EmployeeID, RTRIM(dbo.EmployeeList.FirstName) + ' ' + RTRIM(dbo.EmployeeList.LastName); > AS Name, SUM(ROUND({ fn HOUR(dbo.EmployeeHours.TimeOut) } + CAST({ fn MINUTE(dbo.EmployeeHours.TimeOut) } AS DECIMAL) / 60, 2); > - ROUND({ fn HOUR(dbo.EmployeeHours.TimeIn) } + CAST({ fn MINUTE(dbo.EmployeeHours.TimeIn) } AS DECIMAL) / 60, 2)) AS Hours1; >FROM dbo.EmployeeHours INNER JOIN; > dbo.EmployeeList ON dbo.EmployeeHours.EmployeeId = dbo.EmployeeList.EmployeeId; >WHERE (dbo.EmployeeHours.CostCode = ?cCostCode); >GROUP BY dbo.EmployeeHours.EmployeeId, RTRIM(dbo.EmployeeList.FirstName)+' '+RTRIM(dbo.EmployeeList.LastName); > ORDER BY dbo.EmployeeHours.EmployeeId",; > 'QueryName') > >SQLEXEC(m.nConnectionHandle) > >BROWSE LAST NOWAIT > >SQLDISCONNECT(m.nConnectionHandle) >>