home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Programming Tool Box
/
SIMS_2.iso
/
bp_6_93
/
vbwin
/
vbaccess
/
update.txt
< prev
next >
Wrap
Text File
|
1995-02-26
|
2KB
|
89 lines
Option Explicit
Dim HS As String
Sub Form_Load ()
CenterForm Me
HS = "Update"
End Sub
Sub Timer1_Timer ()
Timer1.Enabled = False
Update_Vor
End Sub
Sub Update_Aktion (sTabelle As String)
Dim i As Integer
dOld.RecordSource = sTabelle
dNew.RecordSource = sTabelle
dOld.Refresh
dNew.Refresh
If dOld.Recordset.BOF = False Then
dOld.Recordset.MoveFirst
BeginTrans
Do While dOld.Recordset.EOF = False
dNew.Recordset.AddNew
'Beispiel Update bei ─nderung
'Hier Version 2
If iVersion = 2 And sTabelle = "KUNDE" Then
For i = 0 To 5
dNew.Recordset.Fields(i) = dOld.Recordset.Fields(i)
Next
'neues Feld Vorbelegung
dNew.Recordset.Fields("Anzahl") = "1"
Else
'Standard update,
'wenn keine ─nderung
For i = 0 To dOld.Recordset.Fields.Count - 1
dNew.Recordset.Fields(i) = dOld.Recordset.Fields(i)
Next
End If
dNew.Recordset.Update
dOld.Recordset.MoveNext
Loop
CommitTrans
End If
dNew.Recordset.Close
dOld.Recordset.Close
End Sub
Sub Update_Vor ()
Dim iCount As Integer
Dim sTab1 As String
Dim sTab2 As String
Dim sTName As String
Screen.MousePointer = HOURGLASS
sTab1 = "Die Tabelle "
sTab2 = "wird umgewandelt."
'bitte richtigen Datenbanknamen
'und Tabellen-Namen eintragen !!!!
dOld.DatabaseName = "Stamm.old"
dNew.DatabaseName = "Stamm.mdb"
For iCount = 1 To 7
Select Case iCount
'zuerst abhΣngige Tabellen
'Master: Detail
Case 1: sTName = "ZUBEH╓R"
Case 2: sTName = "ZUBEH╓R_ART"
Case 3: sTName = "ZUBEINZEL"
Case 4: sTName = "AUFTRAG"
Case 5: sTName = "STL_AUFTRAG"
'unabhΣngige Tabellen
Case 6: sTName = "KUNDE"
Case 7: sTName = "SETTINGS"
End Select
lblTabelle = sTab1 & sTName & sTab2
lblTabelle.Refresh
Update_Aktion sTName
Next
Screen.MousePointer = DEFAULT
Unload Me
End Sub