PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
HFSQL control center
HFSQL control center
Started by Buherka, Jun., 22 2022 8:22 PM - 4 replies
Connect yourself…
Buherka
#1
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.
Report
0
0
buherka
#2
Posted on June, 23 2022 - 8:48 AM
The point is missing.
I want to use CREATE VIEW.
Report
0
0
Albert251
#3
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.
Report
0
0
SandraLewisFrin
#4
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
Report
0
0
Mobiwann
#5
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.
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text