Ben, I agree, it would be nice to have a link to the Index. But, for the time being anyway, I cannot save a link, there seems to be a problem.

I appreciate all the comments, and will reply:

To all, I will have a session on Curly Braces when I talk about Structured Programming, I am trying to take things one at a time and not get ahead of myself.

Ray, good comment, I appreciate it. There are a number of problems converting from the dot structure to the Curly Braces, and I plan on covering that.

Evgeny, I too suggest using curly braces, however, if you are a NewBie in a team that uses the dot syntax,  I suggest using what in common practice in the team. The old structures have some very strong proponents and I would not suggest a NewBie buck the trend. It would be good for the NewBie to learn the older ways as well.

Andre, good comments, thank you. I too learned the dot structure and am comfortable with it. Thank you for your mention of Classes doing away with the New command. But bear in mind, many readers of the Developer Community have never used Classes and in their current jobs will never use them. I am writing for all MUMPS/Cache users, from the older to the newer. MUMPS/Cache is evolving. 

Edward, your comments are interesting. I would be careful using the New command on % variables. I would suggest an Application Programmer never set a % variables or use a New command on them (with the exception of SQL variables). When using the New command on % variables please be sure you know the ramifications of what you are doing.

As far as the New command affecting Arrays and all subscripts of arrays, that is true, but only if the New command is used on the top level of the Array. The New command does not work when used on a subscripted variable, ie: New Variable(2)

Bhaskar, sorry I seemed to have missed your comment. When I made the statement of Application Programmer not Newing % variables, I did not consider SQL variables. That represent an exception to my statement, sorry for the omission. Thanks for the reference to the InterSystems documentation. 

Note, for some reason I am unable to add links starting with Section 15.

I am looking for a resolution to this problem.

Bob, I fully agree with you about the more complete installation guide. However, for someone who is new, and does not understand the terms used, and just wants to see what Caché is all about on their own PC, I feel the more compact install guide may be a better fit. And if they have trouble or questions, they can always consult the more complete guide.

Ok, if I may, let me give some background of my thinking.

I thought of Embedded Query and Dynamic Query in the same class.

Also, I thought of Basic Class Query and Custom Class Query in the same class.

And Stored Procedure in a class by itself (although Stored Procedure crosses all classes) as well as SQL Shell in a class by itself.

So when I found out that Basic Class Query is run using the same mechanics as Dynamic Query, it crossed wires in my mind.

It seems to me that the Queries, taken individually and taken as a whole, could be classified better. I have the feeling that the queries were just thrown together  in a hodge-podge sort of way with no rhyme or reason. Maybe with some more fore-thought and front-end planning  the whole issue of Queries could be presented better. Well, that is my 2 cents worth.

For a simplified version, see NewBie's Corner Session 1

Ok, I saw that, but but why even put your query in a class?

You can execute a dynamic query the same way.

If what you say is true, then what difference is there between a dynamic query and a Basic Class Query?

What am I missing here?

Leo, this is good stuff to know. In the past I could have used your information. And possibly I will need it in the future.

Thanks for sharing this!

Douglas, sorry for taking so long to get back to you.

Thanks for your suggestion, I am going to use it.

Use it as it is and hopefully build upon it. 


I will be glad to add your books, they are there now.