-
I am getting run-time error "'3669' - execution cancelled" on the following open statement - and can't find anything on '3669' or why it won't work. I tried the sql statement in oracle sql plus and it works fine, but not from VB. I also tried a single table select statement in the open and it worked too. Can anyone help?
Set rsGetAccount = cnRegister.OpenRecordset(m_strMainSelect & strWhereClause, dbOpenDynaset, 0, dbOptimisticValue)
** where m_strMainSelect = select * from aa, bb where aa.mun = bb.mun and aa.dist = bb.dist and aa.procdate = bb.prodate
** strWhereClause = and bb.Account = '13120046' and bb.Cust = '01' order by bb.ProDate;
-
Don't know if you still need this
After the connection is made add the following line.
cnRegister.QueryTimeout = 0
This way it will wait until the recordset is retrieved.
http://msdn.microsoft.com/library/de...erytimeout.htm
