Named Calculation - Incorrect Syntax near ','

Dear friends,

I have a problem with a named calculation!

The problem isqhen I use values with decimal... like 0,5 or 3,125 that you can see in the bottom of my NC...

Could you help me?

CASE
WHEN [Open Amount]<=0 THEN 0
ELSE
((CASE
WHEN [D_INST_TIPO_ID]=1 THEN
CASE
WHEN [Price/NPV] = 0 THEN [Avg Flash]
ELSE [Price/NPV]
END
WHEN [D_INST_TIPO_ID]=2 THEN
CASE
WHEN [Price/NPV] <> 0 THEN [Price/NPV]
ELSE
CASE
WHEN [Princ Cumul Flash]=0 THEN [Avg Flash]
ELSE 100
END
END
END
+ [Acrd Today])/100*[Open Amount]/[Fxrate Rep Cur]) *

(CASE
WHEN [Basel Weight]<>20 THEN [Basel Weight]
ELSE
CASE
WHEN (CONVERT(DECIMAL(10,8),DATEDIFF("dd", [Date],[Maturity Date])/ CONVERT(DECIMAL(10,4), 365)))<=0,5 THEN 3,125

END

END)
END

Hi Pedro,

Try use . against ,

cya

|||

Hello. If you use a dot(.) instead of a decimal(,) will it not work?

HTH

Thomas Ivarsson

sql

My Mobile DB.

Dear MSDN Support,

It is pleasurable being in contact with you and getting the desired support, for that i am feeling free inquiring about some aspects related to my graduation project.

Well here i am facing a problem with my database. I had created a full Pocket Pc project i added references, datasources and data connection for the SQL Mobile Database i am using. While i do an query like insert,update, delete, select it works on the pocket pc emulator and i check with the emulator query analyzer. What i am asking about that i am not able to see those updates in the mobile database in the sql server 2005 mobile edition, everything is done only in the emulator but after i exit the application and check my mobile server the database is still empty !!

I appreciate your hard working, and i do believe that there is someone here who is going to provide me with the support i need.

I am looking forward to getting your reply soonly.

Thank you for your attention.

Kindly Regards;

Do you have code in your mobile application to merge replicate your SQL Mobile database to the server? What happens when you call Synchronize() ? We're happy to help you but would need more detail about how you have set up your data synchronization between the emulator and the server.

Darren