Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Creating a Modification flag

Posted on 2007-03-19
14
355 Views
Last Modified: 2010-04-27
I have a timestamp that tracks modifications to my records, but I want to create a flag that switches to 1 from o whenever there is a modification.

Is there a way to do this?
0
Comment
Question by:jarrodprice
  • 4
  • 4
  • 2
  • +2
14 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 18757381
do you also track the creation timestamp?
if yes, set the flag to 0 when creation timestamp is <> modification timestamp
0
 

Author Comment

by:jarrodprice
ID: 18783831
that only works for first modification.  But thats okay, I figured it out :)
0
 
LVL 28

Expert Comment

by:lesouef
ID: 18783908
if it is set to 0 at 1st mod, how could it be set to 0 again anyway?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:jarrodprice
ID: 18783943
what I did was create a related modification table and use a script that copies the modification date to a related record in that table, whenever a new record in the first table is created.

The mod flag is set to 1 when the the dates in the related records are not the same, which only happens if the record in the first record is changed (thus changing its modification date).  When the script is run again, the 2 dates match again, so the flag goes back to 0
0
 
LVL 28

Expert Comment

by:lesouef
ID: 18784020
so you wanted a latch, something which toggles, not just flip once...
you could have done this using an extra field in the same table too I think
0
 

Author Comment

by:jarrodprice
ID: 18784024
you cant, cuz as soon as you change the flag it modifies the record, thus always switching it back to modified.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 18784040
true...
0
 
LVL 9

Expert Comment

by:jvaldes
ID: 18804297
Take the data you want to control and make it intoa concatenated string. Run a HASH such as MD5 against it. Save the HASH in another field and then compare the current HASH to the oldif the HASHes are different the strings are almost cetainly different. one in 2 to the 67th power odds.

If you would like to learn how to do that let me know
0
 
LVL 9

Expert Comment

by:jvaldes
ID: 19215553
how about a split
0
 

Author Comment

by:jarrodprice
ID: 19341257
I am sorry, I had figured out a solution to this problem on my own.
0
 
LVL 20

Expert Comment

by:Venabili
ID: 20093487
Olease post your solution so we can close this question

Thanks
Venabili
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23887247
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question