Jump to content

Post Hoc Record Creation / Modification Date?


 Share

This topic is 5764 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Been there and done that.

Nope. Although you might be able to establish a creation date by looking at other dates in the file, or by looking at records in the order they were created "Unsorted" (i.e. dates in a record before or after), you are pretty much SOL, (sh*t out of luck).

Lee

Link to comment
Share on other sites

I'll have to add this to my list of "must have" fields in every table -- things that you will someday need and will curse for not having.

At a minimum:

Serial Number

Creation Timestamp

Modification Timestamp

I also would ad

ForeignImportKey (if this data was imported from another table, import the unique key from that table. Someday you'll want to grab another field from that table, and this makes it easy as pie)

Any others?

Link to comment
Share on other sites

Been there and done that.

Nope. Although you might be able to establish a creation date by looking at other dates in the file, or by looking at records in the order they were created "Unsorted" (i.e. dates in a record before or after), you are pretty much SOL, (sh*t out of luck).

Lee

It's my belief that "Unsorted" is always in creation order, i.e. first record first.

Is that ever not true, i.e. what if you delete a bunch of records in the middle, then create new ones?

Link to comment
Share on other sites

With regard to the unsorted order: I believe they're always in creation order no matter what. Filemaker uses a hidden RecordID number to absolutely identify a record, and these numbers aren't reused unless you clone a file and import, at which point bets are off.

David

Link to comment
Share on other sites

This topic is 5764 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    eyepro 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.