1. Thomas Rolseth
  2. PowerServer
  3. Sunday, 20 February 2022 17:34 PM UTC

I am getting a datawindow error when retrieving a datawindow that is part of a tab page on a window.  See attached image to view the error.  The database is SQL Server and the application has been been deployed to PowerServer 2021.  The datawindow has two retrieval arguments -- one of which is a DateTime.  When the app is deployed to PS 2021, the web api switches this to a string in the model for the datawindow like so:

 [SqlCompute(":acct_date as tran_date")]
        public string Tran_Date { get; set; }

I modified the model manually and changed to this:

 [SqlCompute(":acct_date as tran_date")]
        public DateTime? Tran_Date { get; set; }

After publishing the web api and then copying the build to the inetpub\wwwroot folder on a remote server running IIS, the datawindow error went away.  Is there any way to prevent this from happening when the app is deployed in PF to PS 2021?  While my manual fix resolved the issue, I'm guessing doing another build will wipe out any manual model changes I've made to the web api in SnapDevelop.  

Also attached is the dialog showing the datawindow retrieval arguments and part of the SELECT that shows how the argument is one of the columns.

Thanks, Tom

Attachments (2)
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 21 February 2022 05:09 AM UTC
  2. PowerServer
  3. # 1

I suggest open a support ticket.   Seems to me this is either product bug or omission in the unsupported features doc.

  1. Thomas Rolseth
  2. Monday, 21 February 2022 19:21 PM UTC
Thanks -- I did as you suggested and opened a support ticket a couple of hours ago. Tom
  1. Helpful
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.