Zugg Software :: View topic

Newbie Joined: 04 Jun 2007 Posts: 2

Hi all ..

First off a big thanks to zugg for CMUD. How are you finding Delphi 2007 ???

I have been slowly converting my ZMUD scripts to CMUD (v1.33) which for the most part has been quite smooth. Having said that I have just come across a problem when I try and run a #query with a local variable and I'm not sure if ...
(a) it can not work because of scope
(b) I am using the local variable incorrectly
(c) the database has not been updated to handle local variables yet
(d) something else I haven't thought of :)

If I use a normal variable my script works just fine so I do have a work around. I'm just curious as to what the problem is.

For testing purposes I have hard coded the variable and thrown in an echo. My old script that works with a normal variable is as follows ...
$spll = "unknown spell"
Incnttn = "PAF PAF PAF!"
#DBOFFLINE
#DBLOAD Sp
#QUERY (&Incantation=@Incnttn) Spells TRUE
#if (%numrec > 0) {$spll = %rec.Name}
#DBRESET
#echo "Spell Name =" $spll

This finds the correct result in my table and echoes "Spell Name = Harm Body".

If I try the same thing but make "Incnttn" a local variable the script never manages to locate the record .. My script now reads ...
$spll = "unknown spell"
$Incnttn = "PAF PAF PAF!"
#DBOFFLINE
#DBLOAD Sp
#QUERY (&Incantation=$Incnttn) Spells TRUE
#if (%numrec > 0) {$spll = %rec.Name}
#DBRESET
#echo "Spell Name =" $spll

This fails to locate the record and always echoes "Spell Name = unknown spell".

What do you think the problem might be ???

Thanks in advance ..

Posted: Mon Jun 04, 2007 5:21 pm

The database module is simply ported from zMUD, so it hasn't been integrated with the new CMUD features (like local variables) yet. The #QUERY command is passing it's argument as a string value, which the database module tries to parse. Since the database module doesn't know about local variables, this fails.

A workaround is to use %concat to form the string to be sent to the #QUERY: