HI All:
I have a stored procedure on mys sqlserver. The name of the sp is deletedata. How can I execute this sp from vb and pass it the record id? In vfp I use to execute the sp by using the following code:

sqlcmd = 'EXECUTE[CLEAR_EDIFILE] ' + ALLTRIM(edifile)
jtq = SQLEXEC(cn, sqlcmd)

Need to do the same in vb.

Thanks