Solved

Creating a Modification flag

Posted on 2007-03-19
14
348 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
 

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

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…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now