Member Avatar for ecostas

Hi. I'm starting to use clientdatasets after years with Zeos DBO and I'm facing some difficulties. I created a TSQLConnection, a TSqlDataset as a ctTable, a TDatasetProvider and a TClientdataset. I populated the clientdataset and tried an ApplyUpdates(0) to insert the records. But I'm getting a "cannot modify a read-only dataset' message. Updates with sqlconnection.executedirect work perfectly. Changing the TSqlDataset to a TSqlTable didn't help.

I'm using Delphi 2007 Professional with MySQL 4.1.9.

Any ideas?

TIA.

  • 1 Contributor
  • 2 Replies
  • 179 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by ecostas
Member Avatar for ecostas

An additional note is that I used a connection to an Interbase file with the same result (cannot modify a read-only dataset). The query only considers one table and I have administrator's privileges, both in MySQL and Interbase. Must be something really simple but I haven't found it yet.

Member Avatar for ecostas

Problem solved. Stupid me. I set ResolvetoDataset in the TDatasetProvider to true. 3 weeks of desperation for nothing. Well, knowledge is always welcome and hard earned knowledge is harder to be forgotten.

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.