IT SOLUTIONS
Your TECHNOLOGY partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox Group Home
-Collapse +Expand Message Board
-Collapse +Expand Paradox KB
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Paradox Store
PRESTWOODSTORE
-Collapse +Expand Members Only

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic     Print This   

Missing Data Query

Missing Data Query in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Missing   Missing Data   Missing Data Query  

Cfolkes
I have 2 tables supporting a marathon race.
Table 1 contains 2 columns.
Col 1 is Chip# - a 7 character field
Col 2 is a persons Name

Table 2 contains 1 column, chip#
When a runner completes the race, the chip# is entered into table 2. I need to compare the 2 tables using table 1 as the master and find out if there are any missing chips.

No 2 chip numbers are the same, and both tables are indexed on Chip#. There could be as many as 35,000 chips involved.

For the life of me, I cant figure out how to do a compare of the two tables using opal Query and come up with missing chips.
 Posted 7 years ago (Thread Starter)
Comment Quote
Location=Los Angeles,Ca,La ,  Joined=13 years ago   MB Posts=39  
More... -Collapse +Expand
Cfolkes
Los Angeles,Ca,La
Rank: Cadet 4th Year
Email A E CA USA
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11506, 3 replies
Thread Started 8/18/2006 4:14:00 PM
View Counter=1024

Cfolkes
Steve
 Posted 7 years ago (Thread Starter)
Comment Quote
Location=Los Angeles,Ca,La ,  Joined=13 years ago   MB Posts=39  
More... -Collapse +Expand
Cfolkes
Los Angeles,Ca,La
Rank: Cadet 4th Year
Email A E CA USA
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11508 (Level 1.1)  Reply to 11506
Thread Started 8/18/2006 6:40:00 PM
View Counter=2
Most Recent Post

Cfolkes
Steve
I hid the wrong key...Thanks for the assist. I have been away from Paradox for too long!
Works like a champ! Now I won't have to go thru thousands of timing chips that the runners wear, comparing them to the original printout
Thanks again!
 Posted 7 years ago (Thread Starter)
Comment Quote
Location=Los Angeles,Ca,La ,  Joined=13 years ago   MB Posts=39  
More... -Collapse +Expand
Cfolkes
Los Angeles,Ca,La
Rank: Cadet 4th Year
Email A E CA USA
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11509 (Level 1.2)  Reply to 11506
Reply Posted 8/18/2006 6:42:00 PM

Steve Caple
You want a "not in" query -

   CUSTOMER | CustID      | CustName | CustAddr |
| Check _CID! | Check | Check |
ORDERS | CustID |
| _CID, count = 0 |
This finds all customers who are not in the Orders table. The inclusion operator (!) after the example _CID tells the QBE engine to find all records even where there is no match; the count = 0 in the Orders CustID field says find only those where the count of CustID in Orders is zero.

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 7 years ago
Comment Quote
Location=Sacramento, CA ,  Joined=9 years ago   MB Posts=66   KB Posts=2  
More... -Collapse +Expand
Steve Caple
Prestwood IT Solutions
Sacramento, CA
Rank: Lieutenant-Commander
Email A E CA USA
Approved member.
Member subscribes to this thread with a verified email.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11507 (Level 1.3)  Reply to 11506
Reply Posted 8/18/2006 6:12:00 PM

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post:

Enter your name and security key.

Your Name:
Today's security key = P213A
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #11506 Counter
1024
Since 4/2/2008
-
  Load Time=less than 1 second.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


673 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join now. It's free!
Show More...


©1995-2013 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech