PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → HFSQL control center
HFSQL control center
Started by Buherka, Jun., 22 2022 8:22 PM - 4 replies
Posted on June, 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.
Posted on June, 23 2022 - 8:48 AM
The point is missing.
I want to use CREATE VIEW.
Registered member
1 message
Posted on June, 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.
Registered member
6 messages
Posted on July, 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
Message modified, July, 13 2022 - 12:13 PM
Registered member
6 messages
Posted on September, 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.