PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV 2024 → HFSQL control center
HFSQL control center
Iniciado por Buherka, jun., 22 2022 8:22 PM - 4 respostas
Publicado em junho, 22 2022 - 8:22 PM
Hi

I want to use an SQL function.
But it doesn't work.
Do you know HFSQL?
Help is included, but little info.
Publicado em junho, 23 2022 - 8:48 AM
The point is missing.
I want to use CREATE VIEW.
Membro registado
1 mensagem
Publicado em junho, 30 2022 - 7:07 AM
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.
Membro registado
6 mensagems
Publicado em julho, 13 2022 - 12:12 PM
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
Mensagem modificada, julho, 13 2022 - 12:13 PM
Membro registado
6 mensagems
Publicado em setembro, 23 2022 - 3:47 PM
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.