The only error that I get (because the whole process stops at this point) is that the "OLE IDispatch exception code 429 from capanegocios.CapaNegocios CapaNegocios:.consultaestadocuenta e:\capanegocios.prg Error in line 15 OLE IDispatch exception code 429 from capadatos.CapaDatos CapaDatos: .estadocuenta e:\capadotos.prg Error in line 26 OLE IDis.." line 26 is the open() that I showed in my first message.
but, this is my second open statement. there is another open statement, where I populate another RS for the first form. If I set the active connection to Null, will this make that RS unuseable?
If you can not tell, I am Very new to this ADO stuff.
>Beth,
>If this is a method of a DLL and you want to pass the RS back to a client, >then the RS CursorLocation property needs to be 3 = adUseClient.
>More to your question, to disconnect a recordset you set its >ActiveConnection to Null after the RS has been populated, i.e. after the >Open method has been executed or after another Execute method has returned >an RS with a result set.
>I am not certain that this is the problem in your case, just throwing some >ideas of what could be causing problems. Are you getting any error messages?