Bug in insert-command

QuestionsBug in insert-command
Arne asked 11 years ago

Hi Abu
I got error every time I try to insert new records to all my tables.
Edit old ones is ok.

The error I got is:

—-
Couldn't execute query. SQLState: 22018 Error Code: 245 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value 'jqg1' to data type int. – UPDATE [INDIT].[dbo].[person] SET personNavn='something',initialer='xttre' WHERE id IN ('jqg1')
—-

I am using the + sign on the command line to insert new records in inline mode.
I think you do something wrong here as this is INSERT – not UPDATE as you try (what I can see from the debug message).

If I use the other + sign on the command line for schema to insert new records it works fine.

Could you fix this please as I am using the inline insert mode – I think this is more user-friendly.

I got new version by email from you at February the 3. – complete lib -js.zip. I don't know how to read out the version.

1 Answers
Abu Ghufran answered 11 years ago

Hello,

I'm emailing you updated sample.

Your Answer

18 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?