Jump to content

Indexing Limitations


This topic is 8549 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

In FM 5.0, is there still a limitation on text-based relational keys of no more than 20 characters?

One of my relationships is creating odd results that could be explained by this limitation. Can anyone confirm this, and possibly provide a workaround? I have some fairly long compound keys that I'd like to use.

Link to comment
Share on other sites

quote:

Originally posted by Chuck:

From FileMaker's online help:

"FileMaker Pro looks at the first 20 characters of each word in the field, up to 60 characters (including spaces)."

So, "ABCDEFGHIJKLMNOPQRSTA" and "ABCDEFGHIJKLMNOPQRSTB" create the same index entries. However, "ABCDEFGHIJKLMNOPQRST A" and "ABCDEFGHIJKLMNOPQRST B" create different index entries. Keys can't be longer than 60 characters total, and each "word" can't be longer than 20 characters.

Another thing to watch out for is that FMP will STOP indexing after it hits one of these limits. So if you have a multi-line key, and any of the words is longer than 20 characters or the lines is longer than 60 characters it will stop indexing the record at that point.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

From FileMaker's online help:

"FileMaker Pro looks at the first 20 characters of each word in the field, up to 60 characters (including spaces)."

So, "ABCDEFGHIJKLMNOPQRSTA" and "ABCDEFGHIJKLMNOPQRSTB" create the same index entries. However, "ABCDEFGHIJKLMNOPQRST A" and "ABCDEFGHIJKLMNOPQRST B" create different index entries. Keys can't be longer than 60 characters total, and each "word" can't be longer than 20 characters.

Chuck

Link to comment
Share on other sites

This topic is 8549 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.