Toad World® Forums

editor issues #2


#1

Hi,
new issues[?]:

  1. following sql script causes Toad to show me exception listed below:
    When I run part by part it is ok.

IF OBJECT_ID(‘TC49’,‘U’) IS NOT NULL BEGIN
DROP TABLE TC49
END
GO

CREATE TABLE TC49(
JobID INT ,
Technician VARCHAR ( 20 ),
Grade TINYINT ,
StartTime SMALLDATETIME ,
EndTime SMALLDATETIME
)
GO

INSERT INTO TC49(JobID, Technician, Grade, StartTime, EndTime)
SELECT 1 , ‘Michael’, 1 , ‘2010-01-01 09:08:00’, ‘2010-01-01 12:00:00’
UNION ALL
SELECT 1 , ‘John’, 2 , ‘2010-01-01 13:00:00’, ‘2010-01-01 16:24:00’
UNION ALL
SELECT 1 , ‘Steve’, 3 , ‘2010-01-01 08:53:00’, ‘2010-01-01 16:53:00’

Exception:

System.NullReferenceException
Odwołanie do obiektu nie zostało ustawione na wystąpienie obiektu.

int_1.jpeg
int_1.jpeg