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
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
along with dBASE, Access, Excel and other file formats.
The run-time files for ODBC are bundled with many existing database
along with dBASE, Access, Excel and other file formats.
The run-time files for ODBC are bundled with many existing database
Class: \helpref{wxDatabase}{wxdatabase}
Every database object represents an ODBC connection. To do anything useful
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).
can do with wxDatabase is opening/closing connections and getting some info
about it (users, passwords, and so on).
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.
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.
at a time by using multiple wxRecordSets with a wxDatabase or you can make
your queries in sequential order using the same wxRecordSet.
at a time by using multiple wxRecordSets with a wxDatabase or you can make
your queries in sequential order using the same wxRecordSet.
These are the data types supported in ODBC SQL. Note that there are other, extended level conformance
types, not currently supported in wxWindows.
These are the data types supported in ODBC SQL. Note that there are other, extended level conformance
types, not currently supported in wxWindows.
This example sets a field in column `X' to the number 123, for the record
where the column ASSET has the value `BD34'.
This example sets a field in column `X' to the number 123, for the record
where the column ASSET has the value `BD34'.