nourwahiba
Messages postés
82
Date d'inscription
mardi 18 octobre 2005
Statut
Membre
Dernière intervention
23 juin 2011
30 mai 2006 à 12:56
rebonjour
le code contenant le paramétrage de ma connection:
Sub Connexion()
Set cn = New ADODB.Connection
With cn
.provider = "SQLOLEDB.1;"
.ConnectionString = " Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=base ;Data source= serveur1 "
.Open
End With
cn.CommandTimeout = 0
Exit Sub
End Sub
le petit bout de code qui donne l'erreur :
un petit resumé conecernant cette fonction : elle me permet de calculer le solde d'un client donner
Function solde()
Dim rsb As New ADODB.Recordset
Dim rsf As New ADODB.Recordset
Dim rsc As New ADODB.Recordset
Dim rse As New ADODB.Recordset
Dim rsr As New ADODB.Recordset
' -1 table bon de livraison
rsb.Open " select client , dat , nbon ,total from bonliv where client = '" & Combo1.Text & "' ", cn
While Not rsb.EOF And Not rsb.BOF
conver (rsb!dat)
cn.Execute "fiche_cl '" & Combo1.Text & "' , '" & dd & "' , '" & rsb!nbon & "' , '" & Str(rsb!total) & "' "
rsb.MoveNext
Wend
'-2 table regfour
rsf.Open " select fourn, dat,obs,versement from regfour where fourn = '" & Combo1.Text & "' ", cn
While Not rsf.EOF And Not rsf.BOF
conver (rsf!dat)
With cmd
.ActiveConnection = cn
.CommandText = " insert into [fiche client] (client,dat1,nbl,enlevement,recouvrement) values ('" & rsf!fourn & "' ,'" & dd & "','" & rsf!obs & "\ Reg Fournisseur" & "','" & Str(rsf!versement) & "',0)"
.Execute
End With
rsf.MoveNext
Wend
'-3 table bon reception
rse.Open " select fournisseur ,brp, dat , mttc from breception where fournisseur = '" & Combo1.Text & "' ", cn
While Not rse.EOF And Not rse.BOF
conver (rse!dat)
With cmd
.ActiveConnection = cn
.CommandText = " insert into [fiche client] (client,dat2,nbe,recouvrement,enlevement) values ('" & rse!fournisseur & "','" & dd & "','" & " BE N°" & rse!brp & "','" & Str(rse!mttc) & "',0)"
.Execute
l'erreur est la au .execute
( avant cette fonction j'ai un petit code qui accede a ma table breception )
End With
rse.MoveNext
Wend
'-4 table bon reintegration
rsr.Open " select numb ,client, dat , mttc from b_retour where client = '" & Combo1.Text & "' ", cn
While Not rsr.EOF And Not rsr.BOF
conver (rsr!dat)
With cmd
.ActiveConnection = cn
.CommandText = " insert into [fiche client] (client,dat2,nbe,recouvrement,enlevement) values ('" & Combo1.Text & "','" & dd & "','" & " BR N°" & rsr!numb & "','" & Str(rsr!mttc) & "',0)"
.Execute
End With
rsr.MoveNext
Wend
'-4 table reglement client
rsc.Open " select obs ,client, dat , versement from regclient where client = '" & Combo1.Text & "' ", cn
While Not rsc.EOF And Not rsc.BOF
conver (rsc!dat)
With cmd
.ActiveConnection = cn
.CommandText = " insert into [fiche client] (client,dat2,nbe,recouvrement,enlevement) values ('" & rsc!client & "' ,'" & dd & "','" & rsc!obs & "\ Reg Client" & "','" & Str(rsc!versement) & "',0)"
.Execute
End With
rsc.MoveNext
Wend
rsc.Close
rsr.Close
rse.Close
rsf.Close
End Function
j'espere que vous pourriez comprendre un peu ce code?
merci pour votre aide