Tools to globally search'n replace in source code.

I'm looking for any third party tools to loop through all libraries/objects
searching and replacing source code. In specific, we need to replace
(remove) all references to the owner in SQL statements (owner.objname), and
of course, with good accuracy. (A global search for the expression returned
13K hits!).

Or - might be ewen better - any API or resource to access and/or export all
objects in PBL libraries, so that we can make our own search/replace
application.

TIA...
Andre


0
Andre
1/13/2001 3:04:31 PM
sybase.powerbuilder.general 62418 articles. 19 followers. Follow

1 Replies
568 Views

Similar Articles

[PageSpeed] 42
Get it on Google Play
Get it on Apple App Store

PBL Peeper (see below) does search and replace. In fact, when I added
datawindow SQL as a scope for search and replace, it was because I was
doing what you have to do (plus a few other tasks to change SQL). 

LibraryDirectory() and LibraryExport() are PowerScript functions that
will get your objects out. (I'll leave you to figure out the
challenges of datawindows with SQL stored in graphical format.) The
challenge is to get them back in. You can do it with ORCA (which came
in the box with PB Enterprise up to v6, v7 had ORCA discontinued).
However, you'd have to deal with C callbacks and ORCA bugs to get the
code back into PBLs. A good alternative is PowerGen, which does a
great job of loading whole sets of objects into new PBLs. 

Good luck,

Terry [TeamSybase] and Sequel the techno-kitten

On Sat, 13 Jan 2001 16:04:31 +0100, "Andre Tobiassen"
<andre.tobiassen@mail.no> wrote:

>I'm looking for any third party tools to loop through all libraries/objects
>searching and replacing source code. In specific, we need to replace
>(remove) all references to the owner in SQL statements (owner.objname), and
>of course, with good accuracy. (A global search for the expression returned
>13K hits!).
>
>Or - might be ewen better - any API or resource to access and/or export all
>objects in PBL libraries, so that we can make our own search/replace
>application.

Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a PowerBuilder Developer's Toolkit, 
winner of PowerTimes 1999 "Little Helper of the Year"
0
Terry
1/15/2001 8:05:40 AM
Reply:

Similar Artilces:

