Hi,

I've had to rename a field in one of my tables, which I've done using the
redefine procedure in DBISam.

However, the problem I have is that an application I wrote needs to have the
source code changed to reflect the fields name change. (both .pas and .dfm
files).

Does anyone know of a quick way to do a search/replace in both .dfm and .pas
files so I can accomplish this?

Thanks & Regards

Adam Hair.

I'm 1/2 way there. I found GReplace at  www.abacre.com which has almost done
the job for me.

Unfortuantly, it can not replace SQL in TDBISamQueries. Does anyone know if
it's possible to update the SQL in TDBISamQueries without having to open
every query?

Cheers

Adam.

Blast - Posted too soon. The problem, I've found lies where the SQL in the
dfm is linefed.

ie:
       'select distinct D.item, D.TYPE, D.AppCourseID, D.AppID, D.Claim,' +
       ' D.ClaimID, D.Claim_Description, D.CourseID, D.Amount, D.CourseS' +
       'tartDate, D.EndDate, D.CourseItem'

Searching and replacing for D.CourseStartDate will not work, because of the
break.

This is going to be harder than I first though.  

Adam.

Hi Adam,

You know, .. talking to yourself is a very BAD sign

--
Best regards

Stevo

"Adam H." <ahairsub4@rREMOVEMEspamSTOPPER.jvxp.com> wrote in message
news:45A70C6F-5266-465E-982F-323F4F78A813@news.elevatesoft.com...
> Blast - Posted too soon. The problem, I've found lies where the SQL in the
> dfm is linefed.
>
> ie:
>        'select distinct D.item, D.TYPE, D.AppCourseID, D.AppID, D.Claim,'
> +
>        ' D.ClaimID, D.Claim_Description, D.CourseID, D.Amount, D.CourseS'
> +
>        'tartDate, D.EndDate, D.CourseItem'
>
> Searching and replacing for D.CourseStartDate will not work, because of
> the break.
>
> This is going to be harder than I first though.  
>
> Adam.
>

Hi Steve,

> You know, .. talking to yourself is a very BAD sign

You've got no idea. In fact - a white building with comfortable warm white
jackets might just be the holiday I need at the moment.  

Cheers

Adam.

Adam H. wrote:
....
> You've got no idea. In fact - a white building with comfortable warm
> white jackets might just be the holiday I need at the moment.  

And the pills, don't forget the pills!

Ralf, having the same dream

Well, next time you need something like this go to http://gexperts.org/.
They have an excellent plug-in for Delphi's IDE. Allows you to this and much
more: search, search and replace, search and replace all, etc. Couldn't live
without it.

Jerry

"Adam H." <ahairsub4@rREMOVEMEspamSTOPPER.jvxp.com> wrote in message
news:EAA99654-DA8E-42B2-B6DD-A4B64ABE548C@news.elevatesoft.com...
| I'm 1/2 way there. I found GReplace at  www.abacre.com which has almost
done
| the job for me.
|
| Unfortuantly, it can not replace SQL in TDBISamQueries. Does anyone know
if
| it's possible to update the SQL in TDBISamQueries without having to open
| every query?
|
| Cheers
|
| Adam.
|
|

Hi Jerry,

> Well, next time you need something like this go to http://gexperts.org/.
> They have an excellent plug-in for Delphi's IDE. Allows you to this and
> much
> more: search, search and replace, search and replace all, etc. Couldn't
> live
> without it.

Thanks for the tip, however I do have gexperts installed, and while it has a
find function, the only replace I can find is for components - and not just
straight text. Is there something you know that I don't?  

Cheers

Adam.

"Adam H." <ahairsub4@rREMOVEMEspamSTOPPER.jvxp.com> wrote in
news:6335D526-5F2F-4075-833B-C334947EAB52@news.elevatesoft.com:

> Hi Jerry,
>
>> Well, next time you need something like this go to
>> http://gexperts.org/. They have an excellent plug-in for Delphi's
>> IDE. Allows you to this and much
>> more: search, search and replace, search and replace all, etc.
>> Couldn't live
>> without it.
>
> Thanks for the tip, however I do have gexperts installed, and while it
> has a find function, the only replace I can find is for components -
> and not just straight text. Is there something you know that I don't?
>
>
> Cheers
>
> Adam.
>
>

I do this kind of thing so often (not just in Delphi) that I decided to
buy a shareware program to do it. Take a look at:

http://www.powergrep.com/

If that's not an option, I see another program that claims to do almost
as much here, for free:

http://www.orbit.org/replace/

(found by googling for "search replace freeware")

--
Chris

Adam,

Search for some text. In the Grep Results window there is a Replace menu.
Drop it down and there is a Replace All Items function (or just do
Shift+Ctrl+A). It will walk through all the units where there are hits.

Jerry


"Adam H." <ahairsub4@rREMOVEMEspamSTOPPER.jvxp.com> wrote in message
news:6335D526-5F2F-4075-833B-C334947EAB52@news.elevatesoft.com...
| Thanks for the tip, however I do have gexperts installed, and while it has
a
| find function, the only replace I can find is for components - and not
just
| straight text. Is there something you know that I don't?  
|
| Cheers
|
| Adam.
|
|