Steve,
Try using {L3} instead of {S3}.
{L#} is the external representation of the subscript level and {S#} is the internal representation.
Also, you'll need to tell the code when to stop. You probably should do something like:
nextcode = {
Set {L3}={L3}+100
If '$Data(^glo({L1},{L2},{L3})) Quit
}-dave
Steve wrote:
I'm trying to map an existing global using CacheSQLStorage and only return rows that have a number that is a multiple of 100 in subscript 3. I'm guessing that I need to use nextcode in my CDL to start at 100 and increment the value of the field/subscript by 100. Like this:
subscript 3 {
nextcode = {
S {S3}={S3}+100
}
startvalue=100;
}
However, I get the error: #524: Invalid {Field} reference.
Any suggestions? I'm using Cache' 4.1.9.
