Error when using multiple Paradox database

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

• Status: Open
• Question Views: 1068
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Zorian Crust 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.

 

-Zorian

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 10/29/2011
• Question Category: Misc Databases