Having trouble with inserting the c

[TNN]

Having trouble with inserting the call for a SQL procedure into the open statement for a recordset. Code as follows:

adoRsF3Screen.CursorType =adOpenStatic
adoRsF3Screen.LockType = adLockOptimistic
adoRsF3Screen.Open Source:=DisplayF3 strEmployee_Number, _
ActiveConnection:=adoConnection,Options:=adCmdStoredProc

DisplayF3 is a SQL stored procedure, strEmployee_Number is a string variable representing the parameter being passed with the stored procedure.
I believe there must be an error in the way that I am inserting the stored procedure in the Open statement. Do I need a command object somewhere????

Thank You in advance for any help.
TNN Tom
TNPAYROLL@AOL.COM


TOM

http://WWW.TNPAYROLL@AOL.COM

 

[culshaja]

Have a look at other post as I have answered this there.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305