1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Dim wstemp As Workspace
Dim dbtemp As Database
Dim rstemp As Recordset
Dim sql As String
sql = "SELECT OENUMDOC1, OENUMDOC2, OENUMAP, OEPN, ESN, OEATA, OECODTOP, OEREF, OEEXA4, OEEXMM, OEEXJJ " & _
"FROM FROE " & _
"WHERE OEATA='61'"
sql = "SELECT OENUMDOC1 FROM FROE WHERE OEATA='61'"
Set wstemp = DBEngine.Workspaces(0)
Set dbtemp = wstemp.OpenDatabase("", False, False, "ODBC;DSN=amasis;USR=test;PWD=test")
Set rstemp = dbtemp.OpenRecordset(sql, dbOpenDynaset, dbSQLPassThrough)
' Set Db = wrkODBC.OpenDatabase("DSNname", dbDriverNoPrompt, False, "ODBC;DATABASE=;UID=;PWD=;DSN=DSNname")
Do Until rstemp.EOF
MsgBox rstemp(0)
rstemp.MoveNext
Loop |
Partager