pcsoft.us.windevCopyright 2026, PC SOFT10 Jun 2017 15:18:00 Z9 Jun 2017 15:04:00 ZHello, I need to write a case when ...... when .... Else End as part of the query. It's working fine in HFSQL Control centre, when I try to create the query in WD21 [through query editor] there seems to be no option to write a case syntax. I tried editing the query, it gives error message when I try to reverse engineer it. I need to populate a table with 40 fields, creating a query string , executing it , assigning the result set to the table, through programming is a time consuming job. Is there any other easy way to get the work done ? Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61240/read.awp10 Jun 2017 15:18:00 ZThanks DerekT, I could put Case sql statement now. Happiness Always BKR Sivaprakashhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61240/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61240/read.awp[WD21][HFSQL21] Case in HFSQL Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61235/read.awp9 Jun 2017 17:27:00 ZHi You can add a CASE statement in the query editor if you prefer. Bottom left you will see a button 'Calculated Item'. Cli…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61235/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61235/read.awp[WD21][HFSQL21] Case in HFSQL Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61234/read.awp9 Jun 2017 15:51:00 ZHi, Yes you can create an array of structures and do filetoarray In the table description choose variable as datasource and …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61234/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61234/read.awp[WD21][HFSQL21] Case in HFSQL Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61233/read.awp9 Jun 2017 15:42:00 ZThanks Piet. That's what I'm doing. If I could use a query file, it's easier for me, just assign that query in the content ta…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61233/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61233/read.awp[WD21][HFSQL21] Case in HFSQL Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61232/read.awp9 Jun 2017 15:30:00 ZHi, You can execute a text based SQL query using hExecuteSQLquery, check the Help. Kind regards, Piethttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61232/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61231-wd21-hfsql21-case-hfsql-query-61232/read.awp[WD21][HFSQL21] Case in HFSQL Query