I can do this in VFP...

nConnectionHandle = SQLCONNECT('sqlremote')
SQLEXEC(SQLEXEC(nConnectionHandle, 'select * from test', 'temptest')
and I can do this
? SQLEXEC(nConnectionHandle, 'use pubs')
? SQLEXEC(nConnectionHandle, 'sp_who')

and I can do this in VB...
'sActivityDate is my parameter that I would like to pass to FoxPro...
'You can use any date for the test...
sSQL = "select * from " & sView1 & " where trandate = {^" & sActivityDate
& "}"
Set RS1 = Cnn.Execute(sSQL)

The question is how does one run a VFP stored proc or send a parameter for a view from VB?
TIA
GAB