pcsoft.us.windevCopyright 2026, PC SOFT29 Nov 2020 16:58:28 Z16 Nov 2020 16:48:36 ZHello, probably I have a beginner's question. I want to access a FIC file via ODBC interface, which is located in a subfolder. (e.g. \Archive\Product.fic - Tree structure of Data - HFSQL Client/Server database). How do I specify the select (or a connection string) to access the table in the subfolder? With an OLE access it works as follows: The location specified in the connection string by Initial Catalog can contain data files located in subfolders. These data files are automatically declared by the OLE DB provider for HFSQL, replacing the "\" from the path with the "_" character. For example, for the file "<Initial Catalog>\Archive\Product.fic", it can be consulted using "Archive_Product" as data file name. Many thanks Andre30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database/read.awpODBC access to a table in a subfolder - HFSQL Client/Server databasemoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)andre.stammpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database-68154/read.awp29 Nov 2020 16:58:28 ZHi James, thanks a lot. The parameter REP is only for the direct FILE queries. Maybe the Parameter "PATH" in the OPEN co…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database-68154/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database-68154/read.awpODBC access to a table in a subfolder - HFSQL Client/Server databaseRe: ODBC access to a table in a subfolder - HFSQL Client/Server databasemikepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database-68127/read.awp18 Nov 2020 23:21:18 ZHi Andre Would this Windev help topic assist you? https://help.windev.com/en-US/?3044179 Note especially the example conn…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database-68127/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68116-odbc-access-table-subfolder-hfsql-client-server-database-68127/read.awpODBC access to a table in a subfolder - HFSQL Client/Server databaseRe: ODBC access to a table in a subfolder - HFSQL Client/Server database