Guidance : Master Record Delete
Publicado: Sab Feb 13, 2010 7:07 am
I have one question. I am using DBFCDX rdd.
I have one master table, whose Primary Key is reflected in many Detail
Tables. When I have to delete a master table record, I have to check all its
Detail table for existance of this Master code. Is their any shorter or
better way of checking this dependancy ?
Another related question : Ideally Primary key of Master table should be
Numeric or Character. Normally I keep incremental numeric value as Primary
Key.
TIA
Milan
I have one master table, whose Primary Key is reflected in many Detail
Tables. When I have to delete a master table record, I have to check all its
Detail table for existance of this Master code. Is their any shorter or
better way of checking this dependancy ?
Another related question : Ideally Primary key of Master table should be
Numeric or Character. Normally I keep incremental numeric value as Primary
Key.
TIA
Milan