Zugg Software :: View topic

Newbie Joined: 18 Dec 2003 Posts: 9

Hi,

I have a standard database record variable, of the form

name1=value1
name2=value2
...
nameN=valueN

I see the variable as an ordered list of name=value items.

I want to retrieve a name=value pair (or just the key) by using an index. For example, to get the name2 key, I want a function that returns the key given the position. E.g key=%indexdb(@dbvar, 2);

I believe it should be possible to do so since the %iskey function returns a position:

Syntax: %iskey(rec,key)
returns the key number if the key exists in the record

But how do I do it? I could muck with #LOOPDB, but I hope there is a more efficient way of doing that.

Thanks for the help!

GURU Joined: 26 Jul 2001 Posts: 1958 Location: Canada

I can't think of anything off the top of my head to get the key index. Might be an %mss() way of tapping into it.

Usually I have a name=value pair called index with all the unique/odd key names in it.

If your keys have some sort of pattern then you can check from 1 to %numkeys()

You could populate your record variable then capture its keys with %expanddb()