Toad for MySQL - Community for development, administration, tuning, tips and tricks

Forums » General Discussion

Thread: unable to insert a row in a table............and the insertion error is giv

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 1 - Pages: 1 - Last Post: Aug 27, 2012 10:47 AM by: Larsodius

anand_kushwaha

Posts: 1
Registered: 3/20/12

unable to insert a row in a table............and the insertion error is giv
Posted: Mar 20, 2012 7:51 AM

Statusbar:20-Mar-12 7:09:25 PM: Table successfully created (Remembered answer: "OK". Enable)

Statusbar:20-Mar-12 7:11:27 PM: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. Do you want to keep your changes so you can edit them? (Remembered answer: "Yes". Enable)

Statusbar:20-Mar-12 7:13:36 PM: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. Do you want to keep your changes so you can edit them? (Remembered answer: "Yes". Enable)

Statusbar:20-Mar-12 7:13:36 PM: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. (Remembered answer: "Yes". Enable)

Larsodius

Posts: 1
Registered: 8/27/12

Re: unable to insert a row in a table............and the insertion error is giv
Posted: Aug 27, 2012 10:47 AM

in response to: anand_kushwaha

Think you need to set a key on the table. Alter the table and add a Primary key to it.

This worked for me

Pages: 1

Back to Thread List

Legend
	Guru: 2001 + pts
	Expert: 751 - 2000 pts
	Enthusiast: 31 - 750 pts
	Novice: 0 - 30 pts
	Moderators
	Helpful answer (5 pts)
	Answered (10 pts)

Toad World

Downloads

Welcome, Guest