The DataControl saves a lot of coding when building a data entry
window. However, if you have ever used it, you've found that it
doesn't support joins. For those of you unfamiliar with the term
"join", a join is a SQL query that includes columns from more than
one table. For example, in an invoicing database, you might have
customers and invoices tables. If you perform a query that found all
the invoices due today and you wanted to include the customer's
company name (from the customer table), your query would be
performing a join.
In REALbasic 5.5 and earlier, joins were not supported by the
DataControl. This was due to the fact that the DatabaseField property
was a popup menu so there was no way for you to enter column names
from other tables. Now in REALbasic 2005 you enter column names by
typing (in addition to the popup menu) so joins are now supported.
I try not to send our tips that are version-specific, but this is an
exceptionally useful tip for those building database applications
with REALbasic.
--
Geoff Perlman
President and CEO
REAL Software, Inc.
Vote for REALbasic in the LinuxWorld Reader's Choice Awards:
http://linux.sys-con.com/general/readerschoice.htm
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|