mooSetCommas(“ [yes|no] ”)


Sets the Oracle OLAP COMMAS option


Syntax


               mooSetCommas("[yes|no]")


Return Value


               BOOLEAN


Example


Public Sub mooSetCommas()


'Sets the COMMAS 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.mooSetCommas("NO")  ' YES or NO

    boo = o.wrap_runNonQ("show Commas"): 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