Zugg Software :: View topic - what is the format in %dbget(rec[,format])?

Posted: Mon May 13, 2002 5:04 am

Does anyone know the format used in the database function %dbget(rec[,format]) to return formatted values?

I have not been able to figure it out. The help documents do not give an example for it. Is that parameter working?

MASTER Joined: 28 Nov 2000 Posts: 4817 Location: USA

Any number except zero. You can also use on, true, or yes.

LightBulb
Vague questions get vague answers

Posted: Mon May 13, 2002 11:16 am

Was my question really vague?

Are you saying that %dbget(%rec,1), %dbget(%rec,on), %dbget(%rec,true), %dbget(%rec,yes) are supposed to work?

Wanderer Joined: 19 Jul 2001 Posts: 59 Location: Germany

Help files say:
If format is present and is non-zero, the values returned are formatted (for Number fields) otherwise raw data is returned.

Eg. for the sample char that is part of a full zMUD installation you can do a:
#SHOWDB %dbget(147sa,0)
getting:
Num: 147sa
Name: implants, borg
Cost: 200000
Hit: 4
...

while a
#SHOWDB %dbget(147sa,1)
gives:Num: 147sa
Name: implants, borg
Cost: 200,000 DM
Hit: +4
...

as you can see there is only a difference in the number fields, where formatting
like +/- signs or currency (dependent on the systems global settings) are inserted.

(Yes, I know that DM isn't official currency anymore, but I don't really care.)

Posted: Mon May 13, 2002 1:21 pm

Thanks Sildaren!

I use 'general' non-negative numbers in my databases with no use of currencies. That is why I did not notice any +/- or $/DM changes.

I have just recently started to fiddle with the database again. I forgot all about #SHOWDB. So all my outputs were in one line including control characters, which made it hard to read.

Very well explained. Thank you very much!

MASTER Joined: 28 Nov 2000 Posts: 4817 Location: USA

No, I'm not saying your question was vague. That's just my current sig which I started using because I had tired of telling people we needed specifics. Your question is fine.

Yes, that's precisely what I'm saying. %dbget(%rec,1), %dbget(%rec,on), %dbget(%rec,true), %dbget(%rec,yes) all work. So do %dbget(%rec,37) and %dbget(%rec,-5).

I'm glad Sildaren thought to include the actual difference between formatted and unformatted records, that probably helped more than the actual answer.

LightBulb
Vague questions get vague answers

Posted: Mon May 13, 2002 4:28 pm

Thanks LightBulb!