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.

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.

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..