HFSQL

WINDEV, WEBDEV AND WINDEV MOBILE NATIVE ACCESS WINDEV, WEBDEV and WINDEV Mobile are Integrated Development Environments. WINDEV is the #1 IDE in France. The HFSQL access is “native” in WINDEV, WINDEV Mobile and WEBDEV, which means that the access performance (read, write) is optimized. HFSQL data schemas are also directly and instantly recognized by the WINDEV, WEB- DEV and WINDEV Mobile environments, and therefore benefit from the automation and wizards of these environments: auto- matic creation of UI, controls, completion in the code editor ... Data binding is supported, visually in the environment and by programming. MODELING A DATABASE Defining a database schema is easy thanks to the powerful visual editor provided: the data model editor Numerous wizards are available to guide you. The visual editing of the data model (cre- ation, deletion, modification of the tables, columns, relationships, constraints, index, triggers,...) enables you to define a data- base schema without having to write any SQL code. The editor displays graphically the organi- zation of the data and processes. An automatic import of existing schemas can be performed. The editor knows how to import schemas from databases such as HFSQL, SQL Server, Oracle, OLE DB, … To create a data description, we start by specifying the type of columns, the type of keys (index) ... Any new column is stored in the data dic- tionary. Then, all you have to do is define the rela- tions between the tables. To link tables, simply draw a link with the mouse! The wizard asks questions in natural lan- guage to determine the nature of the rela- tionships. For example “ A customer can have several orders: YES or NO ”, “ Each order can have several products: YES or NO ”, etc. The wizard also asks whether the check for referential integrity must be automatic or not. The wizard then asks whether to generate any necessary relationship tables, or use existing ones. Finally, the wizard asks for the caption of relationships: the schema is defined. A documentation of the database schema can be printed at any time (paper, HTML, PDF, Word, OppenOffice). The visual data model editor also supports: • Reverse analysis from a server • Logical or physical modeling • Connection editing • Schema comparison • Schema history • The generation of DDL scripts • The export of the data model in a vector image format. Pages taken from a documentation CURSOR IN WINDEV AND WEBDEV Bi-directional cursors are automatically cre- ated for reading queries. Native programming in WINDEV and WEBDEV is greatly facilitated by a set of highly advanced automations and wizards. Relationships between tables are automat- ically detected. The access to a database control is easily defined using a clear and intuitive syntax: table name, column name (For example: customer.name ). PERFORMANCE TUNING, AUDIT The Profiler and the Dynamic Audit let you analyze an application’s performance, and thus verify that the data access is pro- gramed in an optimum way. Tuning allows you to optimize queries, check index, set up statistics, monitor the server and control the memory, the CPU use, disk space, connections, etc. The SQL Explain function allows you to monitor the order in which a query is run. HFSQL • www.windev.com 13 LINK WITH WINDEV, WEBDEV AND WINDEV MOBILE