pcsoft.us.windevCopyright 2026, PC SOFT17 Nov 2014 14:46:00 Z15 Nov 2014 18:39:00 ZHello I'm migrating a HF Classic application towards HF Cllient/Server and have had several problems with SQL code running in Classic but not HFCS. I can't find a solution for following query, which runs perfectly in HF Classic but not in HFCS. The error message "Report file is not in the FROM clause", doesen't make sense to me. Anyboday having any idea? Thanks. Mat30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48996/read.awp17 Nov 2014 14:46:00 Zthanks Joris, I did upgrade and check the server version 19 before posting. Also, I have other UNION queries that work alright i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48996/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48996/read.awp[WD15] HFCS SQL issueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48983/read.awp17 Nov 2014 09:58:00 ZHi, Do you really need to use version 15 of the HFCS database? I once had the same kind of issue with version 15 of the HFCS…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48983/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48983/read.awp[WD15] HFCS SQL issueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48979/read.awp16 Nov 2014 00:12:00 ZNo point wasting more time over yet another inconsistency in the HF query engine. Maybe the reason is that the second set of fil…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48979/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48979/read.awp[WD15] HFCS SQL issueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48978/read.awp15 Nov 2014 18:42:00 Zsorry, forgot to add the query.... SELECT Report.IDReport AS IDReport, Report.ReportType AS ReportType, Report.ShortName A…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48978/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48975-wd15-hfcs-sql-issue-48978/read.awp[WD15] HFCS SQL issue