Sergey,
Right, I think I am getting there and thanks again. So, here is what I am thinking:
I have a system DSN, "MY TEST DSN". It is setup as follows:
Data Source Name: My Test Dsn
Driver: Microsoft Foxpro VFP Driver (*.dbf)
Database Type: Free Table Directory
Path: C:\My Test Data
So, my DSN can only return .DBF stuff... got that, but this is not working:
lcDsn = ALLTRIM("MY TEST DSN")
lnConn = SQLConnect( lcDsn )
lcConnStr = SQLGetProp( lnConn, "ConnectString")
lnTableCount = SQLTABLES(lnConn, 'DBF', "_tablelist")
lnData = SQLEXEC(lnConn, "SELECT * FROM TEST1", "_TESTDBF1")
Am I really clueless here :) ???
Thanks,
Ric
>Ric,
>
>You can access only file types supported by particular ODBC driver. With desktop ODBC drivers you've access to the directory that ODBC point to, so you can use VFP commands to access any other file types in the same directory.
>
>