Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

error on Solomon updating SQL database field change automatically with symbol

(0) ShareShare
ReportReport
Posted on by 155

Dear Expert,

Hi, I'm beginner in Solomon and really need help from you..
i have problem in my database sql server 2012 for SOLOMON 2011.

Before i did some change :
SQL Server 2000 to SQL Server 2012
Solomon 4.5 to Solomon 2011.

now i have problem in a table.
field batnbr type char(10).

this is example of the contain of the field :

batnbr
012345
012346
012347
012348

but after doing some update process in solomon, it's only edit something n click save (standard save) the batnbr field looked strange, the zero "0", becomes symbol,

this is after doing update :

batnbr
*12345
(12346
@12347
_12348

the database sql also change like that.

really need your help to solve this problem.

BR,
miuru

*This post is locked for comments

  • Re: error on Solomon updating SQL database field change automatically with symbol

    Hello Miuru,

    You stated "it's only edit something n click save".  What did you edit?  What change did you make and where did you make that change?  Can you give more details?  Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans