Tracking Changes to Files 
Author Message
 Tracking Changes to Files
I have a third party application that I need to be able to track
updates to several of the files.  Since I don't have source code, I
was wondering if there is a way in UniVerse (9.4) to monitor updates
to files.  Any help will be greatly appreciated.

Thanks,

Jay
Jay Falck
Programmer/Analyst
JI Specialty Services, Inc

--The opinions expressed are mine and mine alone.  They
may (and probably do) not reflect the opinion of my employer.



Tue, 25 Sep 2001 03:00:00 GMT
 Tracking Changes to Files

The best way I have found to do this (in D3) is to put a callx in the
D-pointer, output-conversion. By using callx the program is run anytime the
file is written, (from UP, basic, from OSFI, anywhere).


Tue, 02 Oct 2001 03:00:00 GMT
 Tracking Changes to Files
Thanks for all the recommendations.  I understand the concept behind
the SQL table issue, but I can't convert the file or the vendor will
not support it.  I also know how to add the index but I'm not sure
about how to go about making it trigger on every update to the file.
Is there an attribute somewhere that gets written everytime a change
is made?  Please pardon my ignorance, but even though I've been in
this job for 3 years, I haven't been able to concentrate on Universe.
It's been more learn the application and write reports.  Thanks again
for all the suggestions.

Jay


Quote:
>The best way I have found to do this (in D3) is to put a callx in the
>D-pointer, output-conversion. By using callx the program is run anytime the
>file is written, (from UP, basic, from OSFI, anywhere).

Jay Falck
Programmer/Analyst
JI Specialty Services, Inc

--The opinions expressed are mine and mine alone.  They
may (and probably do) not reflect the opinion of my employer.


Thu, 04 Oct 2001 03:00:00 GMT
 Tracking Changes to Files

Quote:

>Thanks for all the recommendations.  I understand the concept behind
>the SQL table issue, but I can't convert the file or the vendor will
>not support it.  I also know how to add the index but I'm not sure
>about how to go about making it trigger on every update to the file.

[snip]

Create an I-type field in the dictionary which calls a SUBR:

VI DICT MYFILE MYTRIG

I

Trigger Subroutine
0L
S

Now make a subroutine called MYTRIG which has 2 arguments:

SUBROUTINE MYTRIG(RESULT,INPUTREC)
RESULT = ""
...
RETURN
END

And make it do what you want as regards logging, but have it return nothing.

Then create an index on the new field:

CREATE.INDEX MYFILE MYTRIG NO.NULLS

and build it:

BUILD.INDEX MYFILE MYTRIG

After that, every time a record is updated your subroutine MYTRIG should be
called.  The mechanism is not as good as a trigger, and the issue of what
happens when a record is DELETEd is something you'll have to experiment
with.

Best Regards,

Ken Wallis

Empower Data Solutions Pty Limited, ACN 079 955 196

Envision, enable, enhance... empower



Fri, 05 Oct 2001 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. history file or DB tracking all possible changes

2. history file or DB tracking all possible changes

3. history file or DB tracking all possible changes

4. Change tracking looses changes

5. Tracking data file and log file space

6. Using FileMon to track MEMO File Missing/Invalid and File Access Denied errors

7. Tracking Table Schema Changes

8. Tracking changes during Synchronization on device (Merge Replication)

9. Keeping track of changes

10. Tracking changes?

11. Start change Tracking

12. CHANGE TRACKING


 
Powered by phpBB® Forum Software