Database

Eddy Vluggen wrote:

There's already a record in the "text_data" table that holds the same value in the "Text_Id" field as the one that you're trying to insert. That fails, since a primary key needs to be unique; you can't add two records in the table with the same key.

Error Showing as
****************
1 record(s) converted
File Name:DTRinggit081110Ringgit Extends Downtrend Against Greenback 
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_text_data'. Cannot insert duplicate key in object 'text_data'. 

/data_maintain/News.asp, line 86 

swornavidhya_m wrote:

The "Text_Id" field is the unique one and won't have any duplicates in any case.

swornavidhya_m wrote:

If the recordcount exceeds 3

I are Troll

CREATE FUNCTION [dbo].[GetSubTeacher] (@ID Int)

RETURNS VARCHAR(100)

AS

BEGIN

    DECLARE @TeacherName NVARCHAR(100)
    IF (@ID = 0) BEGIN

       SET @TeacherName = 'NO SUB'
    END
    IF (@ID <> 0) BEGIN
       SET @TeacherName = (SELECT FName + ' ' + LName AS [Name] from Teachers WHERE ID = @ID)
    END
RETURN @TeacherName

END

IF (@ID <> 0)
       SELECT @TeacherName = FName + ' ' + LName AS [Name] from Teachers WHERE ID = @ID

alter FUNCTION GetSubTeacher
(
	@ID integer
)
RETURNS Varchar(100)
AS
BEGIN
	RETURN ( SELECT CASE @ID WHEN 0 THEN 'NO SUB' ELSE ( SELECT FName+' '+LName FROM Teachers WHERE ID=@ID ) END )
END