Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-19 : 07:45:10
|
| Venkat writes "Hi I am Calling a stored procedure in Sql Server 7.0 from Visual Basic 6.0 with the GroupID as the argument.This stored procedure calls 3 more procedures for each customer belongs to the GroupID passed using a cursor.i.e, if i call the procedure for groupid = 103 then this procedure calls 3 more procedures for each customerid under groupid = 103.Problem:The procedure only executes for the few customers in the groupthen exits with out giving any error.This procedure is not executing for all customers nor giving any error.To add to this, if I open the cursor in descending order of the customer ids, it executes for all customers (i.e., process for 200, then 199, then 198 and so on).But when i try to process in the ascending order of the customer ids (i.e, 198 first, then 199 and then 200).Even Sql Profilier does not show any error nor message.More Information : (MDAC installed is 2.5)Any help is greatly appreciated.Many Thanks" |
|
|
dsdeming
479 Posts |
Posted - 2003-08-19 : 07:58:36
|
| You really need to post the procedure if you hope to get an answer to this.Dennis |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-08-19 : 09:06:55
|
| What happens if you pass your argument to the procedure in query analyzer? You should try that to see if your error lies within the VB code or the connection type.-------Moo. :) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-19 : 09:08:35
|
| Which service pack? This sort of behaviour happenned before sp2.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Stored procedure exits abruptly