Symphony Framework
DBAccess Class Members
Methods 


Symphony.dB Namespace : DBAccess Class

The following tables list the members exposed by DBAccess.

Public Constructors
 NameDescription
Public Constructor Create an insance of the DBAccess class.  
Top
Public Methods
 NameDescription
Public Methodstatic (Shared in Visual Basic) Static method. Force the reset of the connection to ensure any future reads are from the top of the table.  
Public Method Clear the required table in the database.  
Public Method Close the database "channel" and flush any pending operations.  
Public Method Create the required table in the database.  
Public Method Delete the last accessed row from the database.  
Public Method Drop the required table from the database.  
Public MethodOverloaded.  Find a row (record) in the table using a key value and a key of reference. No data is returned.  
Public Methodstatic (Shared in Visual Basic) Check if the channel being used is a database channel and not an ISAM channel.  
Public Methodstatic (Shared in Visual Basic) Close an opened instance of the database table.  
Public Methodstatic (Shared in Visual Basic) Delete the last located record from the database table.  
Public Methodstatic (Shared in Visual Basic) Find a record from the database table. No data is returned.  
Public Methodstatic (Shared in Visual Basic) Method to determine which key to access the table with depending on the type and size of the passed key value.  
Public Methodstatic (Shared in Visual Basic) Open an instance to the database for the selected file.  
Public Methodstatic (Shared in Visual Basic) Read a record from the database table.  
Public Methodstatic (Shared in Visual Basic) Read the next record from the database table.  
Public Methodstatic (Shared in Visual Basic) Store a record into the database table.  
Public Methodstatic (Shared in Visual Basic) Update the last located record in the database table.  
Public Method From the passed data area, for the passed key reference, return the calculated key value and key length.  
Public Method Open the database table for read-only mode.  
Public Method Open the database table for read/write mode.  
Public MethodOverloaded.  Read a row (record) from the table using a key value and a key of reference.  
Public Method Read the first available row (record) from the table. The key of reference defines the sequence/key to use.  
Public Method Read the last row (record) from the table. The key of reference defines the sequence/key to use.  
Public Method Read the next available row (record) from the table.  
Public Method Read the previous row (record) from the table.  
Public MethodOverloaded.  The select method allows you to query the file and return all records in the file.  
Public Method Store the passed data to the database table.  
Public Method Remove any pending locks and abort any pending transaction.  
Public Method Update the last read row in the database with the new value passed in the dataArea argument.  
Top
See Also

Reference

DBAccess Class
Symphony.dB Namespace