pcsoft.us.windevCopyright 2026, PC SOFT8 Apr 2015 17:50:00 Z6 Apr 2015 17:29:00 ZGreetings, Has anyone successfully used the new SQL Views and Materialized Views? I am trying to put together a Webinar showing the new WD 20 HFSQL features 150-164 and most work great, however after creating and testing SQL Views, I am having problems using them in a test window. It seems no matter what I do it says the view is not initialized. For Materialized Views, I can read them but a call to HNbRec gives an error that the view is not compatible with the analysis. If I try to synchronize the project with the analysis, the HFSQL Modification gets an error saying can't write to Materialized Views. So far no response from PC Soft either.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51426/read.awp8 Apr 2015 17:50:00 ZHi Tomas, Thanks. I am glad to know it is not just my lack of knowledge!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51426/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51426/read.awpWD 20 new SQL Views and Materialized Viewsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51371/read.awp6 Apr 2015 22:23:00 ZHi Jeff, Incidentally, PCS has announced an update towards version 200057h FR and one of the ítems to be corrected apparently…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51371/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51371/read.awpWD 20 new SQL Views and Materialized Viewsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51370/read.awp6 Apr 2015 21:29:00 ZHi Guenter, Yes, I think that is the issue because there also is no way to display these in the HFCC v20 either. I report it …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51370/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51370/read.awpWD 20 new SQL Views and Materialized Viewsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51369/read.awp6 Apr 2015 19:07:00 ZHi Jeff, to me, it seems the word 'Pre-Release' has some meaning ... maybe?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51369/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51357-20-new-sql-views-and-materialized-views-51369/read.awpWD 20 new SQL Views and Materialized Views