pcsoft.us.windevCopyright 2026, PC SOFT17 May 2016 14:11:00 Z17 May 2016 13:51:00 ZHi I have a customer who are wanting some sales/performance data extracted from their HyperFileSQL Server DB, they are using another company to produce visuals and performance league charts to present this data, i thought i could create all the queries [WD21] then an ODBC datasource linking to their Hyperfile DB and they could use an Access DB but it only links tables not queries. I dont want to rewrite all the queries in access if i can help it, does anyone know a way around this, or a better solution? Thanks ISO30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57675/read.awp17 May 2016 14:11:00 ZThanks Fabrice, the webservice might be an option.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57675/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57675/read.awpODBC?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57674/read.awp17 May 2016 14:09:00 ZHi Peter, That sounds interesting, Ive only just updated from v18 recently, and havent yet updated the HFSQL Server. I ll get…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57674/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57674/read.awpODBC?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57673/read.awp17 May 2016 14:09:00 ZHi again or, depending on the situation, you can create a webservice REST (webdev awp page) or SOAP (windev) exposing your da…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57673/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57673/read.awpODBC?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57672/read.awp17 May 2016 14:07:00 ZHi, or you can create a .net project with your query presented as global procedures or classes... THe other company just has…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57672/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57672/read.awpODBC?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57670/read.awp17 May 2016 13:55:00 ZHi ISO, Why don't you define HFSQL server side views or materialized views? Available since V20 if I am correct. For any ex…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57670/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57669-odbc-57670/read.awpODBC?