Good Morning
Can anyone tell me the sql statement that will list all the dbf files in the
data directory pointed at by my foxpro odbc DSN.
Some thing like
Select tablename from systables
thanks
David Hills
Foxpro odbc sql statement for list of tables
Hot Topic
Visual FoxPro
- Source is out of date
- Bulky package
- FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02
- minimize and maximize buttons on Report Designer
- Treeview stops answering
- cannot open up a form-- BIG TROUBLE
- object is not defined but uncatchable
- include file conflict
- Resize objects when change screen resolution?
- editbox programmatic change
Foxpro odbc sql statement for list of tables
dr Davide Bombarda
Like systables Its counterpart is SQLTables(). ie:
lnHandle=Sqlstringconnect('Driver={Microsoft Visual FoxPro Driver};'+;
'SourceDB=c:\MyDataFolder;SourceType=DBF;')
SQLTables(m.lnHandle)
SQLDisconnect(m.lnHandle)
select sqlResult
browse