SQL Relations vs. DataRelations?

From: Peter (Peter_at_discussions.microsoft.com)
Date: 08/28/04

  • Next message: John: "Access 97 (dao) to 2003 (Ado)" 
    Date: Sat, 28 Aug 2004 08:49:02 -0700

    Hello,

    Thanks for reviewing my question. I would like to know if I create a
    relationship via the SQL server's diagram is that replicated in the Dataset's
    relations property? It seems not to to be the case because if you look at
    the dataset via VS.NET editor, it only shows the two tables but no
    relationships. If I create a relationship via SQL server and then I have to
    create a relationship the dataset, this would be redundant. Can you shed
    some light on this?

    Many Thanks
    Peter

  • Next message: John: "Access 97 (dao) to 2003 (Ado)"

    Relevant Pages

    • RFC: SQL::KeywordSearch 1.1
      ... I thought some people here would be interested in reviewing this: ... I plan to publish a small module to generate SQL for simple keyword ...
      (perl.dbi.users)
    • Re: Isolatable Concerns
      ... In relational thinking, what is together or apart is considered a ... difficult for humans to navigate unless they reflect a familiar ... Why sprinkle SQL around, especially if its redundant? ...
      (comp.object)
    • SQL 2005 servers with multiple instances
      ... I have an interesting configuration that I was hoping others might comment ... consider the two servers with many small drives for the 'Live' data ... is being shared for the Live data and the Redundant data/logs. ... To my knowledge, SQL provides no prioritization, other ...
      (microsoft.public.sqlserver.setup)
    • SQL::Interpolate - request for comments
      ... as I was writing a lot of SQL construction/variable binding code ... (similar to Recipe 14.13--Building Queries Programmatically, Perl ... The purpose of SQL::Interpolate is to make writing SQL queries in Perl ... more natural, less redundant, and less error-prone. ...
      (perl.dbi.users)
    • Re: Database Tools in VS 2003
      ... To rename a table, create a new diagram, add your table to the diagram, ... TOAD is now available for free for MS SQL. ... > I am using the database tools in VS.NET 2003 EA to develop the tables and ...
      (microsoft.public.vsnet.general)