Question
Jeraisy Company for ICT
SA
Last activity: 13 Apr 2021 0:17 EDT
How to use RDB-SAVE method to save record from UI into external table
Hi, I am using Postgres , created DB and TABLE (Column1, …) then I created relevant Class and properties , a connection, everything was going smoothly If I put this code “INSERT INTO {class:Syri-ShamApp-Data-studentinfo} VALUES ('5','Maher',ALI)” in Save Tab of the Connect SQL , then Pega adds this record.
But I did not find a way save a record from the UI into external DB using RDB-SAVE
Please how can we do that or if there is alternative way by using obj-save or other
Labb Consulting
GB
Hi,
So in your successful test with the Connect-SQL, the record was successfully inserted into the external table from Pega? Was this invoked by RDB-Save in an activity?
What do you mean by "Save record from UI"? Can you give more details on the scenario, how you are attempting to save this record, and the differences in implementation between this and your successful scenario?
Regards
Sarah.
Pegasystems Inc.
AU
What is the need to using RDB-Save and Connect-SQL?
If you are dealing with 'normal' data types like Text and Numbers then you will find that using Data Pages and Report Definitions will allow you to save and retrieve your data. Even if you have to go to an Activity rule, you can use Obj-Save to save an instance of your Class to the database, and Pega generates the SQL to accomplish it and manages your database transaction scope as well.
Let the Pega engine generate the SQL you need rather than you having to code it.
Indocosmo Systems Pvt Ltd
IN
NA
SA
Hello,
Basically, you need to set values on to page and then refer in sql query (I mean rdb).
eg: Insert into {Class:ClassName} values('{ASIS:mypage.ID}','{ASIS:mypage.Name}')
Refer for the formats below,
{ASIS: myPage.myProperty}
{myPage.myPropert}
{.myProperty}
{ASIS: .myProperty}
Hope, it helps..