Stack Overflow
Stack Overflow

Questions tagged [hyperfilesql]

HyperFileSQL operates with Windows and Linux, with Mobile devices, with networks of any size and any type, and it automatically manages concurrent accesses. Several version of HyperFileSQL are available: local, network, Client/Server (Windows and Linux) and Mobile.

HyperFileSQL is a database engine included in the development environments (WINDEV, WINDEV Mobile and WEBDEV).

HyperFileSQL operates with Windows and Linux, with Mobile devices, with networks of any size and any type, and it automatically manages concurrent accesses. Several version of HyperFileSQL are available: local, network, Client/Server (Windows and Linux) and Mobile.

HyperFileSQL is very powerful, very fast and very reliable. HyperFileSQL has already been deployed on millions of sites worldwide. The HyperFileSQL engine can be freely distributed with your applications developed with WINDEV, WEBDEV and WINDEV Mobile.

http://www.windev.com/pcsoft/hyperfile.htm

15 questions
3
votes
1 answer

Data truncated at the 256th character - PHP with HFSQL database, using PDO ODBC pilot

I am creating a WebSite with PHP and HyperFileSQL, based on PDO & ODBC for the connection. I am using the 7.1.9 release of PHP and working under WampServer. But I have an issue when retrieving text data with more than 255 characters : the data is…
Mickael
  • 51
  • 4
3
votes
3 answers

How to open Windev HFSQL Fic files

I'm trying to read a FIC file that is not encrypted (indeed, the data can almost be read when displaying it). I want to convert this file to a more convenient format, CSV, XML, SQL, etc... When I try to open it with Windev Express 19, I have an…
Uelb
  • 3,947
  • 2
  • 21
  • 32
2
votes
2 answers

Can't connect to HyperFileSQL using php with odbc

I have a database with HyperFileSQL and I want to access this database via php. If I use IODBC to connect with iodbc.ini, it works !!! But when I want to connect from php with odbc it doesn't I have this in return : SQLSTATE[0] SQLDriverConnect: 0…
nawfal
  • 21
  • 3
1
vote
1 answer

Accessing a hyperfileSQL data via #

I have an application designed by WinDev, and it stores its data in hyperfilesSql files. What I want to do, is to extract these data using a C# application. I tried to find a OleDb Provider for these hyperfilesSql, but with no result. Any help?
SidAhmed
  • 2,332
  • 2
  • 25
  • 46
1
vote
2 answers

how to create temporary database table with windev mobile

I created an application for android with mobile Windev and in this application. I have an order entry system. To do this I use an array variable to store in memory all customer orders before recording them at the last moment in the database…
Zogre
  • 73
  • 1
  • 1
  • 10
1
vote
1 answer

Use pyodbc library to connect to an Hyperfilesql

Hi everyone this is my first question on this website. So i'm working on a Python Project at work. And i have to connect my Python/Django application to an HyperfileSQL (Windev) database to write some information on the HyperFile tables. I've…
user3303156
  • 11
  • 4
1
vote
1 answer

How can I view structure and foreign keys of a classic HyperFileSQL database?

I have a classic HyperfileSQL database which I need to convert (.FIC files) I'm trying to get some overview of the structures and keys in the database. So I downloaded WinDev Express, and I got the 'HyperFileSQL Control Center' now. With this tool,…
Erik Dekker
  • 2,395
  • 5
  • 33
  • 55
0
votes
0 answers

How to add a row with composite keys (HFSQL)

in my company I am trying to make a program that allows us to complete our erp using its hfsql database, for example I would like to be able to add item movements, but in my last 2 columns of my table they are composite keys . When I ignore them I…
Antoine
  • 1
0
votes
1 answer

How to manage composite keys with pypyodbc

im a begginer in python and i want to connect to an hfsql server in python to add a line in a table, but i've 2 composite keys in this table and dont know how to manage it, when im trying to ignore it, the error says the number of columns is wrong.…
Antoine
  • 1
0
votes
0 answers

Shiny app isn't working with ODBC data base connection after being deployed

My R shiny application works locally but after I deploy it I get the error in logs : 2022-10-26T14:31:25.572430+00:00 shinyapps[7427210]: Warning in RODBC::odbcDriverConnect("DSN=HFSQLdb") : 2022-10-26T14:31:25.572461+00:00 shinyapps[7427210]: …
Arthur
  • 1
  • 1
0
votes
0 answers

Protect SQL queries from SQL injection when using HyperFileSQL

The problem: I can't use odbc_prepare or PDO->prepare with my queries because the driver I'm using (HyperFileSQL) has many issues. So, what can I do? Details: I'm able to use PDO for some queries when my data doesn't contain big strings (more than…
Mickaël
  • 1
0
votes
1 answer

Synonyms in hyperfilesql and reserved keyword user

How can I create a synonym in HyperFileSQL? I have a table named USER and I cannot Access it via ODBC. I can't rename it, so I want to create a synonym for it. How do I do this?
nawfal
  • 21
  • 3
0
votes
1 answer

Make a select with one of the column based on other select and SUM

I'm working with windev 17 using the database hyperfile client/serveur. I have a table named Operation with colums (accountNumber, date, amount, operationType ). operationType can take two values: "payment" and "withdrawal". I want to select the…
blaiso
  • 347
  • 4
  • 6
  • 15
0
votes
3 answers

Make a select with one of the column based on other select

I'm working with windev using the database hyperfile client/serveur. I have a table named Operation with colums (accountNumber, date, amount, operationType ). operationType can take two values: "payment" and "withdrawal". I want to select the List…
blaiso
  • 347
  • 4
  • 6
  • 15
-1
votes
1 answer

SQL (HFSQL) : INNER JOIN not symetric in performances if WHERE clause?

I have a basic HFSQL database, with 3 tables: Company, Person and Worker. Each table has ~5 columns, and 5000 entries. Worker has a foreign key to person called IDPerson, and a foreign key to entity called IDCompany. I tested the 2 following queries…
Ricola3D
  • 2,402
  • 17
  • 16