Monday, 15 December 2008

The formula contains a syntax error or is not supported

[TR]
Calculated field'larla uğraşırken IF statement'ında şöyle bir hata aldım.

The formula contains a syntax error or is not supported. at Microsoft.SharePoint.Library.SPRequestInternalClass.UpdateField(String bstrUrl, String bstrListName, String bstrXML) at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)

Ufak bir araştırma sonunda bunun Default Language pack ile ilgili olduğunu buldum. Default'ta virgül kullanılırken diğerlerinde noktalı virgül kullanmak gerekiyormuş

Default Language Pack:
=IF([Currency]>10,"TRUE","FALSE")

Diğer Language Pack:
=IF([Currency]>10;"TRUE";"FALSE")


[ENG]
I get an error while working with calculated fields. The error message was;

The formula contains a syntax error or is not supported. at Microsoft.SharePoint.Library.SPRequestInternalClass.UpdateField(String bstrUrl, String bstrListName, String bstrXML) at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)

Formula was working at my development site but giving error at production site.
I realised that if you are using an IF statement with default language pack it works fine. Otherwise you should use semicolon instead of comma

Default Language Pack:
=IF([Currency]>10,"TRUE","FALSE")

Other Language Packs:
=IF([Currency]>10;"TRUE";"FALSE")

No comments: