No support for SQL Server

[dskanth]

Iam using sql server as the back end and it seems that there is no sufficient support for sql server datatypes in sugar crm, and even the functionality is not working properly, when we install modules like CE Teams.
They dont seem to support sql server. Though the module is installed, i get a lot of sql errors in the pages, and its not working as normal like mysql.

This is the common error i see at many places in the module functionality:
SQL Error : An expression of non-boolean type specified in a context where a condition is expected, near
'AND'.
I dont know where and what to be modified in the queries, and iam fedup with the installation and usage of these modules. Wish if there could be modules designed for sql server.

[dskanth]

I think mysql is using tinyint for boolean values, which is not supported by sql server, can we change the datatype to bit, or anything else, to make the module work?
Becos, in many places, i find there is a serious problem with the queries. Sometimes i dont see a list, and no data in popup, etc.
Please advice, what i can do, to make the CE Teams module work with the Sql server.

[dskanth]

I realised that there is support for Sql server in the sugar. Sorry for misunderstanding.
Only thing is that we may have to change few queries here and there to make the functionality work normally. I encountered a problem where iam not able to get correct working of the CE Teams module,which i installed.
Finally, i have to modify the query in the where condition ($where = \1=1\) to make it work with out any sql errors.