• Article

CheckCancelled méthode

Throws an exception if the query has timed out or been canceled by the user.

Espace de noms :  Microsoft.AnalysisServices.AdomdServer
Assembly :  msmgdsrv (dans msmgdsrv.dll)

Syntaxe

'Déclaration
Public Shared Sub CheckCancelled
'Utilisation

Context.CheckCancelled()

public static void CheckCancelled()

public:
static void CheckCancelled()

static member CheckCancelled : unit -> unit 

public static function CheckCancelled()

Notes

The exception raised by CheckCancelled should be handled, and then rethrown.

Exemples

In the following example, a UDF is defined that takes a very long time to execute. Occasionally, it calls CheckCancelled to determine if the function should exit:

public string LongRunning()
{

    try
    {
        //Enter a long running loop
        for (int nIndex = 0; nIndex < 1000; nIndex++)
        {
            //Exception generated when the query is canceled or Timeout occurs
            Context.CheckCancelled();
            System.Threading.Thread.Sleep(1000);
        }
    }
    catch (System.Exception ex)
    {
        Console.WriteLine(ex.Message);
        throw ex;
    }

    return "UDF Allowed to Finish";
}