This is my database it executes with no error.

--Kudler Fine Food Database
Create Database [VALMKudler_Fine_Foods]
On Primary
     (NAME=VALM_KudlerDB,
          FileName="C:\POS410\VALM_KudlerDB_dat.mdf",
          SIZE=10MB,
          MAXSIZE=100MB,
          FILEGROWTH=10%)
--Kudler Fine Foods
LOG ON 
     (NAME="VALM_KudlerDB_log",
           FILENAME="C:\POS410\VALM_KudlerDB_log.Idf",
           SIZE=5MB,
           MAXSIZE=100MB,
           FILEGROWTH=20%)

This is my table it executes with no problems

--Job Tittle Table 
     CREATE TABLE [VALMKudler_Fine_Foods].dbo.tbljobtitle
     ( jobID Int CONSTRAINT PK_jobID PRIMARY KEY Not Null,
       jobEEO_1Class char(40) Not Null,
       jobTitle char(40) Not Null,
       jobDesc char(300) Not Null,
       jobExempt_NonExe char(20) Not Null)

]


This is the insert I'm trying to execute but it keep coming up with errors.

--Accounting Clerk
INSERT INTO[VALMKudler_Fine_Foods].dbo.tbljobtitle
(
[jobID],
[jobEEO_1Class],
[jobTitle],
[jobDesc],
[jobExempt_NonExe]
)
VALUES(
'2000',
'Office/Clerical',
'Accounting Clerk'
'Computes, classifies, records, verifies numerical data for use in maintaining
accounting records.',
'Non Exempt'
)

--Assistant Manager 
INSERT INTO[VALMKudler_Fine_Foods].dbo.tbljobtitle
(
[jobID],
[jobEEO_1Class],
[jobTitle],
[jobDesc],
[jobExempt_NonExe]
)
VALUES(
'2010',
'office/Clerical',
'Assistant Manager',
'Supervises and coordinates activities of workers in department of food store.
Assists store manager in daily operations of store.',
'Exempt'
)

And here is the error message:

Error Message:

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ']'.
Msg 102, Level 15, State 1, Line 51
Incorrect syntax near 'Places customer orders in bags. Performs carryout duties for customers.'.

No matter what I try I still get an error message when I try to execute my inserts. I'll take any suggestions or ideas!

Thanks

Hi,

Just a thought. Can you check the following sql statement

VALUES(
'2000',
'Office/Clerical',
'Accounting Clerk'
'Computes, classifies, records, verifies numerical data for use in maintaining
accounting records.',
'Non Exempt'
)

In this part, for 5 fields values have passed more. This may be the issue in Insert query 1.

FYI, I tried in MySQL ver 5.0 environment, I didn't get error except the above error I specified. 2nd query works fine.

Good luck.

Hi,

Just a thought. Can you check the following sql statement

VALUES('2000','Office/Clerical',
'Accounting Clerk'
'Computes, classifies, records, verifies numerical data for use in maintaining
accounting records.',
'Non Exempt'
)

In this part, for 5 fields values have passed more. This may be the issue in Insert query 1.

FYI, I tried in MySQL ver 5.0 environment, I didn't get error except the above error I specified. 2nd query works fine.

Good luck.

Hi,

Just a thought. Can you check the following sql statement

VALUES('2000','Office/Clerical',
'Accounting Clerk'
'Computes, classifies, records, verifies numerical data for use in maintaining
accounting records.',
'Non Exempt'
)

In this part, for 5 fields values have passed more. This may be the issue in Insert query 1.

FYI, I tried in MySQL ver 5.0 environment, I didn't get error except the above error I specified. 2nd query works fine.

Good luck.

Thanks I tried it but didn't work I think it's something to do with the name of my database!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.