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