pcsoft.us.windevCopyright 2026, PC SOFT23 Jul 2018 18:43:00 Z19 Jul 2018 20:37:00 ZHi Forum, I am trying to create something like hmodifystructure() myself to use it for mySQL. No I wonder, wheather I can enumerate the physical files and their items on the Server. Am I Right, that Hlistfile() lists the files of the Analysis? Thanks for help. Best Regards Stefan.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66323/read.awp23 Jul 2018 18:43:00 ZHi Fabrice and Paulo, thanks a lot, thats what I neededhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66323/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66323/read.awpNee a hint : enumerate tables from mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66315/read.awp23 Jul 2018 10:52:00 ZFor the phyical files you must use the MYSQL views. I don't know MYSQL but in other db engines you can use this: select * fr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66315/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66315/read.awpNee a hint : enumerate tables from mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66289/read.awp21 Jul 2018 13:20:00 ZHi Stefan, yes, they both work against the analysis... For physical files, use flistfile or, in the case of an external SQL D…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66289/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66289/read.awpNee a hint : enumerate tables from mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66280/read.awp21 Jul 2018 00:48:00 ZHi Fabrice, thanks for your answer. So, hlistfile() and hlistitem() read the Analysis, not he physical files, correct? Does…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66280/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66280/read.awpNee a hint : enumerate tables from mySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66271/read.awp20 Jul 2018 13:33:00 ZHi Stefan yes it does and you can then use hListItem Another way of doing what you want is to use the SQL script generated…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66271/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66263-nee-hint-enumerate-tables-from-mysql-66271/read.awpNee a hint : enumerate tables from mySQL