Mysqlloader conflictoptions doesn`t work
Posted: Tue 03 Apr 2012 14:59
Hi, i have this code
Con and conlokal are different Server.
Createcolumns and replace doesn`t work with loadtable, i will replace the conlokal database with the Data from con.
Can this the Mysqlloader class?
Thanks
Denker
Code: Select all
Public Property options As New MySqlLoaderOptions
sub test ()
Dim cmd As New MySqlCommand
Dim datatable As New MySqlDataTable
Dim mloader As New MySqlLoader
options.ConflictOption = MySqlLoaderConflictOption.Replace
cmd.Connection = con
cmd.open
cmd.CommandText = "Select " & auswahl & " from " & table & " where id > 10 "
datatable.SelectCommand = cmd
datatable.Fill()
mloader.Connection = conlokal
mloader.TableName = table
mloader.Open()
mloader.CreateColumns()
mloader.LoadTable(datatable)
mloader.Close()
end sub
Createcolumns and replace doesn`t work with loadtable, i will replace the conlokal database with the Data from con.
Can this the Mysqlloader class?
Thanks
Denker