errorMessages Property

Returns a collection of strings containing the messages of errors, parse errors, or warnings encountered while executing a query with the Execute or ExecuteBatch methods.

Read-only property.

Script Syntax

value = objLogQuery.errorMessages;

Return Value

Remarks

• The object returned by the errorMessages property implements a single read-only _NewEnum property. The _NewEnum property retrieves an IEnumVARIANT interface on an object that can be used to enumerate the collection.
  The _NewEnum property is hidden within scripting languages (JScript and VBScript). Applications written in the JScript language handle objects implementing the _NewEnum property as Enumerator objects or with the for...in statement, while applications written in the VBScript language handle objects implementing the _NewEnum property with the For Each...Next statement.
• If you want to retrieve parse error messages, make sure that the maxParseErrors property of the LogQuery object is set to a value different than -1. If the value of this property is -1 (the default value), the parse error messages will be discarded, and the errorMessages collection will contain a single message stating the total number of parse errors occurred.

Examples

JScript example:

var oLogQuery = new ActiveXObject("MSUtil.LogQuery");

// Make sure that parse error messages are collected
oLogQuery.maxParseErrors = 100;

// Create query text
var strQuery = "SELECT sc-bytes INTO C:\\output.csv FROM ex040528.log";

// Execute query
oLogQuery.ExecuteBatch( strQuery );

// Check if errors occurred
if( oLogQuery.lastError != 0 )
{
    WScript.Echo("Errors occurred!");

    var oMessages = new Enumerator( oLogQuery.errorMessages );
    for(; !oMessages.atEnd();  oMessages.moveNext())
    {
        WScript.Echo("Error message: " + oMessages.item());
    }
    
}
else
{
    WScript.Echo("Executed successfully!");
}

VBScript example:

Dim oLogQuery
Dim strQuery

Set oLogQuery = CreateObject("MSUtil.LogQuery")

' Make sure that parse error messages are collected
oLogQuery.maxParseErrors = 100

' Create query text
strQuery = "SELECT sc-bytes INTO C:\output.csv FROM ex040528.log"

' Execute query
oLogQuery.ExecuteBatch strQuery

' Check if errors occurred
If oLogQuery.lastError <> 0 Then

    WScript.Echo "Errors occurred!"

    For Each strMessage In oLogQuery.errorMessages
        WScript.Echo "Error Message: " + strMessage
    Next

Else

    WScript.Echo "Executed succesfully!"

End If

See also:

© 2004 Microsoft Corporation. All rights reserved.