Jump to content
Sign in to follow this  

Constrain found set issue

Recommended Posts

I'm scripting a simple routine, constrain the found set to omit all the records in which a particular field is empty — Constrain Found Set [Restore] in which the action is "Omit Records" and the criteria is Fieldname [=].

It works. Except one of the records returned has that critical field empty. I've experimented with every variation I can think of, but the same correct set is returned, plus that particular record where that field is visually empty. Not that it probably should matter, the troublesome record is the second in the set.

I suspect FMP10 is seeing some invisible character I can't see or select. Any guesses what might be going on here?

Much appreciated.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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