Pervasive/Btrieve link Index wierdness?

[retsyboss]

If it's of help to anybody else:

Crystal 9.5 and XI R2
P.SQL v8
Datafile version 6/7

When linking two files, the string fields would not link if field was part of multi-segment index (in both of the files).

DB1 {IN-CRC-H.ShopOrderNo} - field was index 0 of two different 2-segment indexes
DB2 {SHOPHDR.OrderNumber} - field was index 0 of single 2-segment index

I added another index to DB2 for OrderNumber only AND specified the index for the link to use. Report works. I left DB1 alone.

 

[retsyboss]

More info:
DB1 field was defined as string of 6; DB2 string of 8.

DB2 padded the string to append the 2nd index field and so was not a match. THAT is why new index with only OrderNumber field fixed the linking problem.