Happy New Year to All..
Another year has come, and I'm still trying to migrate from Dadabik ( 1 table ) to Dataface using about 18 tables ). While 1 table is the main table ( systems ) and 12 tables are generally used for Selection/Choices ( ie: hardware/vendor/city/state etc... etcc )... I have 5 tables that I want to use to store TEXT. These tables would store Systems dump of various data ( ie: Routing tables, OS / Disk Info etc ).
I'd like to use the system name as an index into these tables, and this is where my knowledge is behind.
I am now reading about triggers and I think I need to used them. Please check my logic here and tell me If I am on the right track - or If I should be doing something different.
The 5 tables will be receiving their data automatically from scheduled jobs. So Here's my logic.
1) Within the Systems Table ( directory )..
A) Create a trigger ( after insert) that checks to see if an "entry exists" for the given system name in the corresponding 5 tables. If not, create an entry ( so that upon the scheduled job, the script can update where system name matches )
B) Create a trigger ( upon delete ) that deletes the corresponding entry ( if it exists ) in the 5 tables.
I think thats it ? - - and if so, then I'll go figure out how to do it. But I thought I would check to see if this is what i "want" to do, BEFORE, actually coding
in advance,
i thank everyone
dan
