private void SQLButton_Click(object sender, EventArgs e)
        {
            if (CheckError())
            {
                return;
            }

            Aras.IOM.Item result = innovator.applySQL("select login_name, first_name, last_name from [user]");
            if (result.isError())
            {
                msgBox.AppendText("\n\nSQL Error: " + result.getErrorDetail());
                return;
            }
            result = result.getItemsByXPath("//Item");
            msgBox.AppendText("\n\nSQL Found " + result.getItemCount() + " User Items:\n");
            for (var i = 0; i < result.getItemCount(); i++)
            {
                msgBox.AppendText("\n   " + (i + 1) + "  " + result.getItemByIndex(i).getProperty("first_name", "na") + " " + result.getItemByIndex(i).getProperty("last_name", "na"));
            }
        }
        private void AMLButton_Click(object sender, EventArgs e)
        {
            if (CheckError())
            {
                return;
            }

            Aras.IOM.Item result = innovator.applyAML("<AML><Item type='User' action='get' select='first_name,last_name'></Item></AML>");
            if (result.isError())
            {
                msgBox.AppendText("\n\nAML Error: " + result.getErrorDetail());
                return;
            }

            result = result.getItemsByXPath("//Item");
            msgBox.AppendText("\n\nAML Found " + result.getItemCount() + " User Items:\n");

            for (var i = 0; i < result.getItemCount(); i++)
            {
                msgBox.AppendText("\n   " + (i + 1) + "  " + result.getItemByIndex(i).getProperty("first_name", "na") + " " + result.getItemByIndex(i).getProperty("last_name", "na"));
            }
        }
        private void QueryButton_Click(object sender, EventArgs e)
        {
            if (CheckError())
            {
                return;
            }

            Aras.IOM.Item selectUsersItem = innovator.newItem("User", "get");
            selectUsersItem.setAttribute("select", "first_name,last_name");

            selectUsersItem = selectUsersItem.apply();
            if (selectUsersItem.isError())
            {
                msgBox.AppendText("\n\nQuery Error: " + selectUsersItem.getErrorDetail());
                return;
            }
            selectUsersItem = selectUsersItem.getItemsByXPath("//Item[@type='User']");
            msgBox.AppendText("\n\nQuery Found " + selectUsersItem.getItemCount() + " User Items:\n");
            for (var i = 0; i < selectUsersItem.getItemCount(); i++)
            {
                msgBox.AppendText("\n   " + (i + 1) + "  " + selectUsersItem.getItemByIndex(i).getProperty("first_name", "na") + " " + selectUsersItem.getItemByIndex(i).getProperty("last_name", "na"));
            }
        }