Sometimes I copy parts of a Script into a simple sql-statement and have
to replace e.g.

if (coalesce(Titel,'''') <> '''' then Titel + '' '' + Vorname + '' '' +
Name else Vorname + '' '' + Name)

by

if (coalesce(Titel,'') etc.

I am not able to do this replacement by using the Replace-dialog.
Apparently the dialog doesn't like the quotes.

Any idea?

Uli

Uli


Works fine here with 2.05b6 EDBManager

Roy Lambert [Team Elevate]

Roy,

> Works fine here with 2.05b6 EDBManager

Sorry, you are right. I messed up something there with quotes and double
quotes.

Thanks. Uli

Roy,

> Works fine here with 2.05b6 EDBManager

Correction:

Paste that in an sql-window:

Insert into Auszahlungen
('Behandler','Empfaenger','Summe','Bank','Konto','BLZ',
'Verwendungszweck1','Verwendungszweck2','AbgerechnetMonat','AbgerechnetJahr','DatumAbrechnung','IsCommonAccount')

Try to Replace ' by ''

I get this errror then:

Information

[Content]
Text "'" not found

[OK]

Uli

Uli


If you look at the window you'll see it actually makes the changes. My guess is that after the final one has been changed EDBManager keeps on looking, doesn't find any and reports the fact forgetting that its done some replacements.

I got used to it and just ignore it these days.

Maybe, like me, its going a bit senile

Roy Lambert [Team Elevate]

Roy,

> If you look at the window you'll see it actually makes the changes. My guess is that after the final one has been changed EDBManager keeps on looking, doesn't find any and reports the fact forgetting that its done some replacements.

You are right - I know that, but in this case the cursor wasn't placed
at the top of the statement, thus nothing was replaced. Sorry about
that. I am not that concentrated these days.

> I got used to it and just ignore it these days.

So do I.

Regards Uli

Uli


It gets "better"

Try this

Select a block of text
Leave the cursor at the end of the selection
Press ctrl-R
Replace something in the selected block

UNLESS you select replace backwards nothing is changed.

Roy Lambert

Roy,

<< UNLESS you select replace backwards nothing is changed. >>

As I explained before, find/replace works from the current cursor position.

--
Tim Young
Elevate Software
www.elevatesoft.com

Uli,

<< Correction:

Paste that in an sql-window:

Insert into Auszahlungen
('Behandler','Empfaenger','Summe','Bank','Konto','BLZ',
'Verwendungszweck1','Verwendungszweck2','AbgerechnetMonat','AbgerechnetJahr','DatumAbrechnung','IsCommonAccount') Try to Replace ' by '' I get this errror then: >>You'll get this if you don't have "prompt on replace" selected.  I'll seeabout removing this notification if you don't have that option checked.--Tim YoungElevate Softwarewww.elevatesoft.com

Tim


>Roy,
>
><< UNLESS you select replace backwards nothing is changed. >>
>
>As I explained before, find/replace works from the current cursor position.

Agreed, and I accepted that but its still unusual and cruel behaviour

Roy Lambert