Databases Reference
In-Depth Information
SQLExecQuery Chan, SQLString
' Return the starting at cell range specified in Position
variable on the active sheet.
SQLRetrieve Chan, Position, , , True
SQLClose (Chan)
End Sub
In Figure 8.11, a single field (CustomerID) was returned using an SQL query. However, it is
possible to return every field in the records returned by an SQL query by utilizing the '*' operator
(Figure 8.12). Figure 8.13 shows the results written to the Worksheet when the query shown in
Figure 8.12 is executed.
8.10
SUMMARY
Chapters 7 and 8 provide the reader with the tools required to manipulate database information.
Chapter 7 focused on how to extract information from databases, whereas this chapter focused on
writing information to and modifying information in databases. Concepts in database alteration and
management are covered with explicit attention given toward the concepts of utilizing pointers in
database manipulations. Utilizing bound controls to display database information is also covered with
specific instruction given as to utilizing list boxes to display and manipulate database information.
