Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Creating a Modification flag

Posted on 2007-03-19
14
Medium Priority
?
361 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

670 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