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!
  • Students Click Here

*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.

Students Click Here

Microsoft: FoxPro FAQ

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"
    if lstrcmpi(oldemp,emp) != 0
        wait window "fields are not the same"

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

My Archive

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