Difference between revisions of "ADO TABLELIST()"
From Lianjapedia
Barrymavin (Talk | contribs) (→Purpose) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ALTER VIRTUALTABLE]], [[CREATE VIRTUALTABLE]], [[ODBC_TABLELIST()]], [[Virtual Table Properties]], [[Virtual Tables]], [[VTINFO()]] | + | [[ADO_PROVIDERLIST()]], [[ALTER VIRTUALTABLE]], [[CREATE VIRTUALTABLE]], [[ODBC_TABLELIST()]], [[Virtual Table Properties]], [[Virtual Tables]], [[VTINFO()]], [[Working with OleDB]] |
==Description== | ==Description== |
Latest revision as of 10:23, 21 September 2023
Contents
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...