This is the table I am trying to insert data, but when I run my program I keep getting this error;
Column 'PrinterID' does not belong to table Printers.
I have recreated this table twice. Also this is the stored procedure I use. I use this same schema for my other tables and they work fine. Is this enough information? What am I doing wrong?
PrinterID uniqueidentifier Unchecked
PrinterName varchar(25) Unchecked
PrinterModel varchar(10) Checked
PrinterPhase varchar(8) Checked
PrinterConnectionType varchar(10) Checked
PrinterIPAddress varchar(15) Checked
PrinterVoltage varchar(8) Checked
PrinterLocation varchar(25) Checked
PrinterAssignment varchar(15) Checked
PrinterPurpose varchar(15) Checked
PrinterContent varchar(15) Checked
PrinterSides varchar(10) Checked
PrinterFaxStationName varchar(25) Checked
PrinterFaxID varchar(25) Checked
PrinterNotes varchar(2500) Checked
PrinterSerialNumber varchar(15) Checked
PrinterTLINumber varchar(15) Checked
PrinterActive bit Checked
PrinterRetired bit Checked
PrinterOnHold bit Checked
PrinterReasonForUpdate varchar(2500) Checked
PrinterSetupDate smalldatetime Checked
PrinterRetiredDate smalldatetime Checked
PrinterRetiredCount int Checked
PrinterUpdateDate smalldatetime Unchecked
USE [LabReports]
GO
/****** Object: StoredProcedure [dbo].[InsertPrinter] Script Date: 06/21/2010 22:37:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Robert Blot
-- Create date: 04/04/2010
-- Description: This procedure will INSERT a printer into the Printers table
-- =============================================
ALTER PROCEDURE [dbo].[InsertPrinter]
-- Add the parameters for the stored procedure here
@PrinterID uniqueidentifier,
@PrinterName varchar(25),
@PrinterModel varchar(10),
@PrinterPhase varchar(8),
@PrinterConnectionType varchar(10),
@PrinterIPAddress varchar(15),
@PrinterVoltage varchar(8),
@PrinterLocation varchar(25),
@PrinterAssignment varchar(15),
@PrinterPurpose varchar(15),
@PrinterContent varchar(15),
@PrinterSides varchar(10),
@PrinterFaxStationName varchar(25),
@PrinterFaxID varchar(25),
@PrinterNotes varchar(2500),
@PrinterSerialNumber varchar(15),
@PrinterTLINumber varchar(15),
@PrinterActive bit,
@PrinterRetired bit,
@PrinterOnHold bit,
@PrinterReasonForUpdate varchar(2500),
@PrinterSetupDate smalldatetime,
@PrinterRetiredDate smalldatetime,
@PrinterRetiredCount int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO Printers
(PrinterID, PrinterName, PrinterModel, PrinterPhase, PrinterConnectionType,
PrinterIPAddress, PrinterVoltage, PrinterLocation, PrinterAssignment, PrinterPurpose,
PrinterContent, PrinterSides, PrinterFaxStationName, PrinterFaxID, PrinterNotes,
PrinterSerialNumber, PrinterTLINumber, PrinterActive, PrinterRetired, PrinterOnHold,
PrinterReasonForUpdate, PrinterSetupDate, PrinterRetiredDate, PrinterRetiredCount,
PrinterUpdateDate)
VALUES
(@PrinterID, @PrinterName, @PrinterModel, @PrinterPhase, @PrinterConnectionType,
@PrinterIPAddress, @PrinterVoltage, @PrinterLocation, @PrinterAssignment, @PrinterPurpose,
@PrinterContent, @PrinterSides, @PrinterFaxStationName, @PrinterFaxID, @PrinterNotes,
@PrinterSerialNumber, @PrinterTLINumber, @PrinterActive, @PrinterRetired, @PrinterOnHold,
@PrinterReasonForUpdate, @PrinterSetupDate, @PrinterRetiredDate, @PrinterRetiredCount,
GETDATE())
END
