Zugg Software :: View topic

Posted: Mon Jun 25, 2007 8:08 pm

I am probably just not opening my eyes wide enough, but is there a function to get the # key in a database? Like %item, except for databases. This is how I'm doing it now, but I was still wondering.

Apprentice Joined: 12 Jul 2004 Posts: 190 Location: Canada

I'm not sure what you mean here... are you referring to %db?
You'd use it like this...

Posted: Mon Jun 25, 2007 8:57 pm

No no, I need the FIRST one, no matter what it is, stupidity or aeon. The addkey's are just for example purposes. There's actually triggers and such that addkey and delkey from the variable afflictions.

Apprentice Joined: 12 Jul 2004 Posts: 190 Location: Canada

Well, you /could/ use #LOOBDB and then #ABORT after the first run... off the top of my head I can't think of a parallel for that, but I'll look.

Posted: Mon Jun 25, 2007 9:03 pm

I was really looking for a function, rather than a command, but thanks, I hadn't thought of that.

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

Either of these will work for the first one in the list

#say %db(@test,%word(@test,1,%char(30)))
#SAY %db(@test,%item(%expanddb(@test,"|","|"),1))

Posted: Tue Jun 26, 2007 1:56 am

Those both seem to be echoing the VALUES, not the KEYS, which is what I need. Thanks for the input though.

On another note, what if I wanted the 3rd, 60th?... But that's not what I'm looking for anyway, heh.

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

LOL Sorry Missed that part but I have re-written this to be all awesomeness where you can choose which index you want to use 1st 3rd 60th etc

#SAY %item(%expanddb(@test,"|","|"),1)

Even Better would be to make this a function (which I did and I know I will find a use for it :P)

Posted: Tue Jun 26, 2007 3:44 am

That is exactly what I wanted. Now, what if I wanted to display only the keys in a database?

I'll work on it, I'm sure it would have something to do with checking the database length and using your function. If you get something worked out before me, post it!

NOTE: I don't think I put enough emphasis on how kick BUTT those functions are!!

EDIT: Both functions are now equally appreciated, hehe.

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

Retrieving just the key names is easy

#LOOPDB DataRecord {#SAY %key}

or
#LOCAL $Keys
#LOOPDB DataRecord {#ADDITEM $Keys %key}
#SAY $Keys

This will be 100* faster then trying to use my function to loop through everything :p

Posted: Tue Jun 26, 2007 4:16 am

Oh oh, I forgot I didn't explain that enough, I want them to display as such:

Posted: Tue Jun 26, 2007 4:21 am

Bah, nevermind, too easy, heh.

Posted: Tue Jun 26, 2007 9:39 am

Unless there's some specific reason why you're using keys of a dbvar rather than a stringlist, I strongly recommend using the latter. At the moment, dbvars are no faster than string lists - both are stored in the same way, and dbvar lookups don't use hashes like you'd expect. This may change in the future, but right now using a dbvar rather than a string list is just creating problems like this one for you.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I came up with a method for gathering the keys that, for very large dbvars anyways, seems to be faster than using #loopdb