On 11/14/05, Gregory Woodhouse <[EMAIL PROTECTED]> wrote: > > On Nov 14, 2005, at 8:00 PM, Kevin Toppenberg wrote: > -snip- > > If you know which IENs correspond to bad pointers, then you just > delete the corresponding field values. My preferred method is to use > the DBS API, but it can be done in Classic Fileman, too. There's no > need to bother with ^LOOP unless you want to avoid writing code. >
I think you are still looking at a huge amount of work. There are approximately 45 files that can potentially hold records to pointers to file#50. And each of these files can hold multiple records. So I would have to take each of the 45 files and perform a search for in that particular file for records containing the erroneous pointer value. Then use those found records to stuff a corrected value into. That would laborous. And all that would have to be done just for one erroneous record in #50. I would have to repreat this process for each record. 200 records in file#50 to fix * 45 files potentially pointing to file #50, * Fn(f) records in each file = labor! Another use would be as follows. Lets say I VERIFY my PHARMACY ORDERABLE ITEM file, and find an invalid pointer to IEN #1234 in file#50. I can just delete this bad pointer in PHARMACY ORDERABLE ITEM, but what about all the other 45 files that could also be pointing to #1234. I need to be able generate a list of every pointer in the database pointing to #1234. As far as I know there is no function to do this programatically. But I am about half way through writing a function that will generate just such a list. My thought is that it will take input like this: PTRIN(FILE,IEN,ARRAY) and have output like this: ARRAY(1)=<file#>^<IEN>^<Field#><full ref>^<IENS> ARRAY(2)=<file#>^<IEN>^<Field#><full ref>^<IENS> ... Kevin ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_idv28&alloc_id845&op=click _______________________________________________ Hardhats-members mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
