Matter of fact, except for hinting to a tool that will "build" the SQL for you, the foreign keys don't off you any additional functionality (assuming that the DB has the appropriate indexes. The joins will work just as fast (perhaps faster, if you intelligently create covering indexes)
But, what do I know....
Bruce
BLOMASKY wroteBen, you said:
Aware will/should not be able to change the structure of the DB, since the DB is maintained by DB Admin. Any changes made to DB, Aware should recognize it and make adjustments to it's internal BO structure.Aware adds 3 columns to every table to store the relationships. Why would anyone else care if you add extra columns? It will not 'break' any other application. I am not sure how any other application could do what aware does just by interpreting foreign keys. All that can do is enforce referential integrity and doesn't help when you, in aware, type ... WHERE (X IN Y.Z)
Bruce
My comment came from a prospect IT manager who was also the DB Admin and he stated he doesn't want any other app to make any modifications to the structure of their DB.
Tom,
Can you please provide any more detail about what you have done? It sounds very useful.
Per Support's response on Aware's Created DB Tables have no Foreign keys - why?> - this seems to be a focus for the next release.
You can find a Tips and Tricks post here:
Cause, Donald Trump is gonna deport all of them their Foreigners and their Keys also!
So THERE!!!
Bruce
(sorry... really sorry... sort of...)
Thanks, Tom for that creative example.
