Cascade SQL

[Wilson]

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

 

[Albert D.Kallal]

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!!

 

[Wilson]

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

 

[Wilson]

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?