Clarion 5 link problem - more info.

[sgreer]

I've done some more research on this problem. The linked fields are 18 character decimal fields. The book says decimal fields may be as long as 30 characters. OK, so I went back to the program, found some of the records where the related child records are not displayed and changed the value in the linked field, adding a character each time. I found that the related records displayed fine as long as the linked field value was 10 or less characters long. As soon as I entered an 11 character value in the link field, the related records disappeared.

Is this an undocumented bug?

To solve the problem in the interim, I've changed the field from a decimal to a string field. Sure, it sorts funny now but that's not as essential to the program as viewing the linked data.

I'd still appreciate any insight to this problem.

-Scott

 

[Gaudalier]

Why don't use a link-Field (LONG IDParent) to (LONG IDChild) for the RI?

It's the regular & optimal for 32bit processing Using LONG variables instead of decimal variables [BCD conversion are involved in Decimal vars.]

At least I always use an LONG ID for the primary file (The primary key has the ID whitin,is Auto-INC, Unique & Do no autopopulate) Ya already know that the Primary key's fields are incluyed in the Browses although ya don't populate it!
And for the Child file I use the same Parent's key, But changing the name and including a IDCHILD field!.

If this is confusing, mail me please!

Bye. -----
carabez@hotmail.com

 

[sgreer]

Thanks. I'll try that out.