TopSpeed files with unnamed tables and ODBC

[daerid]

Hey all. I'm trying to perform an SQL statement upon a .tps file that unfortunately does not have a named table in it.

I'm currently using ADO 2.7, and have no problems opening the connection object to the file, but I can't seem to perform any SQL statements on it, as the table doesn't have a name.

 

[ShankarJ]

Do you have the ODBC driver for Topspeed files? If not, I am not sure that you can read Topspeed files directly thru ADO.

As for the UNNAMED issue, Topspeed files support multiple record formats in a single physical TPS file. If there is only one record format then by default it is called UNMAMED.
If CUSTOMER.tps is the filename and it has a UNNAMED record structure, I would assume you could access it as CUSTOMER\!UNNAMED.

 

[daerid]

Yes, I have the ODBC driver.

However, the problem has been what to call the table in a select statement.

So, you're saying that I can do (for example):

SELECT COUNT(*) FROM CUSTOMER\!UNNAMED

or something to that effect? Let me try it out...