Bug 4246

PowerBuilder 2019 - Inconsistent date retrieval, 11 February, 2021

Brad Woodfield
10 March, 2020
Product: PowerBuilder Category: DataWindow
Version: 2019 R2 Beta Build:
Classification: Appeon bug Publishing: Public
Priority: P3
Status: Closed Reason: NO RESPONSE
armando.herrera 11 February, 2021
#12
Hi Brad, 

Based on our policy we have made 3 different attempts to contact you and determine if this ticket has been solved, Unfortunately, we did not get any response and we proceed to close it.  

If you consider this issue is still not fixed please, open a new ticket. 

Regards!
armando.herrera 14 January, 2021
#11
Hi Brad,  

We have been trying to keep in touch with you to find out about the resolution of this issue, we are in the need to close it in the next 3 working days, according to our internal help support policy.

Please remember you can always open a new ticket.
    
Regards
armando.herrera 23 December, 2020
#10
Hi Brad, 

I'm just touching base with you about this ticket.  
Please let us know if there is something else to support you with.  

Regards!
armando.herrera 03 December, 2020
#9
Hi Brad,

Is there any update on this case, do you need any further help from our side? 

Regards!
armando.herrera 05 August, 2020
#8
Hi Brad,

Good news that Appeon PowerBuilder 2019 R2 GA (build 2353) has been officially
released. 

You can get the installer from our Downloads portal at
https://account.appeon.com/download/2019 (login required).

Upgrade Notes:
You may either install the latest version from scratch or use the installers to
upgrade from earlier 2019 versions (2019 GA, 2019 MR, 2019 R2 GA, or 2019 R2
MR).
If you have both PowerBuilder 2019/R2 and InfoMaker 2019/R2 on the same
machine, please upgrade both to the same version. 

We welcome all feedback from you!

Regards
Brad Woodfield 04 August, 2020
#7
(In reply to armando herrera  @Appeon from comment #6)
Hi Brad, 

We have been trying to keep in touch with you to find out about the
resolution of this issue. 

We would like to continue with our support but without more information, we
will need to close it in the next 3 working days, according to our internal
help support policy but please remember you can always open a new ticket.   

Regards.
We haven't upgrade the build environment to this build yet. We have other issues that have also ended up in current builds and are looking at upgrading to a newer version in the near future. Thx
armando.herrera 04 August, 2020
#6
Hi Brad, 

We have been trying to keep in touch with you to find out about the resolution of this issue. 

We would like to continue with our support but without more information, we will need to close it in the next 3 working days, according to our internal help support policy but please remember you can always open a new ticket.   

Regards.
armando.herrera 30 July, 2020
#5
Hi Brad,
  
I'm just touching base with you about this ticket. 

Did we provide you with enough information to resolve this issue or have you resolved this issue?.

Please let us know if there is something else to support you with?. 


Regards!
armando.herrera 30 June, 2020
#4
Hi Brad, 

I'm checking with you if the response provided to you was helpful enough to resolve
your case. If so, can we proceed to close this ticket?.
 
Otherwise, do let us know if we can provide you with any further assistance.

Also, please keep in mind, that you are always welcome to open another ticket in case you need it.

Regards!
Mark Lee @Appeon 07 April, 2020
#3
Hi Brad,

Good news that Appeon PowerBuilder 2019 R2 GA (build 2323) has been officially released. The issue you reported has been fixed in this release. Please download and install it to verify your reported issue and let us know if any problems.
You can get the installer from our Downloads portal at https://account.appeon.com/download/2019 (login required).
Upgrade Notes:
If you are currently using PowerBuilder/InfoMaker 2019 (build 2082 or 2170) or PowerBuilder/InfoMaker 2019 R2 Beta (build 2279), please directly apply this GA (build 2323) on the top of your current 2019 or 2019 R2 Beta.
 
We welcome all feedback from you!

Regards,
Mark Lee
Mark Lee @Appeon 11 March, 2020
#2
Hi Brad,

Thanks for reporting this problem.
We can reproduce it on our side in PB 2019 Build 2170 & PB 2019 R2 2279 but we don't have a suitable workaround for you at this moment. We will do further research to figure it out. We will keep you updated!

BTW, we found that it works well in PB 12.5 & PB 12.6. 

Regards,
Mark Lee
Chris Pollach @Appeon 10 March, 2020
#1
Hi Brad;

  Thank you for pointing out this inconsistency!

  I will now transfer this ticket over to our main Support / Engineering Team for their review and feedback on this issue!

  Thank you for all you time and help in testing the PB2018 R2 beta software!

Regards .. Chris
Brad Woodfield 10 March, 2020
*Phenomenon:
When a datetime field has been created and assigned just a time value, we are seeing inconsistent values when retrieving it depending on the method of retrieval.     Previously in PB12.5 when you had a datawindow/dataset with a datetime field, and passed in just a time, you could retrieve the time value with a Null date. (i.e  ??/??/???? 23:59:00) regardless of the retrieval method.  

In Powerbuilder 2019 if you populate the datetime field with just a time; then retrieve using a .object notation (i.e. datawindow.object.field) you get the same result as previous; a datatime value with null date and the time populated; however if you use the GetItemDateTime() function you get a Null Exception Error. 

*Reproduce Steps:
1) Create a datawindow that includes a datetime field.
2) Assign a time value to that datetime field 
           dw_edit.SetItem(row, "dateField", time("12:00") )
3) Retrieve the value from the datetime field using both methods
           dw_edit.GetItemDateTime(row, "dateField")
           dw_edit.object.dateField[row]

Remarks:
The concern isn't just the Null Exception, it's the inconsistency in how the two different methods react. We're wondering if the .Object is incorrect, or the GetItemDateTime() is incorrect.  We're now going through and scanning out applications looking for possible instances of a Null Date.
OS:
Windows 10
Platform:
64-bit
Database Type:
Microsoft SQL Server
Database Version:
14