Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cascade SQL

Discussion in 'Information Technology' started by Wilson, Jul 28, 2006.

Tags:
  1. Wilson

    Wilson
    Expand Collapse
    Guest

    Freinds,

    I am using VFP wth Access. I want to create to create 2 tables and a cascade
    delete update using relation odbc. It did not worked.

    I heard that cascade does not work with odbc. Is that true? any alternative?

    thanks in advance

    wilson
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Brings 64-Bit Perks in SQL Server 2000 Service Pack (Ziff Davis) Interfaith Dialogues May 7, 2005

  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    > I heard that cascade does not work with odbc. Is that true? any
    > alternative?


    You can't have ms-access do the cascade delete.

    If you use sql server, or oracle, or even JET via odbc, it is the engine
    that does the cascade delete. So, yes cascade deletes will work when using
    odbc, but you will NOT be specify this cascade in ms-access, but in the
    target database (if it supports such a feature).

    Obviously, the newer versions of VFP do support this.

    So, the cascade deletes are a function of the data engine you connect to,
    not that problem of ms-access. If the target system has the relationship
    setup, and supports cascade deletes, then executing a delete in ms-access
    will trigger those cascade deletes. However, setup, and enabling of this
    feature will NOT occur in ms-access, nor is this ms-access's problem to
    solve....

    I don't know how to setup relationships in visual fox pro, but I would have
    to assume that you need to be using the "newer" formats, and newer versions
    of FoxPro to do this. If you are using the VFP drivers for older legacy
    dbase/foxpro data, then likey you will have to code the cascade deletes
    yourself. I would ask in a foxpro group about this.

    Last time I worked and developmed in foxpro was 1991......things have
    changed since then!!


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  4. Wilson

    Wilson
    Expand Collapse
    Guest

    i am doing cascade delete and update in access 2003. But i can only do it
    from within the access database like gui

    I am using VFP 8.0
    Wilson

    "Albert D.Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message
    news:%23S9dKSUhGHA.4712@TK2MSFTNGP05.phx.gbl...
    >> I heard that cascade does not work with odbc. Is that true? any
    >> alternative?

    >
    > You can't have ms-access do the cascade delete.
    >
    > If you use sql server, or oracle, or even JET via odbc, it is the engine
    > that does the cascade delete. So, yes cascade deletes will work when using
    > odbc, but you will NOT be specify this cascade in ms-access, but in the
    > target database (if it supports such a feature).
    >
    > Obviously, the newer versions of VFP do support this.
    >
    > So, the cascade deletes are a function of the data engine you connect to,
    > not that problem of ms-access. If the target system has the relationship
    > setup, and supports cascade deletes, then executing a delete in ms-access
    > will trigger those cascade deletes. However, setup, and enabling of this
    > feature will NOT occur in ms-access, nor is this ms-access's problem to
    > solve....
    >
    > I don't know how to setup relationships in visual fox pro, but I would
    > have to assume that you need to be using the "newer" formats, and newer
    > versions of FoxPro to do this. If you are using the VFP drivers for older
    > legacy dbase/foxpro data, then likey you will have to code the cascade
    > deletes yourself. I would ask in a foxpro group about this.
    >
    > Last time I worked and developmed in foxpro was 1991......things have
    > changed since then!!
    >
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
    >
     
  5. Wilson

    Wilson
    Expand Collapse
    Guest

    Sorry.. I am talking about creating a cascade relation in MS Access 2003
    database from VFP 8 using ODBC. If I download VFPOLEDB will i be able to do
    that?

    "Albert D.Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message
    news:%23S9dKSUhGHA.4712@TK2MSFTNGP05.phx.gbl...
    >> I heard that cascade does not work with odbc. Is that true? any
    >> alternative?

    >
    > You can't have ms-access do the cascade delete.
    >
    > If you use sql server, or oracle, or even JET via odbc, it is the engine
    > that does the cascade delete. So, yes cascade deletes will work when using
    > odbc, but you will NOT be specify this cascade in ms-access, but in the
    > target database (if it supports such a feature).
    >
    > Obviously, the newer versions of VFP do support this.
    >
    > So, the cascade deletes are a function of the data engine you connect to,
    > not that problem of ms-access. If the target system has the relationship
    > setup, and supports cascade deletes, then executing a delete in ms-access
    > will trigger those cascade deletes. However, setup, and enabling of this
    > feature will NOT occur in ms-access, nor is this ms-access's problem to
    > solve....
    >
    > I don't know how to setup relationships in visual fox pro, but I would
    > have to assume that you need to be using the "newer" formats, and newer
    > versions of FoxPro to do this. If you are using the VFP drivers for older
    > legacy dbase/foxpro data, then likey you will have to code the cascade
    > deletes yourself. I would ask in a foxpro group about this.
    >
    > Last time I worked and developmed in foxpro was 1991......things have
    > changed since then!!
    >
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
    >
     

Share This Page