Strange Saleslogix 8.0 Issue

unknown

Hi All,

I am facing the strange issue in Saleslogix LAN 8.0.

I have updgraded Saleslogix from 7.5.2 to 8. 

Everything else is running fine except below kind of scenarios 

I have some custom vb script in one of the Lan form/plugin which runs the below query and give a count in return which i will show in a textbox

"Select count(historyid) from history where completeddate >'08/12/2016' and completeddate <'12/30/2016' and activityid is not null"

The above query runs fine in 7.5.2 but gives error in 8.0 saying "failed to parse sql ,Saleslogix OLEDB Provider".

 

Remember this issue is occuring in the code where ever i have some kind of queries like this and i dont have any issue configuring connection in connection manager or while login to saleslogix lan 8.0 application 

 

The most strange part is the same query when i execuete in adminstrator sql block of 7.5.2 dont gives error but when i run the same query in 8.0 gives an error

 

Any help is really appreciated

 

Thanks,

Ram

unknown

I'm on version 8.1 and i get the failed to parse sql error

But when i change the query to Select count(historyid) from history where completeddate between '08/12/2016' and '12/30/2016' and activityid is not null it works.