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

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

April 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

KB100311



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


Comments

1 Comments.
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

Mike,

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

Donald,

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 = P1244A1
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
9131
Since 4/2/2008
Follow PrestwoodBoards on: 


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