External Database

<<Back

·         Database other than is said to be external data base

·         To work with external data base, we need to make connection between PRPC application, external database and its tables

·         To work with External database, follow below steps

1)      Create an External Database in DB environment, provide access privileges to it.

2)      Create an EDB table in the DB environment, provide access privileges to it.

3)      Make a connection between PRPC and EDB. Create a Database rule in PRPC and provide Connection string to it.

4)      Make a connection between PRPC and EDB table. Create a Data Table class and create required properties under it with matching column names. Create a Database Table rule and connect to the EDB table.

5)      Create a connect sql rule and write required queries to access the data from EDB table.

6)      Use RDB methods to execute the queries.

·         The following are the RDB methods which we can use to access external tables.

1)      RDB-List    =          Obj-Browse

2)      RDB-Save  =          Obj-Save

3)      RDB-Open =          Obj-Open

4)      RDB-Delete=         Obj-Delete