life036 Posted February 7, 2007 Posted February 7, 2007 Anyone know how I can find records with an image (in a container) present? I have to do this on version 6, unfortunately. Any ideas? Thanks, Chris
Genx Posted February 7, 2007 Posted February 7, 2007 If it's embedded and not just referenced, create a calc field, result number with the following calc in it: Length( yourContainerField ) > 1 Then just search that field for 1 - Length returns total stored bytes -- so if it's empty it should return zero.
life036 Posted February 7, 2007 Author Posted February 7, 2007 Great tip! My database is re-indexing right now, so I'll do the find after. Thanks! Chris
Lee Smith Posted February 7, 2007 Posted February 7, 2007 I use a calculation in v6 such as: Case(Container=0,"No", "Yes") And then find on the No HTH Lee
Genx Posted February 7, 2007 Posted February 7, 2007 Wasn't aware that Containers would give a boolean result.
Recommended Posts
This topic is 6499 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