PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → Nee a hint : enumerate tables from mySQL
Nee a hint : enumerate tables from mySQL
Débuté par stefan.kern, 19 juil. 2018 20:37 - 5 réponses
Posté le 19 juillet 2018 - 20:37
Hi 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.
Posté le 20 juillet 2018 - 13:33
Hi Stefan

yes it does and you can then use hListItem

Another way of doing what you want is to use the SQL script generated by the analysis at each generation. That script is for CREATING the tables only, but you can massage it to do alter tables instead (I knew of one developer who coded that way to make a module for postgres)

Best regards
Posté le 21 juillet 2018 - 00:48
Hi Fabrice,

thanks for your answer.
So, hlistfile() and hlistitem() read the Analysis, not he physical files, correct?
Does anyone has an idea how to list the phyical files?

Thanks and have a good night

Stefan.
Posté le 21 juillet 2018 - 13:20
Hi Stefan,

yes, they both work against the analysis... For physical files, use flistfile or, in the case of an external SQL DB, use the SQL command available with that specific DB.

Best regards
Posté le 23 juillet 2018 - 10:52
For the phyical files you must use the MYSQL views.

I don't know MYSQL but in other db engines you can use this:
select * from information_schema.tables
select * from information_schema.columns
Posté le 23 juillet 2018 - 18:43
Hi Fabrice and Paulo,

thanks a lot, thats what I needed