|
GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile |
| | | | | |
| Converting WebDev24 app from HF Classic to HF Client/Server |
| Iniciado por Ericus, abr., 14 2025 10:26 AM - 2 respostas |
| |
| | | |
|
| |
| Publicado em abril, 14 2025 - 10:26 AM |
Good day
The subject says it all. I managed to install and import the HF Classic data and all of that.
But my issue is my application won't run a Query and if so it creates a new database within the existing database folder. I have no idea where I am going wrong.
Please help me out here.
Regards |
| |
| |
| | | |
|
| | |
| |
Membro registado
187 mensagems |
|
| Publicado em abril, 14 2025 - 2:21 PM |
Good morning Mister
I see your request. You want to connect a C/S database. You need to replace the database connection code with HOuvreConnexion().
Here's some code to help you.
cnConnection is a Connexion // EDD (11/24): Connection Description
cnConnexion..Utilisateur = "Utilisateur"
cnConnexion..MotDePasse = "Mot de passe"
cnConnexion..Serveur = "Adresse ip | Nom serveur"
cnConnexion..BaseDeDonnées = "Base de données"
cnConnexion..Provider = hAccèsHFClientServeur
cnConnexion..Accès = hOLectureEcriture
cnConnexion..InfosEtendues = "Infos étendues"
cnConnexion..OptionsCurseur = hCurseurClient
IF HOuvreConnexion(cnConnexion) = False THEN // EDD (11/24) : Opening the connection and a validation check
Info(ErreurInfo(errComplet))
EndProgram()
ELSE
info("The relationship to the C/S database is successful.")
END
NB: Be careful, the C/S connection is often coded using the HOpenConnection() syntax, then you need to implement the cnConnection variable in the HExecuteSQLQuery() code.
NB: You need to change the entire C/S database relationship because native access is required for this.
Best regard
Mr.RATSIMANDRESY
Niry Aina Eddy |
| |
| |
| | | |
|
| | |
| |
Membro registado
3 mensagems |
|
| Publicado em abril, 15 2025 - 9:14 AM |
It sounds like you're dealing with a bit of a tricky situation. Based on what you've described, the issue could be related to the database configuration after migrating from HF Classic to HF Client/Server. I’d suggest first checking if the connection string or database path is properly set in the new environment. Sometimes, after a conversion, the app might point to a default location, which could explain why it's creating a new database in the folder. Another thing to consider is whether the application has the correct permissions to access the existing database; if it doesn’t, that could also prevent queries from running correctly.
Also, it's worth reviewing how queries are executed in HF Client/Server mode compared to HF Classic since there might be slight differences in how they’re handled. Lastly, enabling logging or debugging could give you more insight into what's going wrong when the query is executed. |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|