List/Array ??

Does metastorm have a list/array type ?

Here's my problem. I have a form that brings back a long list of static values. Right now, every time this form is reloaded, it hits the DB to pull that whole list again.

It makes perfect sense to pull back that list from the DB before the form loads (serverside) and store that list in a variable (which type ??) and then use this variable to populate values into the dropdown.

Is this possible in metastorm ? Seems like basic functionality to avoid database hits .... Maybe im missing something really simple..HELP

Thanks

Have a nice day

Find more posts tagged with

BPM

Comments

Prakash__Kanchan

Does this feature just not exist ? :smileysad:

Paul Lawrence

It really depends what you are trying to do so your question is a little difficult to answer. There is no 'memory' list object as you would have in modern programming languages but there are a couple of options available to you, again depending on what you are trying to do.

v7 had the option to read an indexed value from a memo variable like: myMemo[0].... and you could either populate the memo through concatenation or from a select statement. It's a while since I used v7 and I can't remember whether the delimeter was tab or line feed.

If you're looking to save DB overhead I'm not sure this helps you because you still have a read of a memo variable which is going to incurr more overhead than a row read. If this is on a folder row then this will be opened on each folder access.

If you have a many to one relationship that you're trying to resolve you could consider using an external table which gives you the advantage of only accessing the data when you need it.

Hope this helps,

Paul

Prakash__Kanchan

Thanks Paul - it looks like the memo solution would best help me at this point. Do you have any examples by any chance on the metastorm site that describes this ?

Thanks