Incomplete Insert
- New
- Issue
-
Radek Vicek
- Elevate Discussion
- Thursday, 20 February 2025 04:55 PM UTC
Hello,
I am solving a problem after switching to PB 2022 R3 in our application, when the datetime value is omitted in VALUES in the INSERT that PB sends to the DB (Sybase ASE 15.7).
I found out that the problem occurs when the dw_2.retrieve query is run before dw_1.update to the same table. If the query returns nothing, everything is fine. If the query returns at least one row, the following insert is generated:
INSERT INTO st_fakturace ( order_list, obj_sml, signature, code, list_type, contract_number, status, date_of_establishment, discount, price_post ) VALUES ( '11067/0125', 0, 'More', 1, 1, '', 1, , 0.00, 1 )
^^^
If the code after THEN starts executing, the above problem will occur. This code worked without problems in previous versions of PB.
The entire test application and DDL for creating the table are attached. In order for the error to appear, it is necessary to run the application, save 1 sentence, close the application, run it again and try to save another sentence again.
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.