Var i = 1
Begin
numero = 0
Do
numero = numero + i
Select Case Client_new.Modification
Case Modification
If Client_complet.num_SAP = Client_new.num_SAP And Client_complet.Nom_Prenom = Client_new.Nom_Prenom Then
Update Client_complet.num_SAP, Client_complet.Nom_Prenom
End If
Case Supression
If Client_complet.num_SAP = Client_new.num_SAP And Client_complet.Nom_Prenom = Client_new.Nom_Prenom Then
Delete Client_complet.num_SAP, Client_complet.Nom_Prenom, Client_complet.Societe, Client_complet.Service, Client_complet.Code_postal, Client_complet.Ville, Client_complet.Adresse1, Client_complet.Adresse2, Client_complet.Tel, Client_complet.Fax, Client_complet.Code_TCF, Client_complet.Categorie_client, Client_complet.Mail, Client_complet.Champ14, Client_complet.Champ15
End If
Case Ajout
INSERT Client_new(Numéro, num_SAP, Nom_Prenom, Societe, Service, Code_postal, Ville, Adresse1, Adresse2, Tel, Fax, Code_TCF, Categorie_client, Mail, Champ14, Champ15)
INTO Client_complet(Numéro, num_SAP, Nom_Prenom, Societe, Service, Code_postal, Ville, Adresse1, Adresse2, Tel, Fax, Code_TCF, Categorie_client, Mail, Champ14, Champ15)
i = i + 1
Loop Until numero = 5000
End
Partager