superreview granted: [Bug 227633] (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR : [Attachment 191128] (Av1b) <mailnews/*> (full diff)
Serge GAUTHERIE <gautheri@noos.fr> has granted Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 227633: (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR https://bugzilla.mozilla.org/show_bug.cgi?id=227633 Attachment 191128: (Av1b) <mailnews/*> (full diff) https://bugzilla.mozilla.org/attachment.cgi?id=191128&action=edit ...

superreview requested: [Bug 227633] (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR : [Attachment 154285] (Av1a-Bw) <mailnews/*> (review only)
Serge GAUTHERIE <gautheri@noos.fr> has asked Seth Spitzer <sspitzer@mozilla.org> for superreview: Bug 227633: (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR http://bugzilla.mozilla.org/show_bug.cgi?id=227633 Attachment 154285: (Av1a-Bw) <mailnews/*> (review only) http://bugzilla.mozilla.org/attachment.cgi?id=154285&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> Keeping {{ (Av1_Bw) Fixes most '/mailnews/' '0x0?' occurences (review only) patch 2003-12-06 07:58...

superreview granted: [Bug 227633] (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR : [Attachment 154285] (Av1a-Bw) <mailnews/*> (review only)
Dan Mosedale <dmose@mozilla.org> has granted Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 227633: (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR https://bugzilla.mozilla.org/show_bug.cgi?id=227633 Attachment 154285: (Av1a-Bw) <mailnews/*> (review only) https://bugzilla.mozilla.org/attachment.cgi?id=154285&action=edit ------- Additional Comments from Dan Mosedale <dmose@mozilla.org> Nice work, and sorry for the delay. rs=dmose@mozilla.org. ...

superreview requested: [Bug 227633] (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR : [Attachment 154285] (Av1a-Bw) <mailnews/*> (review only) #2
Serge GAUTHERIE <gautheri@noos.fr> has asked Dan Mosedale <dmose@mozilla.org> for superreview: Bug 227633: (Code cleanup) Replace 0x0a/'\n' by nsCRT::LF, and 0x0d/'\r' by nsCRT::CR https://bugzilla.mozilla.org/show_bug.cgi?id=227633 Attachment 154285: (Av1a-Bw) <mailnews/*> (review only) https://bugzilla.mozilla.org/attachment.cgi?id=154285&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> No super-review from <sspitzer@mozilla.org> since "2004-07-25" :-( DanM: DanW suggests giving 'rs...

Global Search: 'Search Everywhere' Option Is Missing
in the find box. Global Search is Enabled. -- Dan on 2/27/10 6:26 AM Dan said the following: > in the find box. Global Search is Enabled. -- Dan Well it was renamed "Search Every Where" to "Search All Messages" but I just get a blank tab, even after disabling all add-ons. Corrupt index? Way to force a rebuild? on 2/27/10 4:09 PM Dan said the following: > on 2/27/10 6:26 AM Dan said the following: >> in the find box. Global Search is Enabled. -- Dan > > Well it was renamed "Search Every Where" to "Search All Messages&qu...

superreview requested: [Bug 240309] Remove \n from JavaScript [error:\n|warning:\n] : [Attachment 145942] Remove extra '\n's and clean this code up a bit (debug only).
Johnny Stenback <jst@mozilla.jstenback.com> has asked Boris Zbarsky <bzbarsky@mit.edu> for superreview: Bug 240309: Remove \n from JavaScript [error:\n|warning:\n] http://bugzilla.mozilla.org/show_bug.cgi?id=240309 Attachment 145942: Remove extra '\n's and clean this code up a bit (debug only). http://bugzilla.mozilla.org/attachment.cgi?id=145942&action=edit ...

superreview granted: [Bug 240309] Remove \n from JavaScript [error:\n|warning:\n] : [Attachment 145942] Remove extra '\n's and clean this code up a bit (debug only).
Boris Zbarsky <bzbarsky@mit.edu> has granted Johnny Stenback <jst@mozilla.jstenback.com>'s request for superreview: Bug 240309: Remove \n from JavaScript [error:\n|warning:\n] http://bugzilla.mozilla.org/show_bug.cgi?id=240309 Attachment 145942: Remove extra '\n's and clean this code up a bit (debug only). http://bugzilla.mozilla.org/attachment.cgi?id=145942&action=edit ------- Additional Comments from Boris Zbarsky <bzbarsky@mit.edu> r+sr=bzbarsky ...

Replace or delete '\n' and '\r' from a JSString object
I would like to remove or to replace \n and \r with a space from a JSString object. Does a specific method exist? Thank you. On 03/07/2011 08:11 AM, Manuel wrote: > I would like to remove or to replace \n and \r with a space from a > JSString object. Does a specific method exist? str.replace(/\r\n?|\n/g, " "); // assuming you want to match CR, LF, CRLF If you mean to modify the string in-place, you can't do that: JavaScript strings are immutable. You can create a new string with such modifications, but you can't change the existing string. Jeff ...

TB 3.1: Dislike 'Global Search'
I just downloaded TB3.1 and I cannot find a way to use the 'old search' (by subject, date, to, etc.). In TB3.0x, one had the choice of which to use. I strongly dislike the Global Search and hope that we aren't stuck with it as the only option! On 6/26/2010 8:53 PM, DJAckerman wrote: > I just downloaded TB3.1 and I cannot find a way to use the 'old search' > (by subject, date, to, etc.). In TB3.0x, one had the choice of which to > use. > > I strongly dislike the Global Search and hope that we aren't stuck with > it as the only option...

How to do a "Global Search" of your source code?
Hello, I am new to PB8. Just upgraded my apps from PB7 to PB8, and I have this question: In PB7 one could do a 'search global' in the library painter to find any places where a certain string would appear. Is there a similar way to do this in PB8? I looked in the library painter, and could not find a way to find strings across my entire application. IE: I am interesting in finding where, for example, f_my_function() gets called across all pbl's in my app. Thanks for any help, joe Hey, Right click on target and select search. This will do a "glob...

Index '-n/a-' for table '-n/a-' would not be unique
Mobilink server 9.0.2.3137 ultralite client 9.0.2.3320 I am synchronising an ultralite application written in .net with a mobilink server. I am now running in a duplicate key issue. Unfortunately in the server I get only E. 09/19 10:43:27. <1.24> [GB2993]: Error: [-10035] Download failed with client error -196 and in the client I get Sync Error Index '-n/a-' for table '-n/a-' would not be unique This makes it really hard to see where the problem is. Is this a bug in the ultralite libraries ? The .net code used to catch the error is : while(retrySync...

"Microsoft must deliver 'secure environments' not tools to write 'secure code'" draft article
Hello Please see bellow the final draft of an article soon to be published. I would appreciate your comments and corrections of anything that I might have got wrong. Best regards Dinis Cruz ------------------------------------- Microsoft must deliver 'secure environments' not tools to write 'secure code'. The latest Microsoft development environment, the.Net Framework (currently on the 1.14 version) contains a new security paradigm called Code Access Security (CAS). The Code Access Security (CAS) main concept is that code should be executed based on its origin, ...

Replace(txt,"'","''") in code-behind
i'm creating a file named client.vb using my wordpad. I'm using this as a code-behind sort of thing. The problem is I want to remove the ' from my strings so that i can put them in SQL statements. The Replace doesn't work, is there any other way to this. thanks. Can you show me the code sample you have for the string.Replace() method? That should work for you. You should instead use Sql Parameters to compile and send your query to the db. One of the many benefits of doing so is that you don't need to worry about the single quotes.-- daver True. However, I'd like to know why you are ha...

Where do I look in my source to find the code that is causing this error ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'Update' that has parameters
Hi; My problem began when I deleted the key field in my grid view. I checked my web page code and also corrected my update command and parameters in my table adapter. I would really rather not start over. Thanks for any insights !         GMann Hi, Can you provide the code? Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Hi;   Problem S O L V E D !   I thought ...

Web resources about - Tools to globally search'n replace in source code. - sybase.powerbuilder.general

Resources last updated: 12/6/2015 12:38:26 PM