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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Stored Procedure Question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-16 : 08:48:49
Joe writes "Hi Guys -

I wrote a simple stored procedure in SQL2000. I'm calling it from VB 6.

I have one a select statement which works fine in both VB and QA but if I have one right after another it return the result ok in the query analyzer but not from my VB test app.

This is just an example....@Lang is passed in

SELECT TextString FROM LocaleTable WHERE locale = @Lang

IF (@@Rowcount = 0)
BEGIN
SELECT TextString FROM LocaleTable WHERE locale = 'en-us'
END

RETURN
GO


Is there someting special I need to do with cursors?????

Thanks for your help,

Joe"
   

- Advertisement -