Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Prob w pgm to build Cascading Deletes in DBC
Message
De
13/12/1999 17:27:48
Frank Mundo
WindowDressers, Inc.
Maine, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Prob w pgm to build Cascading Deletes in DBC
Divers
Thread ID:
00303015
Message ID:
00303015
Vues:
64
using following code...
LOCATE FOR ObjectType = 'Table' AND ObjectName = a4Scan(i,2)
IF FOUND()
nObjectID = ObjectID
LOCATE FOR ObjectType = 'Relation' AND ;
'parcel_id'$Property AND ;
'main'$Property AND ;
'parcel_id'$Property AND ;
ParentID = nObjectID
IF FOUND()
REPLACE RiInfo WITH 'ICI '
ELSE
DisplayStatus("Could not set Referential Integrity for file "+ a4Scan(i,2))
ENDIF
ENDIF
(modification of code out of GENDBC) ... when I subsequently Open the DBC it insists on CLEANUP DBC in which I lose the Cascade deletes (I think). What am doing wrong / what's an easy way to set Cascade deletes within a program ?
Répondre
Fil
Voir

Click here to load this message in the networking platform