I.T. Discussion Community!
-Collapse +Expand
Search Paradox Group:

-Collapse +Expand Paradox To/From
-Collapse +Expand Paradox Store

Prestwood eMagazine

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

   ► KBDesktop Data...Paradox & Ob...Interactive ...   Print This     
  From the March 2011 Issue of Prestwood eMag
Interactive Paradox: Queries (QBE):
QBE Specifications
Posted 13 years ago on 2/18/2006 and updated 6/12/2008
Take Away: Specifications of query by example


Queries Up to 32 tables in a single query. Unlimited number of lines in a query. This is limited by memory.


Share a thought or comment...
First Comment
Comment 1 of 4

Is there any difference in efficiency, or even elegance, between joining a table to a QBE to use one of its fields in a report based on the query, or leaving the table out of the QBE and instead adding it to the Data Model of the report builder?

Posted 8 years ago

Comment 2 of 4

I think the biggest difference to consider is that QBE files always create an answer table and then you use the data in the answer table. In general, the data model uses the live data. For me, the data model approach is more elegant because it doesn't create answer tables and uses the data directly. It most cases it will be faster.

Posted 8 years ago

Comment 3 of 4


Thank you for your reply.  I just realized that I posted this to the KB instead of the MB.  Feel free to delete or move it.  I'm sorry for improper posting.

Posted 8 years ago

Latest Comment
Comment 4 of 4


No, not improper at all. It's definately ok to comment and and ask questions in the knowledge base. The only real difference is how the post gets started. In general, someone starts a MB thread with a question or someone publishes some information in the knowledge base.

Posted 8 years ago
Write a Comment...
Sign in...

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

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1182A1
Enter key:
KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #100311 Counter
Since 4/2/2008
   Contact Us!
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,412 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...

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