Description
The DBTables object provides scripting access to elements of the Stores | DBTables collection in your project.
The names of the DBTables objects coincide with the names of the child DBTable elements. Each property returns the DBTable object that corresponds to the appropriate child DBTable element. For instance, the following code provides access to the element named DBTable1:
JavaScript, JScript
var DBTableElem = DBTables.DBTable1;
Python
DBTableElem = DBTables.DBTable1VBScript
Set DBTableElem = DBTables.DBTable1
DelphiScript
var
DBTableElem : OleVariant;
begin
DBTableElem := DBTables.DBTable1;
end;
C++Script, C#Script
var DBTableElem = DBTables["DBTable1"];
Using methods and properties of the DBTable object you can access the element’s properties from scripts and perform a comparison of the stored data against the database data. For more information, see Database Checkpoints.
Requirements
The object is available only if the project contains the Stores | DBTables collection.
Members
PropertiesExample
The following example demonstrates how you can use the DBTables object to connect to a database and compare its content with stored data.
Notes:
-
This sample uses Jet OLE DB Provider 4.0 to connect to the database. If you use another version of Microsoft Jet, just replace the version number in the code.
-
Using the Microsoft.Jet.OLEDB.4.0 provider requires that you run your script in the 32-bit version of TestComplete.
TestComplete 32-bit executable is located in the <TestComplete>\Bin folder.
JavaScript, JScript
function UsingDBTables()
{
// Specifies a DB Table element
var DBTab = DBTables.DBTable1;
DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Work\\MyDB.mdb;";
// Specifies the login and password
DBTab.Login = "Tester";
DBTab.Password = "123";
// Specifies comparison parameters
ReportDif = true;
MessType = lmError;
// Compares the DB Table element with data stored in a database
DBTab.Compare(ReportDif, MessType);
}
Python
def UsingDBTables():
# Specifies a DB Table element
DBTab = DBTables.DBTable1;
DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Work\\MyDB.mdb;";
# Specifies the login and password
DBTab.Login = "Tester"
DBTab.Password = "123"
# Specifies comparison parameters
ReportDif = True
MessType = lmError
# Compares the DB Table element with data stored in a database
DBTab.Compare(ReportDif, MessType)VBScript
Sub UsingDBTables
' Specifies a DB Table element
Set DBTab = DBTables.DBTable1
DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
"Data Source=C:\Work\MyDB.mdb;"
' Specifies the login and password
DBTab.Login = "Tester"
DBTab.Password = "123"
' Specifies comparison parameters
ReportDif = True
MessType = lmError
' Compares the DB Table element with data stored in a database
Call DBTab.Compare(ReportDif, MessType)
End Sub
DelphiScript
procedure UsingDBTables();
var DBTab, MessType : variant;
var ReportDif : boolean;
begin
// Specifies a DB Table element
DBTab := DBTables.DBTable1;
DBTab.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=C:\Work\MyDB.mdb;';
// Specifies the login and password
DBTab.Login := 'Tester';
DBTab.Password := '123';
// Specifies comparison parameters
ReportDif := true;
MessType := lmError;
// Compares the DB Table element with data stored in a database
DBTab.Compare(ReportDif, MessType);
end;
C++Script, C#Script
function UsingDBTables()
{
// Specifies a DB Table element
var DBTab = DBTables["DBTable1"];
DBTab["ConnectionString"] = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Work\\MyDB.mdb;";
// Specifies the login and password
DBTab["Login"] = "Tester";
DBTab["Password"] = "123";
// Specifies comparison parameters
ReportDif = true;
MessType = lmError;
// Compares the DB Table element with data stored in a database
DBTab["Compare"](ReportDif, MessType);
}
See Also
About Database Checkpoints
About DBTables Collection
DBTable Object