1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
Public Function Deduire_bic(ByVal i_compte_deb3 As String) As String
With BICrs
'If .State = adStateOpen Then .Close()
If .State = ConnectionState.Open Then .Close()
.CursorLocation = CursorLocationEnum.adUseServer 'adUseServer
.Open("BIC", cnn, CursorTypeEnum.adOpenKeyset, LockTypeEnum.adLockOptimistic, CommandTypeEnum.adCmdTableDirect)
.Index = "Code_Bic"
'TODO : modif array
.Seek(Array(i_compte_deb3), SeekEnum.adSeekFirstEQ)
If Not .EOF Then
Deduire_bic = ![libelle_Bic]
End If
End With
End Function |