5/20/2015

SQL Query for classification description updating

If you want update description of classification, you have to update field "description" in two tables. Example:
update classstructure set description = 'Description' where classificationid = 'IT010303'
update classification set description = 'Description' where classificationid = 'IT010303'

5/18/2015

Maximo Jars for Maximo Java Development

1. maximo\lib\*.jar
2. maximo\lib\j2ee.jar
Extracted from maximo.ear:
3. businessobjects.jar
4. maximouiweb.war\WEB-INF\classes (zipped to maximouiweb.jar)

5/08/2015

Simple Excel VBA macros for swapping two rows

Sub SwapRanges()
  Dim ra As Range: Set ra = Selection
  msg1 = "You have to select TWO ranges of cells of the same size"
  msg2 = "You have to select 2 ranges of cells of the SAME size"
  If ra.Areas.Count <> 2 Then MsgBox msg1, vbCritical,"Error":Exit Sub
  If ra.Areas(1).Count <> ra.Areas(2).Count Then MsgBox msg2, vbCritical,"Error":Exit Sub
  Application.ScreenUpdating = False
  arr2 = ra.Areas(2).Value
  ra.Areas(2).Value = ra.Areas(1).Value
  ra.Areas(1).Value = arr2
End Sub
p.s.
And not only rows. You can swap any 2 equal areas:

How to use VBA macros:

5/07/2015

Hide the Search panel on the Start center in IBM Control Desk 7.5.3, 7.5.1.2



If you want to hide Search panel on Start center and make expanded by default "Go To Application" menu in IBM Control Desk 7.5.3, 7.5.1.2, you have to do the following steps:

1. Go To > System Configuration > Application Designer
2. Select Action > Export System XML

5/04/2015

How to hide the additional search panel in the applications

If you want to hide this new panel, which have been appeared in the latest versions of SmartCloud Control Desk 7.5.3 (7.5.1.2), you have to change System property
mxe.webclient.searchMenubar from 1 to 0.

Before changing:

and the result will be next: