most out of your Robelle Tools
You know there is an invalid key value in a IMAGE automatic master, but you dont know which of the 16 details contain the bad value. How to find them all?
You could create a custom Suprtool job that looks in each of the linked datasets. But perhaps you have not worked on this database in a year or so. It could take a long time to get the names of the related sets, and the names of the key field in each one, all spelled correctly! Nothing difficult, but time-consuming.
Or, you could use
the List;Related command of Suprtools Dbedit module. This
extremely simple command shows you all the entries in the database
that are linked to one specific entry!
For example, I
know that there is an invalid key value N45 0002 in the
A-ACCOUNT-SITE automatic master, but I dont know what detail
sets have the offending data. Remember, automatic entries are
created, uh, automatically, when you insert data into a related
detail. If you want to have the detail insertion to fail unless the
key value has been previously inserted, you would use a manual master
The List;Related command found three entries in the d-cpus dataset that ontain the bad value, ACCOUNT-SITE = N45 0002. We show our listing to the administration staff and they tell us that the proper ACCOUNT-SITE value is N45 0001. But what is the fastest way to fix it? We could use a serial Get, an Extract and an Update, but that is a lot of syntax to get correctly.
Or, we could use
the Dbedit Change command. With this command, Suprtool changes the
value of a master entry, and then updates all the detail entries that
were pointed to by the original value.
Notes: You can
also do List;Related on a detail entry and Suprtool will show you all
the master entries that point to it.
Copyright The 3000 NewsWire. All rights reserved.