Iryna Mykhailova · Aug 16, 2023 go to post

Can you open in your browser the address that you have in parameter LOCATION of your class that extends  %SOAP.WebClient? You should at least get an error "Invalid action" if your SOAP server is created in IRIS.

Iryna Mykhailova · Jun 27, 2023 go to post

In IRIS there are no built-in constructors. Classes that don't inherit from a system class are usually used as storage for class methods.  Therefore, if you want to create an object you need to inherit your own class from one of the system classes, like %RegisteredObject (won't save your objects to the database), %SerialObject (won't save your objects to the database on its own), %Persistent (will save your objects to the database) etc. For example:

Class Sample.Header extends %Persistent
{
Property Key As %String;
Property Show As %Boolean;
}
Iryna Mykhailova · Jun 14, 2023 go to post

You're not executing it:

vism1.Execute(cmd);

To make it shorter, can be

vism1.Execute('$$Check^logininput()');
sResult:=vism1.Value;

You can also find an example in this GitHub repository.

Iryna Mykhailova · May 17, 2023 go to post

For me it's a horrible news 😭 I really prefer to use Studio when explaining how to create properties (particularly relationships) and queries (particularly Class Queries based on COS) to students who see IRIS for the first and the last time during my classes. And when something goes wrong (and it does a lot of the time) it's usually easier to ask them to delete the code that produces error and rewrite it while I'm looking than to figure out what's wrong with it. And if it something more complicated than simple properties it can take a lot of time.

Besides, not all students know (and want/need to learn) how to use VS Code and look for proper plug-ins, extensions etc. It will really make my life that much harder.

Iryna Mykhailova · May 10, 2023 go to post

This is a great opportunity to take and exam for free in a nice friendly setting. Therefore, I would definitely recommend using this opportunity.

Iryna Mykhailova · Apr 28, 2023 go to post

From what I understand in the article, in Caché 5.0 and earlier versions the modern Management Portal is called System Management Portal.

Iryna Mykhailova · Apr 17, 2023 go to post

I see that it's a known situation, they even added a NB in the post:

NB Dear contestants, please take into consideration that support for the contest cloud sql environment is only available during business hours M-F 9-5 US Eastern Time. We seem to be experiencing a failure of the cloud environment such that deployments are stuck in Pending status for some users.

Iryna Mykhailova · Mar 16, 2023 go to post

Before:

Query GetAllOlderThan(Age As %Integer = 65) As %Query(ROWSPEC = "Name:%Name,Age:%Integer") [ SqlProc ]
{
}

ClassMethod GetAllOlderThanExecute(ByRef qHandle As %Binary, Age As %Integer = 65) As %Status
{
    set qHandle = $lb($random(200), 0)
    Quit $$$OK
}

ClassMethod GetAllOlderThanClose(ByRef qHandle As %Binary) As %Status [ PlaceAfter = GetAllOlderThanExecute ]
{
    set qHandle = ""
    Quit $$$OK
}

ClassMethod GetAllOlderThanFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ PlaceAfter = GetAllOlderThanExecute ]
{
    if $ListGet(qHandle, 2) = $ListGet(qHandle, 1)
    {
       Set Row = ""
       set AtEnd = 1
    } else
    {
       Set Row = $Lb(##class(%PopulateUtils).Name(), ##class(%PopulateUtils).Integer(18, 90))
       set $list(qHandle, 2) = $list(qHandle, 2) + 1
    }
    Quit $$$OK
}

After:

Query GetAllOlderThan(Age As %Integer = 65) As %Query(ROWSPEC = "Name:%Name,Age:%Integer") [ SqlProc ]
{
}

ClassMethod GetAllOlderThanExecute(ByRef qHandle As %Binary, Age As %Integer = 65) As %Status
{
    set qHandle = $lb($random(200), 0, Age)
    Quit $$$OK
}

ClassMethod GetAllOlderThanClose(ByRef qHandle As %Binary) As %Status [ PlaceAfter = GetAllOlderThanExecute ]
{
    set qHandle = ""
    Quit $$$OK
}

ClassMethod GetAllOlderThanFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ PlaceAfter = GetAllOlderThanExecute ]
{
	if $ListGet(qHandle, 2) = $ListGet(qHandle, 1)
	{
		Set Row = ""
		set AtEnd = 1
	} else
	{
    	Set Row = $Lb(##class(%PopulateUtils).Name(), ##class(%PopulateUtils).Integer($ListGet(qHandle, 3), 90))
    	set $list(qHandle, 2) = $list(qHandle, 2) + 1
	}
    Quit $$$OK
}

}
Iryna Mykhailova · Mar 16, 2023 go to post

> Hi @Iryna Mykhailova and welcome to the Tutorials Contest.

Why, thank you wink

Both %SQLQuery and %Query are class queries. As for the Studio - I do believe it's the easiest way for people who start working with IRIS to get acquainted with the technology!

You are right, I forgot to keep in mind that I have a parameter for the second example. I will correct it to reflect that I'm looking for people older than the exact age. Thanks for the heads-up!

Iryna Mykhailova · Mar 16, 2023 go to post

I know about multidimensional properties. But at this pint they aren't even listed as an option in the Wizard. And I'm not sure they are that useful for modern applications. I would guess their use was to transition applications from hierarchical model to object model. 

Iryna Mykhailova · Mar 15, 2023 go to post

Yes, and what I love about it - you can use any ODBC based tool and write a simple SQL select and voila:

Iryna Mykhailova · Dec 13, 2022 go to post

Ok, I found it. It was Ctrl+/

But I have several / on my keyboard and only the one on the main keyboard (with letters) works. 

Iryna Mykhailova · Dec 12, 2022 go to post

I don't really care what are the exact keystrokes, I just want them to work, and they don't  crying

Iryna Mykhailova · Dec 11, 2022 go to post

Sure, I know /* */ work.

But students use different IDEs so they get used to some behavior and adding multiline comments is apparently one of them. In my Studio it shows like this and the menu works but the shortcuts don't.

Iryna Mykhailova · Nov 30, 2022 go to post

Thank you blush I had to figure out how this whole thing works (and to search lots of sites to get the general idea) so decided it would be nice to share the basics with others as well.

Iryna Mykhailova · Nov 13, 2022 go to post

Will this do, to have both delete and update:

CREATE TABLE nodes2 (
        name VARCHAR(50) NOT NULL, 
        parent VARCHAR(50), 
        PRIMARY KEY (name), 
        FOREIGN KEY(parent) REFERENCES nodes (name) ON UPDATE cascade on DELETE cascade
)
Iryna Mykhailova · Nov 10, 2022 go to post

Yes, that's what I did (because, obviously, the class being abstract is not the cause - works great in other scenarios):

Class Test.NewClass Extends %Persistent [ Abstract, NoExtent ]
{}

Class Test.NewClass1 Extends Test.NewClass
{}

I do know you don't inherit all from the secondary class, but I though the number of things I do inherit was more than just parameters, properties and methods. I take it queries, foreign keys, triggers, projections are out as well?

Iryna Mykhailova · Jul 23, 2022 go to post

Yes, I do have a DLL. Besides, the rest of the menu items are OK.

The same problem with About screen: