To request a copy of the examples only – please see me, will email them out for free.  pmkadow@gmail.com

To request a copy of the examples only – please see me, will email them out for free.  pmkadow@gmail.com

To request a copy of the examples only – please see me, will email them out for free.  pmkadow@gmail.com

I have finished my 4th book about Caché and MUMPS. This will probably be my last.

I am deeply grateful and humbled for all the help I have received from this group and the WW Response Center.

You all have something very special going here. 

Unlike most groups like this, you help those who are struggling to get started, that is unique.

Never lose the attitude of graciously helping the beginner. 

=================================================================================

Following is the book cover, available on Amazon or Smile.Amazon,

How do I change my picture or avatar 

Hi All,

I don't know if I am doing something wrong or maybe a setting is off.

But while in Cache Studio, under the Edit menu, when I use "Find in Files . . ." nothing is returned, regardless of what I am trying to find.

Weird.

I am working my way through some SQL documentation.

The documentation follows and my question comes after.

A query supplied to %Prepare() can contain input host variables, as shown in the following example:

  SET minage = 80

  SET myquery = 3

  SET myquery(1) = "SELECT %ID AS id, Name, DOB, Home_State"

  SET myquery(2) = "FROM Person WHERE Age > :minage"

  SET myquery(3) = "ORDER BY 2"

  SET qStatus = tStatement.%Prepare(.myquery)

This talks about input host variables

I thought that input host variables only work with Embedded SQL, not Dynamic SQL

Thank you

A new book on Caché Objects and Atelier                     $25 at Amazon.com                                                                                               

TinyUrl: https://tinyurl.com/y74jw49c

Coming on Kindle

There are many good MUMPS developers who want to learn Caché Objects but do not know how to start.

At the same time, InterSystems is pushing the envelope of technology with a new development platform

such as Atelier along with Eclipse.

It is my aim in this book to help those developers bridge the gap into Caché Objects at the same time learn

Atelier as well.

How can I access the InterSystems Class Database with the Atelier IDE?

Say I want access to the Samples database and Namespace?

I started with the Atelier Stand Alone.

Now I have moved on to Atelier as a plug-in to Eclipse.

With the Stand Alone I had access to two help topics, the Workbench and the InterSystems Atelier.

Now, as a plug-in I have access to a number of other help topics.

When I do a Help Contents, how do I eliminate those help topics I have no interest in?

Or only do a Help Contents on the topics that apply to me as a Atelier user?

I apologize if you have already covered this, but there is so much to read on Atelier already.

I am in Atelier editing a Class.

I want to look at the window or pane that shows my Properties, 

I get to the tab that show Properties and their Value as shown below.

Now, how do I get the properties from my Class into the image below?

Hello, this is going to be a stupid question, yea I know, there are no stupid questions.

Say, I have an Object Property, Name or Count or Title, or whatever.

How can I get a list, or find out all the different ways it can be expressed?

Example:

-Property Name As %Name;

-Property Name As %String="me"

-Property Name As %String [ Required];

But what other parameters, keywords, restrictions, lists, etc. that I can apply to this Property?

I have been search the I/S documentation and so far at least, I cannot find that sort of information, or in one place.

In trying to understand Atelier I am directed to go through its hierarchy type of documentation.

Is the Atelier documentation going to continue as a hierarchy or at some point is it going to be integrated into the InterSystems type of documentation?

When looking for an answer it would be nice to use only one method.

I am trying to find documentation on how Cache Studio locks a Routine/Class a developer is editing.

On the flip side, I am looking for documentation on how Atelier does the same.

Ultimately I am looking for the differences and what happens if both Studio and Atelier through different developers go after the same Routine/Class.

I am not asking for an answer (however that would be nice), I am looking for pointers to documentation.

I am trying to create a routine in Atelier.

I go through and enter the necessary information but before I can save, it says I have an invalid project location.

I am not sure what this is referring to, a directory? a namespace? a website? something else? "Location" does not describe what is necessary here.

I had a screen shot but cannot seem to post it here.

When starting a post, especially for the beginner there are a lot of buttons, check marks, icons etc. On some of them when you hover you get a very brief descriptions. In reading through some of the responses to the Developer Community Feedback there is a lot of good information.

Could one of the moderators, who know all the tricks put together a one or two page "cheat sheet?" or beginner guide?

This "Cheat Sheet" would be of great help!

I get the impression that there is a great push to encourage others to use the Developers Community.

You may have already covered this in another place, but how does one insert "Relevant Articles?" in a post?

I am confused about the meaning of "rating".

Is it how good the post is?

I did a search on "Rating" and got a lot of hits, but none seems to answer my question, either that or I missed it.

It would be nice to have some basic documentation on questions like these.

I don't mean to be difficult and maybe I don't understand, but what is the reason for having a rating?

When I go through the Atelier Cheat Sheet on the connection configuration, it talks about an Eclipse master password and asks for two hints to remember the master password. However, it does not specify the master password. I can only assume the master password is the same as the Cache instance password.

