NATIVE SQL SERVER ACCESS (FROM VERSION 7)
WINDEV is linked to SQL Server by ODBC, by OLEDB, but also and above all via «Native Connectors» which is fast, powerful and highly efficient.
All the functions of the environment are available.
Installation is extremely simple.
You need one license per server.
An unlimited number of stations can access a server.
Below is a list of the key features offered by native SQL Server access:
| Use of SQL commands | Yes |
| Use of HRead* commands programming without knowledge of SQL | Yes |
| Compatibility with HFSQL programming (file, query) | Yes |
| WINDEV syntax "Table.column", "Query.column" can be used in programming | Yes |
| Automatic allocation of screen buffers to 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 by automatic fetch (without waiting) | Yes |
| Integration into the environment (assisted input, structure import) | Yes |
| Visualisation of files by use of WDMAP | Yes |
| WDETAT | Yes |
| Query editor | Yes |
| Setup | Automatic |
| MDAC layer | Not required |
| Speed | Very high |
| Automatic handling of modification conflicts | Yes |
| Automatic handling of duplicates | Yes |
| Automatic handling of obligatory input items | Yes |
| Technical Support via Direct Assistance | Yes |
| Table locking | Yes |
| Transaction | Yes |
| Automatic handling of identifiers | Yes |
| Filter/Search on query | Yes |
| Deletion/Modification on query | Yes |