Solved

Creating a Modification flag

Posted on 2007-03-19
14
356 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
[X]
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
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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