Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Index

Featured Replies

in what way does FMP8 store the index? by that i mean; does it simply assign index to every entry (using the "Auto-enter Serial") cronologicly or can i hash the index some how?

my point is that i dont want to end up with empty spaces if i delete, update or move anything, you know the old reoccuring problem... :

all indexing problems are said to be fixed in FM8v3.

You can define a field as indexed, but you can not fine tune the "hash" size

See FM8's "help":

"FileMaker Pro indexes:

A value index is created by taking each line of text (delimited by the carriage return character) and taking up to the first 100 primary character weights that all the characters in that line generate, according to the Unicode Collation Algorithm.

Word indexes can only be created for text fields, where they are used for searches. A word index is created by storing each unique word in a field"

  • Author

im sorry but i didnt quite get that...

so, if i understand you correctly, you cant build a hash structure in FMP8? what i basicly want to do is the eliminate the possibility of getting "empty" indexes if i for example delete or move a post. im going to be setting up quite a big database so searching time is going to be critical. what other options, if not for a hashindex, do i have?

Filemaker is not really a programming environment. The only control you have over indexing is what you see in File > Define > Database... > Fields > Options > Storage.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.