PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → Nee a hint : enumerate tables from mySQL
Nee a hint : enumerate tables from mySQL
Iniciado por stefan.kern, jul., 19 2018 8:37 PM - 5 respostas
#1
Publicado em julho, 19 2018 - 8:37 PM
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.
#2
Publicado em julho, 20 2018 - 1:33 PM
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
#3
Publicado em julho, 21 2018 - 12:48 AM
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.
#4
Publicado em julho, 21 2018 - 1:20 PM
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
#5
Publicado em julho, 23 2018 - 10:52 AM
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
#6
Publicado em julho, 23 2018 - 6:43 PM
Hi Fabrice and Paulo,

thanks a lot, thats what I needed
→ Voltar para WINDEV 2024