SQL Error

[Toni]

Can anyone tell me what the following message means and what
I need to do to correct this problem? When trying to insert
data into the following table QA_SUB_DATES
QS_ID INT, PRIMARY KEY, IDENTITY
QS_REVISION CHAR, 7
QS_QA_IN_DATE, DATE
QS_QA_OUT_DATE, DATE
QS_TYPE_TID, SMALLINT
(At this time, I don`t have any foreign keys or indexes set on this table.)

I receive the following error:
`Msg 260, Level 16, State1
Disallowed implicit conversion from datatype `varchar`to datatype
`smallint`
Use the CONVERT function to run this query.`

I am trying to insert using the following select statement:
`Insert into QA_SUB_DATES values ("9A", "01-01-98", "01-02-98", "11")

Any suggestions? Thanks in advance for your help. I appreciate it!
Toni

[Jasper]

On 10/6/98 7:25:09 AM, Toni wrote:

The field QS_TYPE_TID will not accept CHAR only SMALLINT data. SQL Server will not convert CHAR to SMALLINT without explicit use of Convert function.

Try the following

INSERT INTO QA_SUB_DATES
VALUES ("9A", "01-01-98", "01-02-98", CONVERT(INT, "11") )

or

INSERT INTO QA_SUB_DATES
VALUES ("9A", "01-01-98", "01-02-98", 11)

Regards
Jasper

[VK]

Remove quotes from 11(QS_TYPE_TID, SMALLINT). Otherwise it`s recognized as varchar field.
Do this:

Insert into QA_SUB_DATES values ("9A", "01-01-98", "01-02-98", 11).

VK.

[Jasper]

On 10/6/98 7:25:09 AM, Toni wrote:

The field QS_TYPE_TID will not accept CHAR only SMALLINT data. SQL Server will not convert CHAR to SMALLINT without explicit use of Convert function.

Try the following

INSERT INTO QA_SUB_DATES
VALUES ("9A", "01-01-98", "01-02-98", CONVERT(INT, "11") )

or

INSERT INTO QA_SUB_DATES
VALUES ("9A", "01-01-98", "01-02-98", 11)

Regards
Jasper

[Toni]

Thank you! It worked! I appreciate the replies.

On 10/6/98 7:25:09 AM, Toni wrote:
> Can anyone tell me what the following message means and what
I need to do
> to correct this problem? When trying to insert
data into the following
> table QA_SUB_DATES
QS_ID INT, PRIMARY KEY,
> IDENTITY
QS_REVISION CHAR, 7

> QS_QA_IN_DATE, DATE

> QS_QA_OUT_DATE, DATE
QS_TYPE_TID,
> SMALLINT
(At this time, I don`t have any foreign keys or indexes set on
> this table.)

I receive the following error:
`Msg 260, Level 16,
> State1
Disallowed implicit conversion from datatype `varchar`to
> datatype
`smallint`
Use the CONVERT function to run this query.`

I am
> trying to insert using the following select statement:
`Insert into
> QA_SUB_DATES values ("9A", "01-01-98", "01-02-98", "11")

Any
> suggestions? Thanks in advance for your help. I appreciate it!
Toni