ADO TABLELIST()

Purpose

Function to return a comma separated list of table names for a given ADO connection string or a VFP database container (.dbc file).

Syntax

ADO_TABLELIST(cConnstr | cDBC)

See Also

ADO_PROVIDERLIST(), ALTER VIRTUALTABLE, CREATE VIRTUALTABLE, ODBC_TABLELIST(), Virtual Table Properties, Virtual Tables, VTINFO(), Working with OleDB

Description

The ADO_TABLELIST() function returns a comma-separated list of table names for the specified OLEDB connection string or Visual Foxpro database filename (.dbc).

Example

? ado_tablelist('D:\Recipes\Data\recipes.dbc')
auto_ids,foodcat,ingredie,recingrd,recipes...
 
? ado_tablelist('oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=D:\Recipes\Data\recipes.dbc;Exclusive=No')
auto_ids,foodcat,ingredie,recingrd,recipes...