topic script error in QlikView

script error

Mon, 06 Aug 2012 10:02:50 GMT

Hello

Being new to QV and SQL and lots of other things(!) - I'm not too sure why this won't load in my script. I get an error message saying

Incorrect syntax near the keyword 'FROM'.

Can anyone help?

SQL SELECT search_Incident_IncidentTypes.IncidentID,
     search_Incident_IncidentTypes.IncidentType,
     search_Incident_IncidentTypes.bActive, search_Incident_Custom_Joined.DateSubmitted,
     search_Incident_Custom_Joined.DateRaised, search_Incident_Custom_Joined.Region,
     search_Incident_Custom_Joined.Status, dbo_search_Incident_Custom_Joined.Site,

FROM (V_IncidentDB.dbo.search_Incident_IncidentTypes) INNER JOIN V_IncidentDB.dbo_search_Incident_Custom_Joined ON
search_Incident_IncidentTypes.IncidentID = search_Incident_Custom_Joined.IncidentID

WHERE
((search_Incident_IncidentTypes.bActive)=1) AND ((search_Incident_Custom_Joined.DateSubmitted) Is Not Null) AND
((search_Incident_Custom_Joined.Site)<>'Test Site') AND ((DateRaised) >= '4/1/2012');

Re: script error

manisha_uit — Mon, 06 Aug 2012 10:11:47 GMT

Hi,

Remove the comma from the last field (dbo_search_Incident_Custom_Joined.Site)

Then it should work...

Thanks

Manisha

Re: script error

Mon, 06 Aug 2012 15:19:28 GMT

thanks but its still not loading correctly - what else can I try?

Re: script error

a_mullick — Mon, 06 Aug 2012 15:43:14 GMT

Hi,

Double check the way you have qualified the field names. It looks like a typo could be causing the problem?

search_Incident_Custom_Joined.Status, dbo_search_Incident_Custom_Joined.Site,

FROM (V_IncidentDB.dbo.search_Incident_IncidentTypes) INNER JOIN

Thanks,

Azam

Re: script error

Mon, 06 Aug 2012 16:23:11 GMT

thats all working now thanks both of you