Hi William,

As you already said, you are able to connect to external database. I hope, you mapped the external database table to a class.

Then try to make a connect-sql rule in the mapped class.

RDB-Open --> for retrieving a single record or row from the table.

In my scenario, I have a class KART-PocPeAPP-Data-entries i.e., mapped to entries table (guestbook database).

I have created a connect-sql rule in the Class KART-PocPeAPP-Data-entries.

entries table is having three columns -- content,guestname and entryID. entryID is primary key.

If I want to retrieve the record based on the entryID value i.e., passed dynamically, used the below sql query in Open tab of connect-sql rule.

select content,guestname from {Class:KART-PocPeAPP-Data-entries } where entryID = '{ASIS: TempPage.entryID}'

I would be setting the TempPage.entryID, before invoking the RDB-Open method. The EntriesPage will contain the results.

Please, refer the screenshots and forgive me If I go out of the context.

In the same way, you can use the below RDB methods.

RDB-List  --query present in Browse tab will be executed.

RDB-Save and RDB-Delete are straight forward I guess.