I have a stored procedure (sql Server 7) which gets a record count.  I do
not know how to get this back to vb as a return value.  I simplified version
of what I would like to do follows:

create procedure GetCount
as

The vb would then call the procedure as follows:

count=getcount

return a count without using a recordset.  How can I do that?

Thanks much
Les Morganstein

you probably have a good reason to construct your SQL string in code. Try
this:

create procedure GetCount
as


count(*) from myTable where Field1 = 6)"


drop procedure spTemp

Hope it helps

--
Dean Vitner, MCP

SPIN Informatica d.o.o. Osijek