New SQL Table

Source Edit:

Code:

---

TCHAR g_szDB_LOBBY_CHAT[] = _T("{CALL spInsertLobbyChat ('%s', '%s')}");

bool MMatchDBMgr::LobbyChat(const TCHAR* szName, const char* szMsg)
{
        _STATUS_DB_START;
        if (!CheckOpen()) return false;

        CString strSQL;

        try {
                strSQL.Format( g_szDB_LOBBY_CHAT, szName, szMsg );
                m_DB.ExecuteSQL( strSQL );
        }
        catch(CDBException* e) {

                ExceptionHandler(strSQL, e);
                return false;
        }
        _STATUS_DB_END(12);
        return true;
}

---

Code:

---

m_MatchDBMgr.LobbyChat(pObj->GetCharInfo()->m_szName, pszChat);

---

SQL Edit:
GunzDB->Programmability->Stored Procedures (Right Click -New Stored Procedure...)

PHP Code:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spInsertLobbyChat]
@CharNum     smallint,
@CharMessage varchar(MAX)
AS  
SET NOCOUNT ON 
INSERT INTO LobbyChat(CharNum, CharMessage)  
VALUES(@CharNum, @CharMessage) 


---

Save as spInsertLobbyChat.sql

Following Errors:
1) Doesn't add into the Stored Procedures Folder after i save.
2) I tryed to 'Execute' into GunzDB and had this error:

PHP Code:

---

Msg 208, Level 16, State 6, Procedure spInsertLobbyChat, Line 6
Invalid object name 'dbo.spInsertLobbyChat'. 


---

I just need to make this thing and then add table in order to work, any help by correcting the code in 'spInsertLobbyChat.sql' would be good and tell me how to add the Table and make it connect to 'spInserLobbyChat.sql'

first,
make sure there is a table named like "spInserLobbyChat" (i dont tink so)

Spoiler:

PHP Code:

---


USE [GunzDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LobbyChat](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [CharName] [varchar](50) NOT NULL,
    [CharMessage] [text] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
INSERT INTO LobbyChat (CharName, CharMessage) VALUES ('Tankado', 'George is noooooooob') 


---

Coded Writed by Tankado ( coded for George )

Dont look at my insert :P

Quote:

---

Originally Posted by Tankado

first,
make sure there is a table named like "spInserLobbyChat" (i dont tink so)

---

Thanks for You and Omar(Vusion) for fixing my problem, i won't edit the post in order to make people take idea how to add new table and storing it... Bye :thumbup1:

George, If u change this thread (small)
than can u move this as a GUID