Member Avatar for anuradha1

Hi guys!I'm currently making a database project and I want to update an access
database.
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.update(ds,”word”)
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

  • 3 Contributors
  • 2 Replies
  • 92 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Phasma

Your Select query didn't include a Primary Key

Edited by Phasma because: n/a
Member Avatar for Reverend Jim

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.

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.