Database actions usage
How to use Database actions in Autoczar?
Re: Database actions usage
Precondition: Database configuration should be done.
Database actions supported by Autoczar are:
a) DBClose: Closes the connection that is opened with DBOpen action.
b) DBExecuteQuery: Executes the specified query
c) DBOpen: Opens connection to a database based on connection string specified
d) DBVerifyData: Compares the contents of the datasheet attached to the tabular data returned by DBExecuteQuery
e) DBExportToCSV: Exports the queried contents that are returned by DBExecuteQuery to CSV file format
f) DBGetCellData: Retrieves the cell data from a tabular data returned by DBExecuteQuery for a given row and column index.
g) DBGetColumnName: Retrieves column name from the tabular data returned by DBExecuteQuery for a given column index
h) DBGetRowData: Retrieves row data from a tabular data returned by DBExecuteQuery for a given row index.
i) DBGetColumnCount: Retrieves total number of columns present in a tabular data returned by DBExecuteQuery.
j) DBGetRecordCount: Retrieves number of rows presented as records from a tabular data returned by DBExecuteQuery.