INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Compare modification date of an .ntx and a .dbf file

Compare modification date of an .ntx and a .dbf file

(OP)
Hello,

I would like to compare the last modification date of an .ntx and a .dbf file. For the .dbf file, I can use LUPDATE() but is there  a possibility to get the last modification date of an .ntx file ?

thanks

RE: Compare modification date of an .ntx and a .dbf file

mathmax,

Assuming that you are talking programmatically speaking, ADIR(), will fill an array with the attributes of the select files.  Check out Norton Guides for the syntax and functionality available with this function.

Jim C.

RE: Compare modification date of an .ntx and a .dbf file

(OP)
Thank you very much. That's all what I need. smile

RE: Compare modification date of an .ntx and a .dbf file

Due to compatibilty issues with ADIR(), it is advised to use DIRECTORY() instead.  Much easier to use.
Sam

RE: Compare modification date of an .ntx and a .dbf file

I use that strategy in all my applications to see if a database has been modified from another process.

Suggestion: If the index needs to be rebuilt use an "Index On" instead of "Reindex". I don't know the technical reason but I have had corrupted indicies many times using reindex and index on has alway corrected the problem.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel.  Covey

RE: Compare modification date of an .ntx and a .dbf file

LyndonOHRC,

The issue on the INDEX ON is if there is a corrupt index, which happens occasionally, the REINDEX just propagates the corruption while INDEX ON starts over with a clean header and creates the whole index from scratch.

Jim C.

RE: Compare modification date of an .ntx and a .dbf file

Jim C., That makes sense. Thanks

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel.  Covey

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close