| WINDEV: Client/Server, Network, Local, Pocket PC |
|
You can freely distribute the HyperFileSQL engine with your WINDEV applications.
Note that you can of course access HyperFileSQL client/server from a Pocket PC.
The "HyperFileSQL" database engine comes standard with WinDev. It is a reliable, robust engine, already in use in millions of sites.
HyperFileSQL is extremely fast.
HyperFileSQL lets you work with large volume of data (up to 329 quadrillion records).
The engine is totally integrated with the development environment. At any time, in any editor, you have access to the references and to the data dictionary. The interaction between the user interface and the database management system allows for easier and faster programming.
The power and the simplicity with which the W-Language 5GL manages databases are amazing. For example, seeking a record, and all the associated routines (opening the file, assigning data, etc.) is done in one simple line of code: HReadSeek(CUSTOMER,NAME,"DOE") The source programs are clear, easy to write and especially easy to maintain; this reduces the chance for errors, and makes the applications you develop more reliable, and faster. Plain English commands make it easier to use; the code is self-commented! The HReadSeek command can be understood by any developer, even the brand new ones! You can also program in French: the command becomes hLitRecherche Of course, you can also program a traditional SQL query for this purpose: SELECT * from CUSTOMER where NAME= ‘DOE’ This very simple, very fast and very reliable routine is generated on demand by the RAD tool or by one of the numerous wizards when you create your windows!
The ODBC driver, which you can freely distribute with your WINDEV applications, lets WinDev data be accessed from third-party applications.
HyperFileSQL installs immediately, without requiring any other software. For example, if following a physical problem with the database it should be reindexed, it is done automatically. Database administration is automatic: no need to involve human resources!
A toolbox including a set of useful tools comes with the product: import data, check database, view data, performance optimizer, and more. The WDCONVER module, provided with WinDev, lets you import data in various format: Access, dBase, Text, Oracle, etc. HyperFileSQL, which is included with WINDEV, is an undeniable asset; reliable, fast, secure, free.
HyperFileSQL 9 automatically manages concurrent access to a record, without requiring any programming. In case of access conflicts, a (customizable) window automatically comes up. You can also handle concurrent access in your program for special cases. Here, 2 users are trying to modify the same record at the same time! A (customizable) window automatically comes up and asks for the correct value. No programming is required.
HyperFileSQL supports all the file data types: • binary and character strings (phonetic find is available) • numeric (integer, real, currency, etc.) • date, time, duration • text and binary memo (image, sound, video, etc.) • the "NULL" value is also supported All key types are supported: automatic identifier, text, numeric, date, time, composite key.
|