Solved

Creating a Modification flag

Posted on 2007-03-19
14
351 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Filemaker Pro and FM Go Synch 1 233
Exporting data from FileMaker Pro 7.5 6 315
FM - Sorting Titles 5 67
FileMaker Pro: How to change fields 4 97
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…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

22 Experts available now in Live!

Get 1:1 Help Now