Application Migration FYI: "Replace Function" Had Me Scratching My Head

I had a wee bit of a head scratcher this morning that I thought I would share with all as a reference piece for application migration.

I was copying an Oracle export agent from another developer into a application being worked on using ND6 Designer. However I could not save it because it said there was an ilegal executable call outside the procedure for the following home cooked function:

Function Replace (,) as string

So tried in in the R5 designer and all was well. As my mind was boggled, I did a search in ND6 Designer help and came across the new “Replace” unction that is built in:

Function Replace (,) as variant

and sure enough, this was the culprit. I renamed the copied function in the agent, and all references to it to “ReplaceIt” and all was well.

Another interesting thing to note. When I had the agent from the source database I was copying from open in ND6 designer, because of the “error” I could not close the agent via “esc” or clicking on the tab if I had any of the functions/subroutines selected in the IDE. If I moved the selection to an empty entry (in this case “Document Selection” for searches), it closed fine.

Just a little food for thought as you migrate apps from R5 to ND6.


Christopher Byrne, IBM CAAD/CASA

The Cayuga Group, LLC

http://www.thecayugagroup.com/