`
`484 Programmer’s Guide
`
`Defining a Database
`
`Visual Basic uses a specific set of data access objects to define or describe the
`database, tables, fields and records you work with. Figure 20.3 illustrates the
`database design of Visual Basic databases. All databases, regardless of their
`internal structure, will be expressed in terms of this design.
`
`Database
`
`
`
`Fields Collection
`
`Indexes Collection
`
`.;
`
` TableDefs Collection
`
`.
`
`l
`
`III-I-II-I lIII-III..-
`
`Figure 20.3 Visual Basic Database Structure
`
`The Database Object
`The data control’s Database property can be represented by a Database object
`that describes the current database. It maintains information about the name of the
`
`database and its structure. For example, the database structure describes the tables
`in the database and the fields in each table. The Database object also supports
`several Visual Basic methods that you can use to manage the database.
`
`Microsoft Corp. Exhibit 1104 Page 497
`
`Enfish, LLC; |PR2014-00574
`Exhibit 2206
`
`Page 1 of 2
`
`
`
`Enfish, LLC; IPR2014-00574
`Exhibit 2206
`Page 1 of 2
`
`
`
`
`
`Chapter 20 Accessing Databases with the Data Control
`
`485
`
`Collections
`
`A collection is a set of related objects. The objects in a collection are referred to
`as members of the collection. In Visual Basic, each member of a collection has a
`unique name so it’s easy to identify. You can use the Count property to determine
`the number of members in a collection. Collections are managed like the items in
`a list box. Each member of the collection can also be referenced by its number,
`which starts with 0.
`
`For example, to print the names of tables in your database you can examine the
`TableDefs collection:
`
`Dim I As Integer
`For
`I = B To Datal.Database.TableDefs.Count
`Print Datal.Database.TableDefs(I).Name
`I
`
`Next
`
`-
`
`1
`
`Note In the Visual Basic Standard Edition, the data control can be used to open
`only existing database objects. The OpenDatabaSe function and the ability to
`Dim other database objects (like TableDefs, Fields, Indexes, Dynaset, and
`Snapshot) is not supported. Because of this, you cannot create new databases or
`modify existing database structures using Visual Basic procedures and data
`objects in the Standard Edition.
`
`However, you will be able to create databases, tables, and indexes using the
`Visual Basic Data Manager application (supplied with Visual Basic) or other
`database administration applications designed to work with your specific
`database. In the Visual Basic Professional Edition, you will be able to create and
`modify database structures.
`
`TableDef Objects and TableDefs Collection
`Because a database can have several tables, and tables can have several fields,
`Visual Basic groups the definitions for these objects in collections.
`
`A Database object can have one or many tables. The description of each table is
`maintained in a TableDef object (shown in Figure 20.4).
`
`
`
`Microsoft Corp. Exhibit 1104 Page 498
`
`Enfish, LLC; |PR2014-00574
`Exhibit 2206
`
`Page 2 of 2
`
`Enfish, LLC; IPR2014-00574
`Exhibit 2206
`Page 2 of 2
`
`
Accessing this document will incur an additional charge of $.
After purchase, you can access this document again without charge.
Accept $ Charge
Still Working On It
This document is taking longer than usual to download. This can happen if we need to contact the court directly to obtain the document and their servers are running slowly.
Give it another minute or two to complete, and then try the refresh button.
A few More Minutes ... Still Working
It can take up to 5 minutes for us to download a document if the court servers are running slowly.
Thank you for your continued patience.
This document could not be displayed.
We could not find this document within its docket. Please go back to the docket page and check the link. If that does not work, go back to the docket and refresh it to pull the newest information.
Your account does not support viewing this document.
You need a Paid Account to view this document. Click here to change your account type.
Your account does not support viewing this document.
Set your membership
status to view this document.
With a Docket Alarm membership, you'll
get a whole lot more, including:
- Up-to-date information for this case.
- Email alerts whenever there is an update.
- Full text search for other cases.
- Get email alerts whenever a new case matches your search.
One Moment Please
The filing “” is large (MB) and is being downloaded.
Please refresh this page in a few minutes to see if the filing has been downloaded. The filing will also be emailed to you when the download completes.
Your document is on its way!
If you do not receive the document in five minutes, contact support at support@docketalarm.com.
Sealed Document
We are unable to display this document, it may be under a court ordered seal.
If you have proper credentials to access the file, you may proceed directly to the court's system using your government issued username and password.
Access Government Site
