mooSetLikeCase(“ [yes|no] “)


Sets the Oracle OLAP LIKECASE option.


Syntax


               mooSetLikeCase("[yes|no]")


Return Value


               BOOLEAN

Example


Public Sub mooSetLikeCase()

'Sets the likecase Option in Oracle OLAP


Dim boo As Boolean


If Not oregistered Then:   boo = regQ:


'Check Im connected if not connect

If Not   o.connected Then

   boo = o.connect

   boo = o.connected

   Else

   boo = True

End If


'Connected so execute

If boo = True Then

    boo = o.mooSetLikeCase("NO")

    boo = o.wrap_runNonQ("show LIKECASE"): Debug.Print (o.mooGetDML)

    Else

   'Something went wrong print any error information

   Debug.Print "Unable to Connect"

   Debug.Print o.getlastmooerr

End If


End Sub


Return Value Example


no