problem with decimal point in SQL Server stored procedure

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

problem with decimal point in SQL Server stored procedure

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> problem with decimal point in SQL Server stored procedure

Page: [1]

Message

<< Older Topic Newer Topic >>

problem with decimal point in SQL Server stored procedure - 27 March 2006

dendor

Posts: 8
Score: 0
Joined: 27 March 2006
Status: offline

Hi,

I am inserting a record using a SQL Server stored procedure and the TopXML Database Adapter. Strangely, the decimal point is not converted. An amount of 10.12 is stored as 1012. SQL profiler proves that the amount is sent as 1012, the decimal point is ignored apparently.

I tried using a decimal type, and later also a float, but it gives the same result. I wonder if it may have something to do with language/culture settings.

Post #: 1

RE: problem with decimal point in SQL Server stored pro... - 28 March 2006

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Is it possible to tell us which version of the Adapter you are using. Also a sample instance of your document being being sent to the Adapter and a copy of the Application Event Log would be helpfull.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to dendor)

Post #: 2

RE: problem with decimal point in SQL Server stored pro... - 30 March 2006

dendor

Posts: 8
Score: 0
Joined: 27 March 2006
Status: offline

I was using 3.01, but I upgraded to the latest version yesterday, and the problem persists.

I sent you an email with the requested information.

Also, I noticed the similar behaviour when talking to an Oracle database. This was in a receive adaptor. Using a mapping I was able to replace the comma I received from the Oracle database Adaptor with a decimal point.

(in reply to Pieter)

Post #: 3

RE: problem with decimal point in SQL Server stored pro... - 31 March 2006

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

As you know the data retrieved is in pure Xml Format. Is it possible to see if the Localization settings for Oracle is correct?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to dendor)

Post #: 4

RE: problem with decimal point in SQL Server stored pro... - 31 March 2006

dendor

Posts: 8
Score: 0
Joined: 27 March 2006
Status: offline

I am not sure which culture setting this should be.

I found the culture setting for date formatting in the adaptor settings. I set it to nl-NL but nothing changed to the decimal point/comma.

(in reply to Pieter)

Post #: 5