Jun 8th, 2000, 03:11 AM
Hi,
I am
CREATE PROCEDURE colourUp
AS
Hi,
I am trying to write a stored procedure to alter a
"th_colourUpdate" table by adding "FLAG" column. Data from
"th_colourtest2" table will be inserted into it. This will be updated by a letter 'A' after the insertion. Unfortunately, I keep getting this error message. Any help on this would be much appreciated. Thanks. Below is the SQL script.
Albert
ERROR 207 :Invalid Column name ‘Flag’
Insert Error: Column name or number of supplied values does not match table definition
ALTER TABLE th_colourUpdate
ADD FLAG VARCHAR(1)NULL
/* Additions start from here*/
BEGIN
INSERT INTO th_colourUpdate
SELECT DCRD, COM, COLOUR
FROM th_colourtest2 h
Update th_colourUpdate
Set FLAG = 'A'
Where FLAG IS NULL
END
I am
CREATE PROCEDURE colourUp
AS
Hi,
I am trying to write a stored procedure to alter a
"th_colourUpdate" table by adding "FLAG" column. Data from
"th_colourtest2" table will be inserted into it. This will be updated by a letter 'A' after the insertion. Unfortunately, I keep getting this error message. Any help on this would be much appreciated. Thanks. Below is the SQL script.
Albert
ERROR 207 :Invalid Column name ‘Flag’
Insert Error: Column name or number of supplied values does not match table definition
ALTER TABLE th_colourUpdate
ADD FLAG VARCHAR(1)NULL
/* Additions start from here*/
BEGIN
INSERT INTO th_colourUpdate
SELECT DCRD, COM, COLOUR
FROM th_colourtest2 h
Update th_colourUpdate
Set FLAG = 'A'
Where FLAG IS NULL
END