On Dec 8, 2006, at 9:47 PM, Jeffrey Horn wrote: > I have a database table in which several columns are all functions > of a > single sixteen digit number. Some of them are subsets of digits, > others are > encryptions of the number, etc. > > Is there a way in RDBO to override things so that I can get all the > individual values of the columns, but can prevent setting these > columns > directly? I would like to try to enforce just setting the sixteen > digit > number and having the other columns auto-populated from it.
depending on your database support, I think the best solution would be to use a DB trigger on insert , that would just populate all of the fields // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | RoadSound.com - Tools For Bands, Stuff For Fans | Collaborative Online Management And Syndication Tools | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
