copy records in a master/detail clientdataset delphi dbexpress

views:

104

answers:

copy records in a master/detail clientdataset delphi dbexpress

Hello everyone How can I copy the information of a record from a master/detail clientdataset to a new record or to an existing one.

For example I want to copy te data of invoice No. 100 to Invoice No. 150 or the information of invoice No. 100 to a new Invoice

With IBX I did that with storedprocedures but I am running into trouble with clientdataset with 'lock conflict on no wait transaction' when I apply the updates, i think its becasue the information is already on the server side.

Thanks in advance

'Lock conflic on no wait transaction'?

AFAIR, it's an Interbase/Firebird error. It could mean that other connection modified the record and still doesn't committed yet....

UPDATE: Other things that came to mind:

Have you revised your DBX connection configuration? If you don't know/ignore what CommitRetaining is/do, make sure it's configured to FALSE. Otherwise, other problems will arise...
On Firebird/Interbase, you can only commit/rollback from Client application. SPs have no business with transaction control.

Fabricio Araujo 2010-08-20 16:16:12

Thanks a lot.Question, can I commit a storedprocedure?

Alejandro Jourdan 2010-08-20 17:40:49

I think that was it!! Thank you very very muchI put Commitretain = false on params of the sqlconection and everything seems to work ok now, there is a lot to learn. Anything else I should put on that connection params to smooth things out?

Alejandro Jourdan 2010-08-20 18:05:50

From mind, no. But you can ease us in helping if you providing: RDBMS Name/Version/Edition (Examples: Firebird 2.1.1, Microsoft SQL Server 2005 Express Edition, etc), IDE (delphi - you provided), IDE version (2010), and the library you're using (dbexpress - you provided).If I doesn't knew the error message from mind and supposed you are Interbase/Firebird as backend this question would take much more time to get an answer.

Fabricio Araujo 2010-08-20 18:20:38

And you are using what as backend: Firebird or Interbase?

Fabricio Araujo 2010-08-20 18:21:27

It is Firebird 2.1 with dbexpress firebird driver from Chau Chee-Yang (http://sites.google.com/site/dbxfirebird/), delphi 2010 Thanks a lot

Alejandro Jourdan 2010-08-20 18:26:36

You're using D2010, Professional Edition, right? ( I imagine, since if it was Enterprise you would use the official Fb driver)...

Fabricio Araujo 2010-08-20 18:28:29

Thats right it is Professional Edition

Alejandro Jourdan 2010-08-20 19:12:59

ansaurus

tags:

views:

answers:

copy records in a master/detail clientdataset delphi dbexpress

related questions