3-tier architecture 1 category, 1 document Accessing HFSQL tables via SAMBA on Linux To access HFSQL tables via Samba on Linux, special settings are required... Aliases on tables: HAlias function The aliases are used to handle... Automatic data modification 3 documents Binding functions 27 documents Blocking tables: correspondence WINDEV 5.5 and higher versions Returns the list of WINDEV or WEBDEV analyses (in HFSQL Classic format) available in a given directory. Browsing the HFSQL tables The "Key" items are used to organize the records in a table in order to optimize the browse or the search... Compatible Hyper File functions 1 document Composite keys A composite key is a key item containing several other items... Database access: summary WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... Database schema shared between earlier WINDEV applications and WINDEV 2025 applications A database schema can be shared between a WINDEV application... Errors while managing tables When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... Filtering a table, a view or a query A filter is used to define through programming a selection of records corresponding to one or more criteria... HFSQL Client/Server functions 1 category, 257 documents HFSQL functions 382 documents HFSQL error handling help WINDEV, WEBDEV and WINDEV Mobile include a module for assisted management of HFSQL errors... HFSQL tables exceeding 2 gigabytes By default, the HFSQL engine allows you to manage large tables (up to 2 gigabytes)... HFSQL thumbnails To optimize the display of images in your application or in your site, you have the ability to use HFSQL thumbnails... HFSQL views An HFSQL view corresponds to a "memory image" of an HFSQL table... Management errors specific to Native Connectors When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... Managing HFSQL Client/Server 31 documents Managing log processes 1 category, 4 documents Managing replications 4 categories, 3 documents Managing statistics 6 documents Managing transactions 1 category, 4 documents Managing triggers 1 category, 3 documents Managing connections WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection... Managing space characters in the searches? The LDAP protocol is increasingly used by the companies... Managing the automatic identifiers when adding a record When adding a record into a HyperFileSQL file (HAdd), three management modes are available for the automatic identifiers... Modifying the query content The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ... Native Access Connector This type of Native Connector allows access to ACCESS databases for better interoperability purposes... Native XML Connector WINDEV and WEBDEV allow you to import and handle a definition of XML files via the data model editor... NULL values in HFSQL WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of the HFSQL data files and for all the other types of accesses (Native, OLE DB, ... Partial indexing of memos You now have the ability to index the content of a text memo item... REP files REP files contain the list of tables handled by the application. Search and full-text index HFSQL proposes a quick search for character strings in the data... Spatial data management 90 documents Types of HFSQL variables 16 documents Unalterable tables This feature is used to signal that a table cannot be modified after writing... Using Unicode in HFSQL tables The database schema proposes two types of Unicode items... WLanguage variables 11 documents