Error when using multiple Paradox database

Asked By 0 points N/A Posted on -


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.


                Example element cannot be used more than twice with a ! query.

                Image: 2

                Table: CHURCH.DB

                Field: CHIDNUM

                Token: EG01

Answered By 80 points N/A #97099

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.



Login/Register to Answer

Related Questions