NATIVE SQL SERVER CONNECTOR (FROM VERSION 7)
WINDEV and WEBDEV connect to SQL Server using a fast and powerful "Native Connector", as well as ODBC and OLEDB.
All the features of the environment are available.
Setup is extremely simple.
You only need one license per server.
An unlimited number of computers can access the server.
(This Native Connector supports versions 7, 2000, 2005, 2008, 2012, 2014, 2016, 2019 and 2022 as well as Express versions of SQL Server. This Native Connector also manages access to SQL Azure databases)
Here is a list of the main features of the Native SQL Server Connector:
| Use SQL commands | Yes |
| Use HRead* commands for programming without knowledge of SQL | Yes |
| Compatibility with HFSQL programming (file, query) | Yes |
| WINDEV syntax "Table.column", "Query.Column" available when coding | Yes |
| Automatic assignment of screen buffers to a table: FileToScreen, ScreenToFile | Yes |
| RAD | Full |
| Automatic browse tables | Yes |
| Automatic input tables (Add/Modify/Delete) | Yes |
| Tables: automatic search | Yes |
| Tables: automatic integrity management | Yes |
| Table completion using partial fetch (no wait) | Yes |
| Integration with the environment (assisted input, structure import, etc.) | Yes |
| WDMAP file viewer | Yes |
| WDETAT | Yes |
| Query editor | Yes |
| Installation | Automatic |
| MDAC layer | Not required |
| Speed | Very high |
| Automatic management of modification conflicts | Yes |
| Automatic management of duplicates | Yes |
| Automatic management of required items | Yes |
| Technical Support via Direct Assistance | Yes |
| Table locking | Yes |
| Transaction | Yes |
| Management of automatic identifiers | Yes |
| Filter/Search on queries | Yes |
| Add/Delete/Modify in queries | Yes |