I am using an ODBC datasource to
connect to an Oracle database, using
the QueryDef object for the select statement
when I run the same exact query outside
of my app I get a greater number of
records returned (I am not manipulating the
record returned- I check the record count)
I also tried it without using QuerDef and
tried changing the dbDynamic, dbSnapshot
etc. parameters to no avail...
Any suggestions:
Set cConnection = wrkODBC.OpenConnection("Connection1", _
dbDriverNoPrompt, ,"ODBC;DATABASE=xxx;UID=xxx;PWD=xxx;DSN=lcn")
Set qdfTemp = cConnection.CreateQueryDef(""
"SELECT DISTINCT e_mail, first_name, " & _
"last_name FROM webuser")
Set MySet = qdfTemp.OpenRecordset()
MsgBox (MySet.RecordCount)
