Difference between revisions of "ADO TABLELIST()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Function to return information about a virtual table ==Syntax== ADO_TABLELIST(cConnstr) ==See Also== ALTER VIRTUALTABLE, CREATE VIRTUALTABLE, ODBC_TABL...") |
Yvonne.milne (Talk | contribs) |
||
Line 3: | Line 3: | ||
==Syntax== | ==Syntax== | ||
− | ADO_TABLELIST(cConnstr) | + | ADO_TABLELIST(cConnstr | cDBC) |
==See Also== | ==See Also== | ||
Line 9: | Line 9: | ||
==Description== | ==Description== | ||
− | The ADO_TABLELIST() function returns a comma-separated list of table names for the specified connection. | + | 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== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | ? ado_tablelist( | + | ? 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... | ||
</code> | </code> | ||
Revision as of 08:41, 14 September 2023
Contents
Purpose
Function to return information about a virtual table
Syntax
ADO_TABLELIST(cConnstr | cDBC)
See Also
ALTER VIRTUALTABLE, CREATE VIRTUALTABLE, ODBC_TABLELIST(), Virtual Table Properties, Virtual Tables, VTINFO()
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...