 |
Srykr
Newbie
Joined: 21 Apr 2011
Posts: 2
|
 Posted: Thu Apr 21, 2011 9:29 pm
Cmud 3.34 issues with #query
|
After upgrade attempting to run the query
#query ~&mName=%lower(the magic) mo
generates error
Error Parsing Command:
Access violation at address 00e09219 in module 'cmud.exe'. Read of address 0000004
Always worked before
Thanks[/img] |
|
|
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Thu Apr 21, 2011 10:32 pm
|
You need to properly put {} around your command arguments. A bug in the parsing of & was fixed in 3.34 and it looks like you might have been relying upon this bug. For example:
| Code: |
| #query {~&mName=%lower(the magic)} mo |
Also, I'm not sure why you are using ~. Aren't you trying to compare the value of the "mName" column in your database? Try:
| Code: |
| #query {&mName=%lower(the magic)} mo |
or
| Code: |
| #query "&mName=%lower(the magic)" mo |
I think it's this last one that you want to ensure that %lower is evaluated by the #query command.
Although I'm not sure why you have %lower anyway since the string "the magic" is already lowercase. |
|
|
|
|
Srykr
Newbie
Joined: 21 Apr 2011
Posts: 2
|
Posted: Thu Apr 21, 2011 11:44 pm
|
| Code: |
| #query {~&mName=%lower(the magic)} mo |
generates the same issue as initial question.
| Code: |
| #query {&mName=%lower(the magic)} mo |
puts
| Quote: |
| the magic=themagic |
in the -formula- window of the db window.
| Code: |
| #query "&mName=%lower(the magic)" mo |
results in the same error as step 1.
looking at the old version on my laptop, in the -Formula- box in the database window you see
returning the record set. entering that text in the 3.34 version results in the error at step 1, removeing the "&" in front of the mName results in no records being returned.
to simplify i put the value 'the magic' in from the database instead of the variable.
the "~" was used as in the prefs screen it's set as "quote char" in my special characters |
|
|
|
|
|
|
|
