Identity columns with ClientDataSets?

From: Mark A. Deal (nospam_at_idaknow.com)
Date: 07/01/04

  • Next message: Marc Rohloff [TeamB]: "Re: a question about delphi 7.1 update (it's delphi 7 update bug?)" 
    Date: Thu, 1 Jul 2004 14:24:47 -0400

    How do you handle Identity columns with SQL Server and ClientDataSets?

    It would appear that the identity value is not actually generated until you
    ApplyUpdates. Therefore, I am not sure how the links work (or do not) using
    detail datasets since no link has been generated until the master is updated
    to the physical server.

    As an aside, using standard TADOQuery datasets, I have traditionally simply
    performed a query to return the maximum value from a table's primary key
    field and then assigned that value + 1 to my new record.

    Any thoughts on this? Anybody have any convenient ways of handling this?
    I'm not having much luck because I get the error, "No corresponding Master
    record."

    TIA 

    -- 
Mark A. Deal
Document & Data Solutions, LLC
http://www.docsol.com
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant
  • Next message: Marc Rohloff [TeamB]: "Re: a question about delphi 7.1 update (it's delphi 7 update bug?)"

    Relevant Pages

    • Re: Identity columns with ClientDataSets?
      ... "Mark A. Deal" wrote in message ... > How do you handle Identity columns with SQL Server and ClientDataSets? ... > I'm not having much luck because I get the error, "No corresponding Master ... > GhostFill Certified Consultant ...
      (borland.public.delphi.database.ado)
    • Re: Please answer my queries for fresh Installation
      ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
      (microsoft.public.sqlserver.server)
    • Re: Master Pages not displaying ... ?
      ... If you have the above line in your child page then it won't display ... from the master page because there is nothing to display. ... Microsoft SQL Server Analysis Services Designer ... Microsoft SQL Server Integration Services Designer ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Most efficient way to process this set of records??? (Bill Vaughn)
      ... I thought Bill's books were strictly for SQL Server. ... What I mean by "Composite" record is a group of columns from several ... Use datarelation between a master to the new detail (as opposed to ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Master Pages not displaying ... ?
      ... I've just been working through several examples of how to create Master ... Microsoft SQL Server Analysis Services Designer ... Microsoft SQL Server Integration Services Designer ... Microsoft SQL Server Reporting Services Designers ...
      (microsoft.public.dotnet.framework.aspnet)