Click above to get retro games delivered to your door ever month!

 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)