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

Databases and tables

are the tables the same? by danceman
Posted: 3 Jul 02 (Edited 12 Aug 02)

This is simple compare tables.  My purpose was not to compare each with function calls of FCOUNT(), FSIZE(), but a quick way to ensure that the tables are the same.  This was developed to provide a check for an import routine.  the process creates to arrays with AFIELDS().
After creating the 2 arrays of each table I compare the arrays.
lstrcmpi compares two strings and is case sensitive.  The first compare is the field count return of the AFIELDS().  

Declare integer lstrcmpi in kernel32 String, String

if afields(emp,"exam") != afields(oldemp,"oldemp")
    wait window "tables are not the same"
    return
else
    if lstrcmpi(oldemp,emp) != 0
        wait window "fields are not the same"
        return
    endif
endif

Back to Microsoft: Visual FoxPro FAQ Index
Back to Microsoft: Visual FoxPro Forum

My Archive

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