operations is SQL, so you need to learn a small amount of SQL as well as
the wxWindows ODBC wrapper API. Even though the databases may not be
SQL-based, the ODBC drivers translate SQL into appropriate operations
-for the database or file: even text files have rudimentry ODBC support,
+for the database or file: even text files have rudimentary ODBC support,
along with dBASE, Access, Excel and other file formats.
The run-time files for ODBC are bundled with many existing database
\subsection{wxDatabase overview}\label{wxdatabaseoverview}
-\overview{Database classes overview}{odbcoverview}
-
Class: \helpref{wxDatabase}{wxdatabase}
Every database object represents an ODBC connection. To do anything useful
can do with wxDatabase is opening/closing connections and getting some info
about it (users, passwords, and so on).
-\subsection{wxQueryCol overview}\label{wxquerycoloverview}
+\wxheading{See also}
-\overview{Database classes overview}{odbcoverview}
+\helpref{Database classes overview}{odbcoverview}
+
+\subsection{wxQueryCol overview}\label{wxquerycoloverview}
Class: \helpref{wxQueryCol}{wxquerycol}
the real data is stored. The links to user-defined variables are stored
here, as well.
-\subsection{wxQueryField overview}\label{wxqueryfieldoverview}
+\wxheading{See also}
-\overview{Database classes overview}{odbcoverview}
+\helpref{Database classes overview}{odbcoverview}
+
+\subsection{wxQueryField overview}\label{wxqueryfieldoverview}
Class: \helpref{wxQueryField}{wxqueryfield}
all data returned by an ODBC function will be loaded at once and the number
of wxQueryField instances for each column will depend on the number of records.
-\subsection{wxRecordSet overview}\label{wxrecordsetoverview}
+\wxheading{See also}
-\overview{Database classes overview}{odbcoverview}
+\helpref{Database classes overview}{odbcoverview}
+
+\subsection{wxRecordSet overview}\label{wxrecordsetoverview}
Class: \helpref{wxRecordSet}{wxrecordset}
at a time by using multiple wxRecordSets with a wxDatabase or you can make
your queries in sequential order using the same wxRecordSet.
-\subsection{ODBC SQL data types}\label{sqltypes}
+\wxheading{See also}
+
+\helpref{Database classes overview}{odbcoverview}
-\overview{Database classes overview}{odbcoverview}
+\subsection{ODBC SQL data types}\label{sqltypes}
These are the data types supported in ODBC SQL. Note that there are other, extended level conformance
types, not currently supported in wxWindows.
\twocolitem{SQL\_DOUBLE}{Same as SQL\_FLOAT.}
\end{twocollist}
-\subsection{A selection of SQL commands}\label{sqlcommands}
+\wxheading{See also}
+
+\helpref{Database classes overview}{odbcoverview}
-\overview{Database classes overview}{odbcoverview}
+\subsection{A selection of SQL commands}\label{sqlcommands}
The following is a very brief description of some common SQL commands, with
examples.
+\wxheading{See also}
+
+\helpref{Database classes overview}{odbcoverview}
+
\subsubsection{Create}
Creates a table.
This example sets a field in column `X' to the number 123, for the record
where the column ASSET has the value `BD34'.
-
-