Speed Ferret questions

[Gary Miller]

I have recently aquired Speed Ferret 4.1 to try and
unscramble the reversed use of Company and Contact on an
inherited ADP database project and I have a couple of
questions that I can't seem to find addressed in Help.

Is there a way to turn 'confirmations' on such as there is
in the Access Find and Replace so that I can approve the
change at a change by change level rather than just keeping
the selected object in the Include list. In a given object,
I will need to change Company and CompanyID but not
CompanyType or ListingCompany. They all may be included in
the same view or function and it is just seeming to give me
the option to include or exclude the view or function as a
whole. Testing so far has replaced a lot of things that
shouldn't be changed.

Also I can't seem to find a way in the search pane to switch
to the source code of a selected view or query without
having to go to Access and view the object. Is there a
method to do this?

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[TC]

Gary, I don't know SF, so I hope this answer does not preclude you getting
some others.

Here's how I would "bulk-change" Company and CompanyID to Contact and
ContactID, *without* changing CompanyType or ListingCompany:

o bulk-change CompanyType to ZZZZZZ1
o bulk-change ListingCompany to ZZZZZZ2
o bulk-change Company to Contact
o bulk-change ZZZZZZ1 to CompanyType
o bulk-change ZZZZZZ2 to ListingCompany

An old trick from the archives!

HTH,
TC

 

[Gary Miller]

TC,

Great thought line! This is a major problem child that I am
inheriting and the fun part (right!) is trying to replace
all of the references to the Company (which actually holds
all of the contact info) to x and then Contacts (which holds
all of the Company info) to Company and the x now back to
Contacts. Got a SQLServer backend and A2KADP front end and I
need to catch every reference in both without messing up
other 'Company' references.

This db for some reason, will log 180 Megs + in Task Manager
on initialization. Tipped me over the edged in upgrading
RAM. This is a Hog and I will be very curious to learn what
I find on performance issues.

Speed Ferret seems to be very thorough with what it found. I
just need to make sure that I can throttle it a little bit
when it does the replace.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[TC]

It does seem odd that it does not give you change-by-change confirmation.
Has anyone contradicted that?

TC

 

[John Vinson]

It does seem odd that it does not give you change-by-change confirmation.
Has anyone contradicted that?

Speed Ferret DOES give you the option of change-by-change
confirmation; for that matter you can find all the instances of a text
string and either accept the change, leave the value alone, or change
it manually to any other desired value.

 

[TC]

Come on John - put your money where your ferret is!

TC

 

[Gary Miller]

I have found the source string display for SQL changes
(window was collapsed), but I still haven't found how to
turn the change by change option on. It just does the whole
batch and then displays which ones were successful and which
weren't. Do you know how to turn the confirmation level on
John?

If not, no big deal as I think that I have delved my way
through it with some alternatives.

Gary Miller
Gary Miller Computer Services
Sisters, OR


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[John Vinson]

I have found the source string display for SQL changes
(window was collapsed), but I still haven't found how to
turn the change by change option on. It just does the whole
batch and then displays which ones were successful and which
weren't. Do you know how to turn the confirmation level on
John?

IME it's on by default! Use the Replace option and run the search;
you'll see a datasheet with columns Site, Property, Value, New Value
and Status - with Status equal to PENDING.

You can either click the Process button to execute all the pending
requests, or click any value in the New Value column; the text as
edited will appear at the top of the screen and you can choose to
modify it however you like; you can also simply delete the pending row
and that instance of the found text will be left unchanged.

 

[Gary Miller]

John,

I do have all of that down well. I was hoping for a double
(triple ) check level where you would actually pause on each
replace conversion as it is happening. Something similar to
Rick's Find & Replace or the way Access F&R works in a code
module replace.

I did find that the "whole word" option that they have is
actually so robust that I think that it is taking care of
most of my concerns anyway. Emailed the support team at
Speed Ferret and assume that I will have an answer soon.
They were sure quick on an earlier one.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Gary Miller]

Hmm, from my 'ferreting' around in the program I will take 3
to 1 against him. Any takers??? Bids start at 1 cent...

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Come on John - put your money where your ferret is!

TC

I have found the source string display for SQL changes
(window was collapsed), but I still haven't found how to
turn the change by change option on. It just does the whole
batch and then displays which ones were successful and which
weren't. Do you know how to turn the confirmation level on
John?

If not, no big deal as I think that I have delved my way
through it with some alternatives.

Gary Miller
Gary Miller Computer Services
Sisters, OR


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message news:[email protected]...

 

[John Vinson]

Hmm, from my 'ferreting' around in the program I will take 3
to 1 against him. Any takers??? Bids start at 1 cent...

Well, you've got my two cents worth!