cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Meneghino
Level 10

Bug report: SQL Server / Azure SQL DB not patching all figures of number

The SQL Server / Azure SQL DB connector seems to have intermittent problems with this.

 

Again today I cannot patch the following number without it's significant figures being cut.

-236,339,979.64

 

If patching a new record, i.e. Patch(Source, Defaults(MySource), {MyNumber: -236,339,979.64}) then to

-236,339,979.6

 

If editing a record, i.e. Patch(Source, MyRecord, {MyNumber: -236,339,979.64}) then to

-236,340,000

 

This is important otherwise we cannot do our accounting...

 

@AndyPennell may be interested in this

2 REPLIES 2
Leo09
Level 8

Re: Bug report: SQL Server / Azure SQL DB not patching all figures of number

It seems that I'm also getting the same issue. @AndyPennell can you help?

Meneghino
Level 10

Re: Bug report: SQL Server / Azure SQL DB not patching all figures of number

Hi @Leo09

 

I have had this reply from Microsoft support:

"Our product team is working on the case & has replied that issue will be resolved by mid of the July month.Our product team is working on the case & has replied that issue will be resolved by mid of the July month."

 

Let's hope this time it really gets resolved.  This and issues with dates and the ability to patch null values has been a problem for months and I am surprised that it is taking so long to fix a connection to the main Microsoft database product....

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,160)