July 22, 2002 at 2:11 pm
I have a stored procedure in SQL server 2000 that i'm trying to run from VB. In my VB program I have a data grid that i'm trying to fill with the data that I get from the stored procedure. I have all my conection set up right. But what i'm haveing trouble is is with the way VB actually calls the stored procedure. I also have a data environment that has a command inwhich it calls the stored procedure but the syntax it is using is:
{?=CALL dbo.sp_stats}
what exactly is the '?' for? i'm thinking that is some type of variable that it is looking for but i'm not sure. can someone please help?
thank you
rich
RICHARD KIRMSS
RICHARD KIRMSS
July 22, 2002 at 4:50 pm
De's are truly horrible IMO. Just as easy to write just a little more code and no headaches. Anyway, to figure out what should go there you need to examine the code for sp_stats. All the DE does is open the connection and run the proc to return a recordset, you can do the same thing yourself.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply