btree.extract key length (OpenInsight 32-bit Specific)
At 13 NOV 2002 02:52:57PM Paxton Scott wrote:
Greetings!
It seems that btree.extract is truncating keys to 11 characters.I have a series of 2 part keys, second part is 0 in all cases, first part varies from 6 to 11 characters. When the list is returned,
the 12 and 13 character keys are truncated to 11 characters.
I don't recall running into this before. Does anyone know if this is a limit?Thanks,
Paxton
At 13 NOV 2002 03:10PM Richard Bright wrote:
Check the Display length in the Dict - should be set to two more than the longest value to be indexed. Note - note talking about keys but field to be indexed.
Havnt run into any partical limit on actual record key length.
At 14 NOV 2002 10:41AM Paxton Scott wrote:
Richard,
Thanks for the reply, and I will certainly check that. It seems strange that the dislay length of the indexed field would have an effect on the truncation of the returned keys. I've read a lot of the old discussions on this, and maybe I'm confused. It turns out that the keys returned (up to 11 characters OK) have a display length of 6. But anyhow, I'll poke around on this.Thanks again,
Paxton
At 14 NOV 2002 12:11PM Paxton Scott wrote:
Just to complete the loop for someone else…
It turns out that increasing the display length of the key (part 1) to 9 from 6 (part 2 staying at 2) I can now extract successfully the key RL384500000*0
Paxton