Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
Search and Replace in SQL windows |
Sun, Apr 24 2011 6:01 AM | Permanent Link |
Uli Becker | 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 |
Sun, Apr 24 2011 1:29 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Uli
Works fine here with 2.05b6 EDBManager Roy Lambert [Team Elevate] |
Mon, Apr 25 2011 4:29 AM | Permanent Link |
Uli Becker | Roy,
> Works fine here with 2.05b6 EDBManager Sorry, you are right. I messed up something there with quotes and double quotes. Thanks. Uli |
Tue, Apr 26 2011 10:53 AM | Permanent Link |
Uli Becker | 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 |
Tue, Apr 26 2011 10:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Tue, Apr 26 2011 2:25 PM | Permanent Link |
Uli Becker | 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 |
Wed, Apr 27 2011 3:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Apr 28 2011 10:23 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Apr 28 2011 10:26 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Apr 28 2011 11:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |