chrisknight55 Posted March 20, 2011 Share Posted March 20, 2011 I have a flag field, empty at the start, that I want to flag with a "Y". Finding that set of records with empty fields, Enter find mode [] Set Field [invoice::processed; ""] Perform Find [] doesn't work. Enter find mode [] Set Field [invoice::processed; isempty(invoice::processed)] Perform Find [] doesn't either. If, instead, I enter "N" in the field first, then later: Enter find mode [] Set Field [invoice::processed; "N" Perform Find [] That works fine. What is the syntax for a found set based on an empty field? Or what is a better approach? Thanks Link to comment Share on other sites More sharing options...
Fitch Posted March 20, 2011 Share Posted March 20, 2011 An equal sign "=" finds empty fields. Or, an asterisk "*" or other criteria ("Y" in your case) and then Omit. Link to comment Share on other sites More sharing options...
chrisknight55 Posted March 21, 2011 Author Share Posted March 21, 2011 An equal sign "=" finds empty fields. Or, an asterisk "*" or other criteria ("Y" in your case) and then Omit. Sunofagun, you're right. I'd have never found (or guessed) that in a bunch of years. thanks much. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4757 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 accountSign in
Already have an account? Sign in here.
Sign In Now