Does your where clause need a colon in front of pVariable ?

where COLUMNC = :pVariable

If that doesn't fix it, I suggest you first check whether the problem is caused by the &sql(...) or by the way your web page is calling your server-side method.

Remove all your code between the opening &sql( and the closing ) - incidentally, I assume you have a closing ) even though it didn't show in your post.

Make your method end with QUIT pVariable instead of returning tempVariable1.

Do you still get a Javascript error?

When a MAC routine is compiled it generates and compiles an INT routine. When an INT routine is compiled it generates an OBJ routine.

Here's one way to get the $H-style timestamp of when an OBJ was last written. In my example it's the OBJ of the RightTriangle.MAC example in the SAMPLES namespace:

write $$DATE^%R("RightTriangle.OBJ")

For a class definition you can get the timestamp of last change from the TimeChanged property of the %Dictionary.ClassDefinition instance for the class.

For a routine, the TimeStamp property of its %Library.Routine instance is what you want.

But AFAIK the associated username isn't recorded automatically. You could use the server-side source control class interface to record this kind of thing, but it relies on whatever is making the change actually collaborating with that interface.

Do you use any form of source control?

Please tell us what version of Cache you are currently using.

Please explain what you mean by "Class(set) Operators".

Great article Dmitry. I think there's a minor typo under the dump of the big string block. You wrote:

Unfortunately, this block is shown unencrypted.

I think you mean "encrypted". Or perhaps better to say "encoded", and to refer to "decoding" in the subsequent sentence instead of "decryption".

Can you tell us why you need an alternative?

You wrote:

from Cache Studio, when I examine the output of the class given above, I get the error message:

...

Please tell us exactly how you are using the class from within Studio.

set %session.EndSession=1

See the class documentation for the %CSP.Session class, of which %session is an instance.

Any progress on this yet? My 1.0.90 Atelier's "Check for Updates" still tells me it finds none. I've already updated my 2016.2 FT instance to the latest you've published (build 721), so I expect my Atelier won't play well with that until it gets updated too.

As I read your code, you're not doing any locking. So isn't it theoretically possible that two workers could grab data from the same node of the work global at exactly the same instant?

The "could not attach to target" message makes me wonder if you're having problems using Studio to debug CSP pages. In that case you might be interested in trying the Serenji debugger from George James Software as an alternative. It offers a different way of debugging CSP pages.

If you want a complete, closely integrated source control solution that's simple to add to your Caché / Ensemble environment, please take a look at our product Deltanji. This is ready for the approaching "new world" of Atelier, but equally happy working with older versions right back to 2009.1.