Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I have been using a Cue Cat to catalog a collection I have.

Yesterday, though, FM PRo 7 could no longer find the data the Cue Cat inputted. I took out the spaces in-between the two sets of numbers and it found the record (the barcodes I'm reading have two parts). I've been doing this for at least two years now and this was never a problem before.

I tried several other programs and FM was the only program with this problem. So, I tried entering the barcode into a text field, instead of a number field, and it works just fine.

I hesitate changing the barcode field to text because I don't know if this is an aberration due to a Mac OS update (I just did 10.3.4) or the way things will work from now on...

Any thoughts?

Thanks!

Tim

Posted

From FM help:

"FileMaker Pro indexes the first 400 significant digits (numbers, decimal points, or signs) of the field, ignoring letters and other symbols."

It looks like you will need to change to a text field if you want to keep the space character.

Posted

Tim:

Unless you're going to do math with a field's contents, there's really no reason to make it a number field. All the barcode fields I use are text fields, even though most of them contain only numbers.

-Stanley

This topic is 7483 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.