1,105,386 Community Members

Help me

Member Avatar
Newbie Poster
2 posts since Feb 2012
Reputation Points: -1 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]

Hi guys!I'm currently making a database project and I want to update an access
I connected the database using this sql command
'select*from word'
And I tryied to update the database using this code
ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da)
da is a data adapter
ds is a data set
My problem is it giving me an error in runtime.
Here is the error message.
"Dynamic Sql generation for the update command is not supported against a select
command that does not return any key column information"

Any ideas? -Regards

Member Avatar
Junior Poster in Training
81 posts since Nov 2008
Reputation Points: 11 [?]
Q&As Helped to Solve: 21 [?]
Skill Endorsements: 3 [?]

Your Select query didn't include a Primary Key

Member Avatar
Reverend Jim
Noli mentula
5,445 posts since Aug 2010
Reputation Points: 746 [?]
Q&As Helped to Solve: 653 [?]
Skill Endorsements: 51 [?]

select * from word

Selects all fields in the table including the primary key (assuming one is defined). It's a little hard to tell if the OP included the spaces between the query tokens, though.

This article has been dead for over three months: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: