Error Event (MySqlDump)

In This Topic

Occurs when a SQL statement within dump script has produced an error.

Syntax

Visual Basic
C#


'Declaration Public Event Error As ScriptErrorEventHandler


public event ScriptErrorEventHandler Error

Event Data

The event handler receives an argument of type ScriptErrorEventArgs containing data related to this event. The following ScriptErrorEventArgs properties provide information specific to this event.

Property	Description
Exception	Gets the System.Exception instance that DbScript throws.
Ignore	Gets or sets whether the current error will be ignored or not.
Length	Gets length of statement where an error occurred.
LineNumber	Gets number of the line where an error occurred.
LinePosition	Gets position in the line where an error occurred.
Offset	Gets offset of statement where an error occurred.
StatementType	Gets type of the statement that caused an error.
Text	Gets SQL statement where an error occurred.

Remarks

This event can be generated by the Restore method when an error occurs during script execution. In the event handler you can choose whether to ignore the error and continue or to stop execution. The Devart.Common.ScriptErrorEventArgs object available in event handler provides information about the statement that initiated the error.

Example

csharp


private static void myDump_Error(object sender, Devart.Common.ScriptErrorEventArgs e) { Console.WriteLine("Invalid query:"); Console.WriteLine(e.Text); Console.WriteLine("At line: " + e.LineNumber.ToString()); } static void Main(string[] args) { MySqlConnection myConnection = new MySqlConnection(); myConnection.ConnectionString = "User Id=root;Password=root;Host=localhost;Port=3306;Database=Test;"; myConnection.Open(); MySqlDump myDump = new MySqlDump(); myDump.Connection = myConnection; myDump.Error += new Devart.Common.ScriptErrorEventHandler(myDump_Error); try { myDump.Restore("d:\\tmp\\mydump.dmp"); } finally { myConnection.Close(); } }

private static void myDump_Error(object sender, Devart.Common.ScriptErrorEventArgs e)
{
  Console.WriteLine("Invalid query:");
  Console.WriteLine(e.Text);
  Console.WriteLine("At line: " + e.LineNumber.ToString());
}

static void Main(string[] args)
{
  MySqlConnection myConnection = new MySqlConnection();
  myConnection.ConnectionString = "User Id=root;Password=root;Host=localhost;Port=3306;Database=Test;";
  myConnection.Open();

  MySqlDump myDump = new MySqlDump();
  myDump.Connection = myConnection;

  myDump.Error += new Devart.Common.ScriptErrorEventHandler(myDump_Error);

  try
  {
    myDump.Restore("d:\\tmp\\mydump.dmp");
  }
  finally
  {
    myConnection.Close();
  }
}

Visual Basic


Private Shared Sub myDump_Error(ByVal sender As Object, ByVal e As Devart.Common.ScriptErrorEventArgs) Console.WriteLine("Invalid query:") Console.WriteLine(e.Text) Console.WriteLine(("At line:" & e.LineNumber.ToString)) End Sub Shared Sub Main(ByVal args As String()) Dim myConnection As New MySqlConnection myConnection.ConnectionString = "User Id=root;Password=root;Host=localhost;Port=3306;Database=Test;"; myConnection.Open() Dim myDump As New MySqlDump myDump.Connection = myConnection myDump.ExportAll = True AddHandler myDump.Error, AddressOf myDump_Error Try myDump.Restore("d:\\tmp\\mydump.dmp") Finally myConnection.Close() End Try RemoveHandler myDump.Error, AddressOf myDump_Error End Sub

Private Shared Sub myDump_Error(ByVal sender As Object, ByVal e As Devart.Common.ScriptErrorEventArgs)
  Console.WriteLine("Invalid query:")
  Console.WriteLine(e.Text)
  Console.WriteLine(("At line:" & e.LineNumber.ToString))
End Sub

Shared Sub Main(ByVal args As String())
  Dim myConnection As New MySqlConnection
  myConnection.ConnectionString = "User Id=root;Password=root;Host=localhost;Port=3306;Database=Test;";
  myConnection.Open()
  Dim myDump As New MySqlDump
  myDump.Connection = myConnection
  myDump.ExportAll = True

  AddHandler myDump.Error, AddressOf myDump_Error
  Try
    myDump.Restore("d:\\tmp\\mydump.dmp")
  Finally
    myConnection.Close()
  End Try
  RemoveHandler myDump.Error, AddressOf myDump_Error
End Sub

Reference

MySqlDump Class
MySqlDump Members
ScriptErrorEventArgs Class
ScriptErrorEventHandler Delegate

Send Feedback