Tables

Returns a collection of names of IDEA database associated with the current audit test.

Compatibility

Available as of IDEA version 12.0

Syntax

Tables As Collection

Return Value

Enumerable collection of names of IDEA tables associated with the current audit test.

The collection item type is String.

Remarks

Tables’ collection is enumerable, i.e., it can be used within FOR EACH loop. Besides, it implements the following properties/methods:

Example

Sub Main
	Dim ac As Object
	Dim atExecutor As Object
	Dim tables
	Set ac = CreateObject("SmartAnalyzer.AutomationClient")
	Set atExecutor = SA.GetAtExecutor("f4d65220-77f1-5969-8943-59c7bd448460",
	"Sample-Weblog")
	Set tables = atExecutor.Tables
	MsgBox"Number of associated tables: " & tables.Count
	MsgBox"First table's name: '" & tables.Item(0) & "'"
	FOR EACH t IN tables
		MsgBox"Next table's name: '" + t + "'"
	NEXT
End Sub

Copy example