Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
LJ

Avatar / Picture

Senior Veteran
Registered:
Posts: 452
Reply with quote  #1 
Hi,
anyone got a methodology for resizing a variable?

We have phone number entries set to 80 text and I need to resize them to 250 text, but without losing the old data (oracle) and without having to recreate the workflow.

I know how to achieve it with a lot of messing around but wondered if there is an easier way?

Thanks in advance,
Lee.

__________________
LJ
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
Ahem ... well, we do in the Procedure documentation tool. It will also remove variables not used in the procedure if you ask it.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
LJ

Avatar / Picture

Senior Veteran
Registered:
Posts: 452
Reply with quote  #3 

Nice reply... you know the way these things run though, they lavish you with all the bells and whistles you could ever ask for and a couple of years in they just don't buy you any more toys.


__________________
LJ
0
Rob_B

Veteran
Registered:
Posts: 109
Reply with quote  #4 
I suppose it depends what "a lot of messing around" is; haven't used Oracle for a while but with SQL Server it is easy enough to generate a script which will create a temp variable of the new size, copy data into it, delete and replace the old variable and copy the data back (sounds more complicated than it is)

If you change the field size in the procedure file it won't complain next time you publish

__________________
There are, essentially, three types of mathematician; those who can count, and those who can't
0
LJ

Avatar / Picture

Senior Veteran
Registered:
Posts: 452
Reply with quote  #5 
I'm okay on the Oracle side (we use Toad anyway). Its just having to delete and recreate the variable and reattach it to the form fields that takes the time.

I have done that now (the Validation checker proves useful once again) and found my errors in my SQL (forgot to escape the Wildcard DOH!).

__________________
LJ
0
Rob_B

Veteran
Registered:
Posts: 109
Reply with quote  #6 
"to delete and recreate the variable and reattach it to the form fields" - ah, yes, that old chestnut!

Only tip I have to offer here is to map the field variables to a temporary variable BEFORE deleting the original one, that way the designer doesn't make them calculated and read only (at map-usage level) when you delete it, so you don't have to go through the map and change it wherever the form is used, which, frankly, is a pain in the butt.

__________________
There are, essentially, three types of mathematician; those who can count, and those who can't
0
LJ

Avatar / Picture

Senior Veteran
Registered:
Posts: 452
Reply with quote  #7 
It is one of those development tasks you would think of as high up the feature request list as we need to be able to adjust variables.

I don't tend to move the connections sideways as some of our maps are just complicated enough that its easier to drop the variable and see what comes up in the Validation to put them back in.

__________________
LJ
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!