Hi,
I have a problem with time precision this is the value in the database of a time column
16:29:15.983
Put displays in a datawindow as
16:29:15.000
Now this is not a problem as such because im not that bothered about factions of seconds , the issue is when the user tries to update the datawindow we get a ROW CHANGED BETWEEN RETREIVE AN UPDATE.
Now the workaround is for someone to go into the database and remove the factions and then it works.
But is there a way we can fix the datawindow to show the fractions?
I have attached screen show of what is shows in SQL anywhere console and what it shows in datawindow.
=> "If i go into the datawindow and make these no updateable then its fine."
Exactly, that is what is normally done by most PB developers. :-)
However, there is the issue of PB not supporting the DatTime2 and DateTimeOffset data types (unfortunately). :-(
So PB Apps will need to stay away from using those types of columns.
Instead, updating these with a DBMS Trigger as a workaround.
Regards .. Chris
I think your previous reply helped me work that out , thanks for that.
There is still an issue with time precision within Appeon and this is what I have noticed.
Apps delpoyed via powerServer save time fields with milliseconds while win32 apps do not save the milliseconds and are always 000, why this is unclear but it doesn't cause me an issue now.