Hai Gurus,
I installed Baan5c on my PC.DB is SQLServer 2000.
But in DB In every table I can see 2 extra cols.Can any body explain what are these. I heard in Baan IV some thing called Hash columns are there.
And when I tried to create a diagram its not showing any relations like master child or foriegn key relationships.

sincerely....
Jack

Are the columns refcntd / refcntu? those hold "reference counters" (d for delete, u for update) in your table dd these would show up "restricted with counter" constraints.

Dave

Hai mr Dev
But those 2 fields(t_refcntd,t_refcntu) are integer values.
Can u explain elaoborately,when deleting what are the values it holds and when updating what will be the values of these 2 fields?

rgds,
Jack

let's look at refcntd since its easier to explain.. every time a child is added to a parent, the parent's refcntd is incremented. when a child is removed, it is decremented.. when the value is zero, you can delete the parent...

make sense?

Dave

Thnaks dev,
but I have seen for unitsets (tcmsc012)and units(tcmcs006) in One Demo company,For one unitset we have 25 units,but still refcntd value of parent is zero.why??
And also can you pls explain ,Why I couldnot see any relations (,forgien key and master child relationships) between tables in MSSQL 2000? Even after reorganizing tables also I couldnot see.


rgds,
Jack

Table/field relationships are kept ouside of the database and in a baan format (table definitions) for portability reasons (same functionality across diferent databases).

refcntd is empty becuase the field is "restricted with lookup" not "restricted with counter" Look at the fields in "Maintain table definitions" and you'll see what i mean..

Restricted with lookup means that the driver will actually issue a query against the DB on that table to see if the children are present..

Dave

Hello,

yaah understood the concept of refcntd ... can somebody explain the concept of refcntu ... how does it works ... on what logic will this field contains value ( incremented or decremented ) ???

Regards

Learner

Hi gurus,

anybody who can tell the logic for refecntu field present in all the tables ??

how it is incremented an decremented ??

Regards

Learner

The way the refcntd is linked to the delete mode in data dictionary, refcntu is linked to update mode in the data dictionary. And think u know refcntd very well.