Hi All,

Im just starting to be able to use some SQL data via Foxpro(6). I am having some trouble getting complicated SQL statement to run via sqlexec(). It runs fine in sqlserver 2000 query analizer but I get a compile error in foxpro.


below is what i am doing

any ideas would be appreciated

? sqlexec(gnHandle, "select BvSurvey.Name as Survey, Hst_Path1 as ID_NUM, Hst_Path2 as ITS, Hst_Path3 as AppointmentID, ;
Hst_Path6 as CallTimeSeconds, Hst_Path6 / 60 as CallTimeMinutes, BvPerson.Name as Interviewer,;
BvAppointment.time as AppointmentTime, bvRole.Name as Role from dbo.bvhistory bvhistory;
LEFT OUTER JOIN dbo.BvPerson BvPerson;
ON bvHistory.PersonSID = BvPerson.SID ;
LEFT OUTER JOIN dbo.BvAppointment BvAppointment;
ON bvHistory.Hst_Path3 = BvAppointment.ID ;
LEFT OUTER JOIN dbo.BvRole Bvrole ;
ON bvHistory.RoleID = BvRole.RoleID ;
LEFT OUTER JOIN Dbo.BvSurvey BvSurvey ;
ON bvHistory.Hst_ObjID = BvSurvey.SID ;
where bvHistory.EvtTp_ID = 204 and Hst_ObjID = 1576 and Hst_Path2 <> 16 order by Hst_Path2 ","q1")