Very cool, it worked. Thanks, Dave.
"David Van De Griek" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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. > > > >
