- Datensatz mit Myreader einlesen
- Insert-Befehl durch lesen aller Felder im Myreader
- Sql ausführen
Dim sql as String = "Select * from stkl_a where nr = " & copy_from
Dim myreader as i7lib.nxDataReader
Dim upd as New i7lib.CreateUpdate
Dim mydb as New i7lib.nxDB
myreader = mydb.ReadDB(sql)
if mydb.OpenError Then
msgbox( mydb.OpenErrordesc)
End if
While myreader.read
upd.InitInsert("stkl_a")
Dim felder as Double = myreader.FieldCount
For a as Object = 0 to felder -1
upd.SetField(myreader.GetName(a), myreader.GetValue(a))
Next
upd.SetField("nr", copy_to)
sql= upd.GetSQL
'msgbox(sql)
mydb.ExecuteDB(sql)
if mydb.OpenError Then
msgbox( mydb.OpenErrorDesc)
End if
End While
myreader.close()