I'm using Windows 11 and PB 2022 R3 B3391. Database back end is Oracle 19.
I'm pretty sure this has something to do with the new compiler being used in the latest version of PB.
This always worked before. I have a datetime column named "op_time".
In the DW painter I make the column an EditMask with "hh:mm:ss" as the mask. Format is listed as [time].
Before you could enter the time value fine as "09:37:00" and it would automatically convert it to a datetime like "1/1/1900 09:37:00" to save in the database. Now I get the validition error I attached.
Any ideas? Thanks.
Works if I add an empty date i.e. 1/1/1900 12:32:22. Doesn't work if I just add a time i.e. 12:32:22.
Does the DWO DT update work OK when run in the DW Painter?
No, same error occurs.
Have you tried running an SQL trace to see what it happening DB Client handshaking wise?
Ran a trace and the file is full of a bunch of nulls and/or chinese looking characters.
If this is a App EXE issue, is there any SQLPreview Event code playing with the SQL leaving the App?
Nothing is in the SQLPreview Event.