Hello all,

I am trying to help resolve an error 605 referential integrity "problem" we are having. In order to better understand what the error is trying to tell me, I have gone to look at the data dictionary table definition for the table called out in the error message (tisfc001). I know from previous experience that these counters are defined in the REFC part of the table definition. Here is our REFC portion of the tisfc001 table def:

:REFC:tdltc961.pdno 0 1
:REFC:tdpur041.pdno 1 t1
:REFC:tdpur045.pdno 1 0
:REFC:tdpur051.pdno 2 0
:REFC:ticst001.pdno 0 t1
:REFC:ticst002.pdno 0 t1
:REFC:ticst951.pdno 0rr1
:REFC:ticst953.pdno 0 0
:REFC:ticst955.pdno 0 0
:REFC:tihra951.pdno 1 r1
:REFC:tipgc101.pdno 2 0
:REFC:tisfc001.fcpo.a 1 0
:REFC:tisfc001.ppdn.a 1 0
:REFC:tisfc010.pdno 0 t1
:REFC:tisfc011.pdno 0 0
:REFC:tisfc012.pdno 0 0
:REFC:tisfc951.pdno 0rr1
:REFC:tisfc954.pdno 0 0

Can anybody explain to me what the codes mean to the right of the table.field (e.g. "1 t1", "2 0", "0rr1", etc.)? I have had it explained to me before by Baan support, but it has never really become totally clear to me.

Thanks,
Judy

I am not aware of what it means, but I assume that is used by the database to create and maintain the columns for the reference counter columns.

If you have an RDBMS, you may be able to get information on what the specs are for the reference counter columns on a specific table and relate that to the RDD file of the table.

You will need to check from within the RDBMS, because when using the Baan Database Driver, these columns are masqueraded.

Hi Judy,

That part is more related to kind of reference it is, I mean Mandatory Unless Empty or Mandatory.. I am not sure of exact decoding of that, but if you can check the reference of the field in individual table field, you can make out the exact meaning.

-- Avinash

Hi,

If you take a look into ttadv4520m000 and select a table and then select by 'special' session ttadv4522s000 table-fields, you will see on form three: Reference table / mode / control check DBMS / update / delete. Below that field descr. you'll see if there is e reference to another table / field and if it is mandatory / mandatory unless / No check / Lookup / Restricted and so on.
By the field-help you will get an explanation of it.

GN