Jump to content

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

Recommended Posts

Posted

Hello,

I have a field which is formatted as value list (strict, do not allow modification). Some of the values also contain a question mark (among other characters). When I want to perform a find and I select an item from the value list, which contains such a question mark I get the message that the field value I've choosen as a find criteria is invalid (accept this value does not work). Why is that, and how can I avoid it?

Thanks.

csb

Posted

In find mode, a question mark means "invalid date or time". It's in the list of symbols that show up in the status bar when in find mode.

Basically, the answer is not to use the question mark in find mode. Just look up the rest of the value.

Posted

My problem is that the question mark formes part of a record. So I have a value list containing a value which looks like: What happened to Herodotus? Problems of Classical History. Say this is a book, which is a collection of essays. I have a database where I record all the individual essays in different recrods, and select as source title for each record the book title above. When I want to filter all records that belong to the same book I choose the title via a script from the value list (returns all articles that are to be found in the same book). The problem however appears when the title (which is used in the filter function) contains a question mark. Since the filtering is automated I am not able to change the value that FM is about to filter.

Do I have to include a line in the script to tell how to handle those records from the value list, which contain a "?" ?

csb

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