>I'm new to VB so I may be going about this all wrong, but here's what I want to do and the problem I'm having. I have a form that creates a recordset from a SQL stored procedure. I want to use this recordset as a datasource for a crystal report. Here's the command I use to create the recordset
>
>rstletter.Open "custlett ('" & Trim(job) & " ')", _
> g_objConn, adOpenDynamic, adLockOptimistic, adCmdStoredProc
>
>I get the error "error detected by database DLL" when it attempts to run the following line of code.
>
>Report.Database.AddADOCommand rstletter.ActiveConnection, rstletter.ActiveCommand
>
>Any ideas?
>
>TIA
>
>Kris
Kris,
I have not used the .AddADOCommand Method so I am not familiar with it. There is an FAQ (
http://www.levelextreme.com/wconnect/wc.dll?UniversalThread~?2,33,Forum=21,29,779) that I just put out there on using the .SetDataSource event. It is a little different than what you do, but you might check it out and see if that helps.
GW Gross
"You are blessed when you're content with just who you are - no more, no less." Matthew 5:5 (The Message)