Auto-modification date in FM

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Jeff Laks - qmail Mon, 11 Jan 1993 20:31

#611

Author: Jeff Laks - qmail
Date: Mon, 11 Jan 1993 20:31

15 lines
1225 bytes

Does having an auto modification date preclude linking Filemaker Pro files?

In our db, we have defined one of the fields as an auto-entry field for 
the modification date.  So, everytime I change the data in a record, the 
date will change to reflect this.  The problem arises when we do a 
'relookup' - we have two dbs linked, and if you do a relookup, it obviously 
does a comparison search on every single record and therefore updates the 
modification date for every single record! 

We are currently running Filemaker Pro 1.0v3, but we also have a copy of 2.0
in-house.
-- 
Jeff Laks                      | jeffl@newbridge.com   | 
Newbridge Networks Corporation | Phone: (613) 591-3600 |
Kanata, Ontario, Canada.       | FAX:   (613) 591-3680 |

Re: Auto-modification date in FM

#613

Author: Mike Gordon
Date: Mon, 11 Jan 1993 21:14

39 lines
2053 bytes

In article <1993Jan11.203119.10597@Newbridge.COM> jeffl@Newbridge.COM (Jeff Laks - qmail) writes:
>In our db, we have defined one of the fields as an auto-entry field for 
>the modification date.  So, everytime I change the data in a record, the 
>date will change to reflect this.  The problem arises when we do a 
>'relookup' - we have two dbs linked, and if you do a relookup, it obviously 
>does a comparison search on every single record and therefore updates the 
>modification date for every single record! 


Jeff,
     
    Add a serial number field to your database and tell your script to find
the current recor before you issue your relookup command.   Then do a Find All 
to get back to all your records.

Here's the script: 
 

Copy                Serial_Number
  Select entire contents     
 
Enter Find Mode
 
Paste               Serial_Number
  Select Entire Contents

Relookup
  Perform Without Dialog

Find All


     Oh, one other thing.  You have to put the serial number field in the 
layout that you'll be doing the search from.  I set mine to a 1 point yellow
typeface (yellow doesn't show on the B/W monitors) and make it non-printing, 
delete it from the tab order, and push it off the right side of the screen.
This makes it more-or-less invisible to the user.

Mike Gordon  N9LOI  mwgordon@nyx.cs.du.edu

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads