PostCast
 

 

  Search
   

  Help

Play demo

Screen shots

Compare editions

FAQ

Online help

Testimonials

License agreement

Known issues

  Support

Technical support

Forums

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

E-mail merge

Database tools

Message tags

Scheduler

Processing web forms

E-mail client

  Subscribe

Stay informed about any major changes. Click here to subscribe

Compare tables

One of the most advanced Database tools PostCast can offer. It will enable a simultaneous two table operation respectively, as well as their records' comparison. You can delete the records easily, or create a new table featuring results.

Table

Use this combo box to choose Table1 and Table2 names respectively, whose records you will then compare. Remember, you cannot compare the table with itself. If you wish to discard copies or employ other operations on a table, use other tools.

Field

Select a space for each table, according to which you would be comparing tables. For example, when you want to search all the e-mail addresses common to both tables, choose the column name wherein your e-mail addresses are kept.

Remove results

If you keep this option active, the program will erase all the table records that do not coincide with the selected criteria. For instance, if you keep it active for Table1, and deactivated for Table2, the program will erase the results from the first table. Table2 will remain untouched.

Create backup copies of the tables before using this tool

If this option is active, the program will create backup copies of the table using names that will be created from the table name + '_Backup', rather than perform any other operation.

Create new table with the results

You would enter the name of the new table and the program would create a new table wielding comparison results of the two different tables.

Actions:

Find only the values that exist in both tables

Select this option if you want the program to search for data which can be found in both tables.

For example, if you are comparing tables with records as follows:

Table1Table2

11

23

45

66

The result will be: 1, 6

Find only the values that DON'T exist in both tables

The program will be searching only for data which do not coincide with a single datum

in the other table.

Example:

Table1Table2

11

23

45

66

The result will be: 2, 4, 3, 5

Find the values that exist only in 'Table1' and not in 'Table2'

The program will search only for the data which form a part of Table1, and cannot be found in the other table.

Example:

Table1Table2

11

23

45

66

The result will be: 2, 4

Find the values that exist only in 'Table2' and not in 'Table1'

The program will search only for the data which form a part of Table2, and not in the other one.

Example:

Table1Table2

11

23

45

66

The result will be: 3, 5

Clean up table

Remove duplicate recipients

Remove duplicate records

Filter through text file

Remove domains

Repair database

Compact database

See Also:

Working with tables

Database Wizards

E-mail merge

[Home] [Download] [FAQ] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.

 

News
6/8/2007
Version 1.9.964 released
5/25/2007
Windows Vista Support
5/25/2007
Version 1.9.963 released
9/18/2003
Version 1.9.946 released
3/22/2003
Version 1.9.931 released

Forums
10/28/2009
Network Setup and Whitelisting
5/30/2009
I can't send any E-Mails
5/18/2009
Trying to re-install PC Server Prof.
7/14/2008
Vista installation error......another one
4/24/2008
Application Error
3/5/2008
Run rules on Inbox
2/28/2008
Email folders are gone/missing
2/26/2008
Email Rules