VB6: connecting the dots from code to the Data Environment object to a stored proc?
Posted on 2003-11-10
So I've got a stored proc in my SQL Server2K db, and the stored proc is called fred.
It's expecting an int from the code, and it will return a bunch of records.
I want to put this stored proc into my global Data Environment object (cleverly named "de1"), and then, from the code, call the Data Environment/stored proc (passing an integer), and get the results in a local recordset in my code.
Can someone show me a simple code example (with explanation, preferably) that illustrates these things?