1. Joe Hess
  2. PowerBuilder
  3. Friday, 2 April 2021 19:07 PM UTC

PB2019 R2 Build 2353, SQL Server 2014

 

There seems to be a problem with the ImportJson() function and DateTime/Time columns. If I export a JSON from a datastore and import it into a different datastore (same datawindow object), the current value becomes the original value in the second datastore causing the update to fail with row changed between retrieve and update.

To test this, I created a simple table:

testString  VARCHAR(10)

testDateTime   DATETIME

testDecimal  NUMERIC(10,0)

testLong  INTEGER

testTime   TIME

 

I added a row with values 'test', 04/02/2021 12:00:00, 123.45, 98765 and 8:00:00.

I created a datawindow object, dw_test, for the table. I created two datastores with dataobject = dw_test. I retrieved the data in datastore1, changed all of the values, and then exported the row as a standard JSON. I imported the JSON into datastore2. Attached are the resulting JSON strings. BeforeJson is the export from datastore1. AfterJson is the export from datastore2. If you compare the original values, you will see the DateTimeTest and TimeTest column now have the current value as the original value in AfterJson.

 

Is this a bug or expected behavior? 

Thanks

Joe

 

Attachments (1)
Accepted Answer
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 7 April 2021 00:54 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi  Joe,

 

Thanks for your feedback on this issue. We have reproduced this Bug locally and I will transfer it to the Appeon developer to fix it.

 

To better track and handle this issue, I suggest you open a ticket for it in the Appeon Support system, so that when Appeon fixes it, we can inform you there in time.

 

 

Regards,

Ken

 

Comment
  1. Joe Hess
  2. Thursday, 8 April 2021 22:39 PM UTC
Done
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Thursday, 8 April 2021 23:04 PM UTC
Thanks Joe!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 6 April 2021 17:23 PM UTC
  2. PowerBuilder
  3. # 1

Hi Joe;

  If this is a repeatable problem, then please open a support ticket and attach a simple test case PB App to the ticket for our support / engineering team to study.  Thanks!

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.