
Click above to get retro games delivered to your door ever month!
X-Hacker.org- The Guide to Clip-4-Win version 3.0 - Norton Guide
[^^Up^^]
[Menu] [About The Guide]
WODBC ODBC class
----------------------------------------------------------------------------
WODBC
ODBC class
----------------------------------------------------------------------------
Properties
BOF A logical indicating an attempt to skip before the first record
Cargo User-defined value
ClassName The name of the class
EOF A logical indicating an attempt to skip after the last record
FCount The number of fields per record
LastRec The number of records in the table
oParent Contains the object's parent window object
RecCount The number of records in the table
RecNo The current record number
Methods
WODBC:Axit() Destroy an ODBC object
WODBC:Commit() Commit (confirm) a transaction
WODBC:Connect() Connect to a data source (server)
WODBC:DataSources() Return an array of information about data sources (servers)
WODBC:Diag() Diagnose a non-serious or serious result
WODBC:Execute() Execute an ODBC (SQL) statement
WODBC:FieldGet() The value of a specified field
WODBC:FieldName() The name of a field
WODBC:FieldPos() The position of a named field
WODBC:FieldPut() Change the value of a field
WODBC:GoBottom() Position at the end of the data
WODBC:GoTo() Move to a specified position (row) in the data
WODBC:GoTop() Position at the start of the data
WODBC:Info() Display SQL error/status information
WODBC:Init() Construct an ODBC object
WODBC:Quit() Quit after an error
WODBC:RLock() Lock a record (row)
WODBC:Select() Execute a SELECT statement
WODBC:SeriousError() Handle a serious error
WODBC:Skip() Skip within the data (result set)
WODBC:Unlock() Unlock a record (row)
Inherits From
Nothing.
Inherited By
Nothing.
Description
This is the class for ODBC (Open Database Connectivity). It
allows you to execute a SELECT statement and then treat the
result set like you would a database table: the rows are the
records, and the columns are the fields. However, you need to
bear in mind the characteristics of the server (data source)
you're using (refer to its documentation). Some examples: a
large result set may be slow; updating may only be possible
for a single record at a time, some concurrency settings may
not do what you choose.
Example
// From SOURCE\OO\ODBCWBRO.PRG:
oTable := WODBC{self, "select * from course", "SAMPLE"}, ;
oTable:GoTop(), ;
::CreateChild(Browser{::Client, oTable}), ;
See Also (press Enter)
Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson