Asked By
Jul Smith
0 points
N/A
Posted on - 10/28/2011
Hi,
I was using this Paradox database with my program in Windows platform when I got this error message (please see below). Yes, I was querying and building a table from multiple tables and used this inclusion operator (!).Â
It seemed that I wasn’t allowed to do this. Â
So how could I query from multiple tables? Any advice on what to do?Â
Thanks in advance for the help.
Paradox
        Example element cannot be used more than twice with a ! query.
               Image: 2
               Table: CHURCH.DB
               Field: CHIDNUM
               Token: EG01
Error when using multiple Paradox database
Hello Jul,
Â
When you use an example element in more than two or three times in a multi-table and inclusion operator, that paradox error will occur. Paradox can't include records from the table when you link two or other tables. You can just use two or more example element in multi-table join as a solution. Here is an example. Use and example element "Join2" to link the 1st and 2nd tables together. And then you can use 2nd example element "Join3" to link the 1st, 2nd or third tables all together. And depending on what or which table's records you want to include, just place the inclusion operator in "Join2 or Join3" . This simple solution will surely help you fix your problem. I'll be glad if you let me know what happened after trying this.
Â
-Zorian
