PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil | Messages récents | Connexion |  | Français FR
Accueil → WINDEV 28 → HFSQL control center
HFSQL control center
Débuté par Buherka, 22 juin 2022 20:22 - 4 réponses
#1
Posté le 22 juin 2022 - 20:22
Hi

I want to use an SQL function.
But it doesn't work.
Do you know HFSQL?
Help is included, but little info.
#2
Posté le 23 juin 2022 - 08:48
The point is missing.
I want to use CREATE VIEW.
#3
Membre enregistré
1 message
Posté le 30 juin 2022 - 07:07
Buherka escribió:
Hi
https://www.imessageapp.app/
I want to use an SQL function.
But it doesn't work.
Do you know HFSQL?
Help is included, but little info.

I will endeavor to figure it out for extra.
#4
Membre enregistré
6 messages
Posté le 13 juillet 2022 - 12:12
I didn't check whether this problem has been existing in v21, in HFSQL v22 this problem definitely is there. Received a mail that said that the problem was fixed - it is not. Same goes for importing a HF Classic file via HFSQL CC. Only .fic as the file extension is recognized, however, even if one changes the extension from .DAT (my standard extension) to .fic it will not import anything.

- For import, it is easy to do it by programming.
- for restructuring, use WDMODFIC
For more you can check here:
https://www.wxforum.info/read.php…
https://www.shouldiremoveit.com/hfsql-manager-205387-program.aspx / https://voojio.com/chatroom/omegle
https://shagle.download
Message modifié, 13 juillet 2022 - 12:13
#5
Membre enregistré
6 messages
Posté le 23 septembre 2022 - 15:47
I believe your problem is that you are attempting to utilize the result of an aggregate function as a function argument. This issue might be solved using a SQL subquery. https://www.scaler.com/topics/sql/subqueries-in-sql/
I should state that I have no prior knowledge of HFSQL. This solution is based on fundamental SQL syntax, which is shared by more popular databases such as MySQL, PostgreSQL, and SQL Server.
→ Revenir à WINDEV 28