Master and detail question

From: Timothy (timothyleung88_at_hotmail.com)
Date: 02/28/05

  • Next message: jason: "Re: Not enough Parameters?" 
    Date: Mon, 28 Feb 2005 12:29:53 +0800

    Hi All,

    I am using Delphi 6 ADO dataset connect to a MS SQL with ltBatchOptimistic.
    I set all the linkage / relation in the datasource, masterfields and
    indexfieldname. However, when I try to insert a record in detail table. Then
    execute Post or Next. The record disappear in the grid. I try to
    UpdateBatch(arAll) for both table, close and run the program again. The
    record is there. Did any one know what is the problem? Why the record
    disppear?

    Timothy

  • Next message: jason: "Re: Not enough Parameters?"

    Relevant Pages

    • Re: Master and detail question
      ... >I set all the linkage / relation in the datasource, masterfields and ... >indexfieldname. ... >execute Post or Next. ...
      (borland.public.delphi.database.ado)
    • Re: Master-Detail using disconnected recordset
      ... I used the "design time" linkage between the ADOQuery's to link Tables ... the linkage connection is broken. ... MasterFields property? ... Since I am using ADOQuery it doesn't appear that properties such as ...
      (borland.public.delphi.database.ado)
    • Re: Master-Detail using disconnected recordset
      ... I have built a DB Structure comparison utility that basically takes two ... I used the "design time" linkage between the ADOQuery's to link Tables ... connected to the databases, ... MasterFields property? ...
      (borland.public.delphi.database.ado)
    • Re: ADO w/ MS Access: Master-Detail
      ... If I set that AND the filter ... > If I set JUST the filter, w/out the DataSource and MasterFields ... > but it loads slow as heck if I don't use Filter). ...
      (borland.public.delphi.database.ado)