Pega + database - > some issues
I have a few questions:
1. I added a field in the table with restriction NOT NULL.
This field is populated inside the BEFORE INSERT/UPDATE TRIGGER on the table.
It is works in sql via INSERT INTO table Values(...)
But Pega, says error like "pyCommitError: Trying to store empty properties XXX to a database column that does not accept nulls"
I.e. Pega does not try to call the database :-(
How to do that Pega does not check some properties/fields?
2. I have two tables
master table - primary key PZINSKEY
child table - has field PXINSINDEXEDKEY as reference to MASTER.PZINSKEY
When I work in Pega UI and add new record
then first INSERT into child table
next INSERT into master table
How to change order of INSERT operation?
First INSERT must be into MASTER table
Next INSERT must be into CHILD table
Is it possible?
***Moderator Edit: Vidyaranjan | Updated Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.