Tantra Freelancer
- Joined
- Apr 9, 2014
- Messages
- 541
- Reaction score
- 23
/****** Object: StoredProcedure [dbo].[hb_tan_gp_userinfo_se] Script Date: 09/21/2014 18:05:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[hb_tan_gp_userinfo_se]
[USER=1335]user[/USER]Id AS nvarchar(64)
AS
DECLARE [USER=315880]cas[/USER]hBalance AS INT
SELECT [USER=315880]cas[/USER]hBalance = cashBalance FROM tblUserInfo WHERE userId = [USER=1335]user[/USER]Id AND apply = 1
IF(@@ROWCOUNT = 0)
SET [USER=315880]cas[/USER]hBalance = -1
SELECT [USER=315880]cas[/USER]hBalance AS cashBalance
GO
Create a ODBC to billcrux_phil Data Base and configure config.txt with this ODBC.
The problem is the hb_tan_gp_userinfo_se store procedure, if you still have the same problem you can execute the next code in your billcrux_phil Data Base.
Code:/****** Object: StoredProcedure [dbo].[hb_tan_gp_userinfo_se] Script Date: 09/21/2014 18:05:14 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[hb_tan_gp_userinfo_se] @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Id AS nvarchar(64) AS DECLARE @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance AS INT SELECT @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance = cashBalance FROM tblUserInfo WHERE userId = @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Id AND apply = 1 IF(@@ROWCOUNT = 0) SET @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance = -1 SELECT @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance AS cashBalance GO