Re: Master/Detail with ADODatasets (again)

From: Bill C (wcarey_at_NOTsenet.com.au)
Date: 03/11/05

  • Next message: Del M: "Re: Master-Detail insert" 
    Date: 10 Mar 2005 17:49:22 -0800

    Brian,

    So that means the SQL statements use to retrieve data from the
    server need to be more explicit?

    At the moment, I just set the CommandText in Patients to 'Select
     * from patients where surname=:surname', then substitute the
    parameter with user input. The linked detail tables are
    automatically retrieved because I have their CommandText set
    with the linked parameter.

    If the Detail table CommandTexts are not used, when I retrieve
    the patient data, I will have to explicitly retrieve the
    appropriate detail table records using JOINs in the SQL
    statement?

    Another question - is it actually necessary to use BatchUpdate
    mode when my app only allows users to edit a single record at a
    time, then save it back to the server before moving on to the
    next record?

    Thanks for your advice
    Cheers
    Bill

    Brian Bushay TeamB <BBushay@Nmpls.com> wrote:
    >
    >>D7 Pro, ADODatasets, SQL Server 7, XP Pro
    >>
    >>I am still having trouble saving detail tables in my
    >> master/detail application – sorry about the long post, but I
    >>have tried to describe exactly what my setup is.
    >
    >If you use batchUpdatemode then you can't use a parameter in the detail query to
    >sync it with the master table.
    >When you use a parameter the linked details will be required when you change
    >master records.
    >Just use the MasterFields property to link master and details
    >--
    >Brian Bushay (TeamB)
    >Bbushay@NMPLS.com

  • Next message: Del M: "Re: Master-Detail insert"

    Relevant Pages

    • Re: VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation
      ... Then my app goes against a SQL ... Server 2000 database, retrieves other data and updates about 500 ... OleDbDataAdapter that I use to retrieve the original table from the ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Best Way to Test Against a Database
      ... that I have my CommandText, ... If your database client library (and the server) supports the concept of "prepared" statements, this would be a very easy way to verify the correctness of the SQL statements without actually executing the command. ... "Preparing" a statement will send the SQL to the server and the server can use the SQL to build a query plan. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Best Way to Test Against a Database
      ... that I have my CommandText, ... "Preparing" a statement will send the SQL to the server and the ...
      (microsoft.public.dotnet.languages.csharp)
    • CONTAINSTABLE with individual RANK?
      ... sorted by our own score column. ... This was not possible in SQL ... Server 2005, it is only possilby to dig up based on the RANK. ... of course possible to retrieve everything and then used an ORDER BY ...
      (microsoft.public.sqlserver.fulltext)
    • Not finding GUID value after migration sql 2005 to 2000
      ... I've developed a web app using sql 2005. ... a guid value in the ASP.NET ... which works fine on my 2005 server but breaks on the 2000 server. ... // Retrieve information through the stored GUID ...
      (comp.databases.ms-sqlserver)