Discussion

Data Table and Database Table Mapping

I have a data-table and a database table, both mapped with same class. I am using Obj-Save and Obj-Browse to update/fetch data. My questions are as below:-
1. Obj-Browse will fetch from where, data table or database table or both?
2. Suppose I have an exposed property LastRunTime in both the table. Now if I manually update its value in database table by executing query in Toad. Will that updated value be reflected on data-table? During Obj-Browse can I see the updated value? If not then is there how can I make it reflect in data-table?
3. The class which is mapped to both the tables, is having its primary key as ID. But in database table, there is no column for ID. During Obj-Browse, if I select ID along with other properties,then it is accessing data-table. If I use pzInsKey along with other properties (not use ID), it is accessing database table. If I use both ID and pzInsKey, database table is being accessed. What is the logic behind the Obj-Browse in this scenario?

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

Comments

Keep up to date on this post and subscribe to comments

March 14, 2011 - 10:47pm

i wonder how you can map data- table and database table to a single class.

March 15, 2011 - 1:09am

Database table is an instance of Data-Admin-DB-Table. This is not a table. This rules actually consists the name of the table in the DB and maps it to a class in PRPC which is the name of the database table.

Every operation you perform, whether it is obj-browse or exposing of the columns, the results are fetched/updated on the table mentioned in the database tabel.i.e., Data-Admin-DB-Table instance

April 7, 2014 - 12:40am

Hi,

Thanks for the Explanation on the 1st question put in by PALITS01.

Can anyone please answer the rest of the questions as i have similar doubts.

Like what if we manually update a Data Table. I presume the same will be reflected in the DataBase Table. But what if it is the other way round? i.e. question 2.