Can anyone shed some light on this master password, where or how it is used, and any other useful information?

I am trying to go through the "Simple Project" in Atelier Workbench User Guide >>> Getting started >>> Basic tutorial.

(http://docs.intersystems.com/atelier/latest/index.jsp)

Under "Using the popup" it says:

Using the popup

Now that we have our project we will create a folder. We will create our folder using the Project Explorer view's popup menu.

Ok, I am trying to do my homework here but seem to be sinking.

I installed Atelier from the link    atelier-1.0.0AT.262.0-win_x64.exe  from at Atelier home page

(https://download.intersystems.com/download/atelier.csp)

Then I install Java from https://java.com/en/download/win10.jsp

I found the Atelier App but it gives this whole page of stuff and at the top it says I have an exit status code of 13.

I have looked through a number of post on Atelier and now am lost.

Any direction please?

Hi, I am trying to understand the transformational methods.

• LogicalToDisplay()
• LogicalToOdbc()
• OdbcToLogical()
• DisplayToDisplay()

I have created a small class with the only property of List as %List, see below.

Class LastName.Demo2 Extends %Persistent
{
Property List As %List;

}
Then I entered the following commands in the Terminal

Set Oref=##class(LastName.Demo2).%New()

FOR I=1:1:5 S $LI(List,I)="Value="_I

Set Oref.List=List

WRITE Oref.ListLogicalToDisplay(Oref.List)

^

<METHOD DOES NOT EXIST> *ListLogicalToDisplay,LastName.Demo2

zw Oref

Oref=<OBJECT REFERENCE>[2@LastName.Demo2]

The data type %Char or %Library.Char

The description says it is a fixed length character field.

How do I set the fixed length?

Or by just setting %Char to something, does that automatically define its length?

Are the parameters MINLEN, MAXLEN involved? Or are these the way I set the fixed length?

Any help with this?

I am working with Caché Relationships.

I know how to iterate through the One side of the relationship and for each One iterate through all the various Manys.

What I have been trying to figure out, is the code (I can put into a Class) that will start at the top of the Manys, iterate down and for each of the Manys, pull the associated One.

I can do this with SQL or Globals, but I want to use only Class type code.

Is that clear? Any help?

I know this may sound like sour grapes, but really it is not.

I hear all the exciting things about the up coming InterSystems Conference, and I am sure it is.

But it is way, way out of my price range, and I am sure out of the price range of most of the Cache/MUMPS developers, without company backing.

Just wondering what others think.

Here is an idea that would make the Developer Community immensely more valuable (to me anyway)

Have the capability of getting Listing output from searches or tags or groups.

In addition, have people put titles on their answers and comments,

And having a detailed list with all the answers and comments if needed

Then being able to sort the list by date or other criteria.

Something like:

Sub1 . . . .

-answer . . .

-comment . .

-answer . . .

Subject2 . . .

-answer . . .

Subject 3 . . .

-comments . . . 

I just tried to read all the Answers and Comments for a post of mine.

Some were 5, 8, 3, etc. days ago and others were just hours ago.

They all seem jumbled up.

If I wanted to read the Answers and Comments in some sort of chronological order, I would be lost.

I don't understand the reasoning on whether somethings is an Answer and others are comments.

But would it be possible to have the option when reading all the follow-ons to re-sort them in some sort of order?

I am experimenting with Relationships, both Parent to Child and One to Many.

I have done some SQL look-ups and have searched through the documentation, however not in a lot detail, but wonder if there are more and better ways to access both sides of Relationships through SQL?

Thank you in advance for any help provided.

I would like to start a discussion regarding Caché Objects and Caché SQL.

It is my understanding that the creators of Caché Objects see Caché SQL as the reporting arm of Objects and as such SQL is essential to Caché Objects.

I once met a Caché Objects programmer who was writing code to $Order through the Globals because that person thought that Caché SQL was too slow and inefficient. I attempted to convince the person otherwise.

So, what say you? Is SQL essential to Caché Objects?

Or

Is Caché SQL a nice to have but we can do without? Is it too slow? Is it too inefficient?

I have a newbie question.

How can a Cache/MUMPS process identify itself to either a process or system.

I have an application running in two different processes and/or systems and want to make minor changes depending upon which process it is in.

What is the easist way to do that.

-thanks

Back in my COBOL days, there was a utility that would analyze running COBOL code and expose bottle necks and those modules that were inefficient or were executed multiple times. This was to help the programmer know where to concentrate streamlining efforts.

Is there any such utility for Caché Routines?

I create the NewBie posts.

And as directed I use the Beginner tags.

However, a lot of people are using the Beginner tags for other posts.

Is there a way for separating the NewBie posts from the other Beginners?

Failing that, can I in someway make the Newbie Index more visible?

I am doing a lot of work on the NewBie Index to make it more useful.