SAP Crystal Reports 2011, Win Betriebsanweisung Seite 529

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 528
23.5.7 The Database Expert Links tab
The Database Expert Links tab lets you easily link two or more tables. Choose the Database Expert
from the Database menu to display all current tables; then choose the Links tab to display all current
links.
The easiest way to link database tables is to select Auto Link in the Database Expert Links tab. Auto
Link automatically chooses links for your tables based on common fields in tables or indexed fields (if
your database supports indexed fields).
23.5.8 Linking indexed tables
When you are linking direct-access database tables, you link from a primary table to a field in the lookup
table. The link field in the primary table can be indexed, but does not have to be. The link field in the
lookup table does not have to be indexed, either, unless you aren't using a native driver for your
connection.
In addition, the fields used to link two tables must have the same data type. For example, you can link
a string field in one table to a string field in another table, or a numeric field in one table to a numeric
field in another table, but you cannot link a numeric field in one table to a string field in another table.
Some DBMS applications allow you to convert the field value to another data type in the index. For
instance, the field in the table can be numeric, while the index converts the field value to a string.
However, if you choose to use that field to link to another table, you must link to a field of the original
data type. You cannot link a string value to a numeric field that has been converted to a string in the
index.
If you are linking tables from two different ODBC data sources, MS SQL Server and Oracle, for
example, you can only use string fields to link the tables. String fields are stored in databases in the
same manner, regardless of the data source. Other types of values, however, may not be stored
the same way in different data sources, so you cannot link different data sources in Crystal Reports
using anything other than string values.
When linking direct-access database tables using native drivers (non-SQL), the only join type
available is Left Outer join.
23.5.8.1 Changing the index used in linking
2012-03-14529
Understanding Databases
Seitenansicht 528
1 2 ... 524 525 526 527 528 529 530 531 532 533 534 ... 717 718

Kommentare zu diesen Handbüchern

Edwinfet 29 Feb 2024 | 08:13:09

What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a

KarenSkaky 17 Apr 2024 | 10:11:41

Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in

Helenlal 18 Apr 2024 | 08:19:10

Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen

Helenlal 29 Apr 2024 | 05:23:21

In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit

Chrisnug 29 Apr 2024 | 14:39:54

Hello, im noob :)