Re: {Thor} Can you search for non-empty property?

[Eric Selje]

Forwarding to the GoFish mailing list for more coverage...

--

I’d like to search for any forms that have particular property and it’s not empty?  Is this possible in GoFish 5?

[Jim Nelson]

I believe this will handle it:

[1]  Use search string of Property name + [ =]  ....  [cFormID =], e.g.   

[2]  Use the following filter:

Let me know how it goes.

--
You received this message because you are subscribed to the Google Groups "GoFish" group.
To unsubscribe from this group and stop receiving emails from it, send an email to foxprogofish...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/foxprogofish/CAAwxvU%3DXEjrep3SPLwkCh%2BZSjBunXCH1bYHC5OwZLoO%3DhrZFuA%40mail.gmail.com.

--

Jim Nelson

(805) 498-9195 (preferred)
(720) 837-3536 (cell)

[Eric Selje]

BTW Russell, if this feature isn't available, this seems like a really nice addition for you to contribute ;) 

Eric

[Russell Campbell]

Jim,

Thanks for your reply, but I have no idea what you mean in #1 . . .

[Jim Nelson]

Russell --

I was describing the search text to be used in GF .... use the property you are searching for and add a single space and an equal sign.

My search for property c_FormID looks like this:

To view this discussion on the web visit https://groups.google.com/d/msgid/foxprogofish/6836b9b1-1a50-493c-a1fb-dd70ed1aca04n%40googlegroups.com.

[Russell Campbell]

Thanks for your reply.  I got back to this and this is what I get when trying to set up a filter.  I did an update of Thor before trying this and it says GoFish is up-to-date.

[Russell Campbell]

And I probably should have just gone ahead with trying to get around that before I reported it. When I used Ignore, I got the error again while it was doing its thing, but I did get results and what I was wanting. Thanks, Jim. I would like to get that error fixed, but at least I got correct results.

[Jim Nelson]

Russell --

Try the attached file.

To view this discussion on the web visit https://groups.google.com/d/msgid/foxprogofish/f7603801-45cf-436c-807a-2ffc981e48a2n%40googlegroups.com.

[Russell Campbell]

Jim, thanks. I had a weird issue today when starting VFP. It couldn't run something because a reference to it was already in effect (or something like that - I should have taken a screen shot, but just wanted to fix it and get some stuff done). Anyway, I tracked it down to a problem running Thor.  But I was able to run it separately (it's in my startup program and wouldn't run from there).  I'm a little vague on all of this because I just fixed it and moved on, but this is what I remember.  So when I ran it directly, it acted like it had not been properly updated from yesterday or the day before when I updated it.  So I just let it do its thing.  It kept asking me "so-and-so file is already present, would you like to overwrite it?"  I just let it.  Then everything was ok and when I shut down and restarted VFP, it started up normally.  So . . . when I ran the search again before I even tried to use the file you attached, the error did not occur.  I guess I somehow got a partial update the other day and this caused the error (missing file) during the search.  I've always felt the Thor update was a bit disjointed and this time it updated the updater, also, I believe, but I thought it fully completed.  I guess I was wrong.

Thanks again for your help.

[Jim Nelson]

Russell --

Well, glad it all got settled in the end.  Kind of weird along the way, though, it seems.

To view this discussion on the web visit https://groups.google.com/d/msgid/foxprogofish/c10cb0a5-7ac6-4ed6-8f50-2e38e186268dn%40googlegroups.com.

[Rick Schummer]

Yes, Doug has updated Thor so it gets the updates from GitHub instead of using the VFPXRepository.com domain as it has for a number of years. All of this was supposed to be transparent, but there was a small glitch in the process that was worked out over the weekend. This required an update of Thor, which is what you experienced.

 

Rick

 

From: foxpro...@googlegroups.com <foxpro...@googlegroups.com> On Behalf Of Russell Campbell
Sent: January 13, 2022 09:41 PM
To: GoFish <foxpro...@googlegroups.com>
Subject: Re: {GoFish} Re: {Thor} Can you search for non-empty property?

 

Jim, thanks. I had a weird issue today when starting VFP. It couldn't run something because a reference to it was already in effect (or something like that - I should have taken a screen shot, but just wanted to fix it and get some stuff done). Anyway, I tracked it down to a problem running Thor.  But I was able to run it separately (it's in my startup program and wouldn't run from there).  I'm a little vague on all of this because I just fixed it and moved on, but this is what I remember.  So when I ran it directly, it acted like it had not been properly updated from yesterday or the day before when I updated it.  So I just let it do its thing.  It kept asking me "so-and-so file is already present, would you like to overwrite it?"  I just let it.  Then everything was ok and when I shut down and restarted VFP, it started up normally.  So . . . when I ran the search again before I even tried to use the file you attached, the error did not occur.  I guess I somehow got a partial update the other day and this caused the error (missing file) during the search.  I've always felt the Thor update was a bit disjointed and this time it updated the updater, also, I believe, but I thought it fully completed.  I guess I was wrong.

 

Thanks again for your help.

On Thursday, January 13, 2022 at 12:35:05 PM UTC-5 Jim wrote:

Russell --

 

Try the attached file.

 

On Wed, Jan 12, 2022 at 2:27 PM Russell Campbell <russca...@interthink.com> wrote:

And I probably should have just gone ahead with trying to get around that before I reported it. When I used Ignore, I got the error again while it was doing its thing, but I did get results and what I was wanting. Thanks, Jim. I would like to get that error fixed, but at least I got correct results.

On Wednesday, January 12, 2022 at 4:07:16 PM UTC-5 Russell Campbell wrote:

Thanks for your reply.  I got back to this and this is what I get when trying to set up a filter.  I did an update of Thor before trying this and it says GoFish is up-to-date.

 

On Monday, January 10, 2022 at 8:10:49 PM UTC-5 Jim wrote:

Russell --

 

I was describing the search text to be used in GF .... use the property you are searching for and add a single space and an equal sign.

 

My search for property c_FormID looks like this:

 

To view this discussion on the web visit https://groups.google.com/d/msgid/foxprogofish/c10cb0a5-7ac6-4ed6-8f50-2e38e186268dn%40googlegroups.com.

[Russell Campbell]

Ok, cool. It all seems to have worked out in the end. Just a little glitch along the way.