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.
// Profile Waste Production
SQLCA.DBMS = "ORA Oracle"
SQLCA.LogPass = "*********"
SQLCA.ServerName = "******************"
SQLCA.LogId = "********"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ThreadSafe='Yes',Timestamp=0,PBCatalogOwner='WASTE'"
What is the exact data type of the "op_time" column in your DB schema?
Exact datatype is "datetime".
What data type does your DWO think that the "op_time" column is?
datetime
What are your Date / Time "Regional Settings" set to?
Regional format: English (United States)
Calendar: Gregorian Calendar
First day of week: Sunday
Short date: 10/31/2024
Long date: Thursday, October 31, 2024
Short time: 10:42 AM
Long time: 10:42:07 AM
Standard digits: 0123456789
All ANSI standard DBMS expect the DT to be sent as CCYY-MM-DD HH:MM:SS. Is there something in your DBParm settings that is overriding PB from sending this format to O19? (Remember, the Edit Mask only handles the App users perception of DT & validates it that way externally).
DBParm settings: SQLCA.DBParm = "ThreadSafe='Yes',Timestamp=0,PBCatalogOwner='WASTE'"