Master Detail Question

  • Thread starter João Santa Bárbara
  • Start date
J

João Santa Bárbara

Hi all
i have a create a relation between two tables, and both of then have
Autonumbers ( Sql ), since i have the Datarelation, i create a new record in
the master table, and a few in the detail table. so far so good all work as
i expected. ( when i create de details rows , all then have the key for the
relation )

but when i do the update using my sqldataadapter like this

Me.DataAdapter.Update(Tabela)
i = Me.DataAdapterTipoDetalhes.Update(TabelaDetalhes)

the second dataadapter doesnt update,
so i have try the TabelaDetalhes.GetChanges and it returns nothing. but
before i update the master table it returns the new rows ??
anyone can assist me ???
thks
JSB

PS in my opinion, the problem is when i update the master table the second
changes the state of all rows that i have inserted.
 
C

Cor

Hi Joao

The state of the changes in a dataset is done by
datasetx.acceptchanges

Maybe you do that to early

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top