I have a field in a datetime type datawindow with mask: dd-mm-yyyy hh: mm and when the update of the datawindow is done it gives the error of the image.
Why is this happening? - You are here:
-
Home
-
Q&A
-
Q&A
-
PowerServer Mobile (Obsolete)
- Error datetime in datawindow
-
Frank Monfort
- PowerServer Mobile (Obsolete)
- Monday, 11 January 2021 13:03 PM UTC
Comment
- Miguel Leeuwe
- Monday, 11 January 2021 17:20 PM UTC
I don't have Powerserver installed (nor SqlServer) at the moment, but there'll be a place somewhere where you specify more database parameters I think. Maybe with some sql server tool?
Also on powerserver you might not get thousands of milliseconds precision on datetimes, but again, I'm not sure of that. Maybe someone else can respond or if not, I'll try to install myself.
Also on powerserver you might not get thousands of milliseconds precision on datetimes, but again, I'm not sure of that. Maybe someone else can respond or if not, I'll try to install myself.
- Miguel Leeuwe
- Monday, 11 January 2021 17:24 PM UTC
What language settings for date / datetime do you have on the powerserver server?
- Miguel Leeuwe
- Monday, 11 January 2021 17:39 PM UTC
Also, as said before, look at the "format" of the column. The 'editmask" only "plays" when you're "editing" the column.
I do see a "space" in your edit format "dd-mm-yyyy hh: mm", between the ": " and "mm". Not sure if that could be of any meaning.
I do see a "space" in your edit format "dd-mm-yyyy hh: mm", between the ": " and "mm". Not sure if that could be of any meaning.
There are no comments made yet.
Comment
- Frank Monfort
- Monday, 11 January 2021 21:14 PM UTC
It is simply a datawindow with a DateTime field with the mask dd-mm-yyyy hh: mm. Something that anyone must have encountered with this problem.
When I do the dw_1.Update () is when I get that error
- Frank Monfort
- Tuesday, 12 January 2021 08:36 AM UTC
It already happened in the previous version and they said that in 2019 R2 it would be solved, but it still gives the same problem. And it is something basic, being able to record a DateTime field with the Update () of a datawindow
- Miguel Leeuwe
- Tuesday, 12 January 2021 11:58 AM UTC
Wow, that would have been useful information to give us when you posted the initial question.
:)
:)
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.
However, you are not allowed to reply to this question.
First of all, check the type of the field and the "format" not just the edit mask of the column. Maybe there's something wrong there.
Something else to look at would be the do a GetItemDateTime on the column after you initialize it. Either display in a message box or step through and examine in the debugger. My thought process is that it might point you in a direction is you know where the month is getting set to 00, when the column is set or when PB is creating the SQL update statement.