ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Native Connectors/Native Accesses / Native Informix Connector
  • Necessary version
  • Required version of WINDEV/WEBDEV
  • Main remarks
  • Unicode items
  • Configuration
  • Searches, filters and queries
  • Managing the dates, times and datetime
  • Specific features of Native Informix Connector
  • Analysis options
  • Identical records
  • Forcing the automatic identifier
  • INSERT queries and automatic identifier
  • Locks
  • Unsupported types
  • Restoring memos
  • Links
  • Alias and accented characters
  • Generic search
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Native Informix Connector: Specific features and remarks
Native Connectors (Native Accesses)Available only with this kind of connection
Necessary version

Required version of WINDEV/WEBDEV

Caution: This version of the Native Informix Connector works with WINDEV and WEBDEV SaaS.
Main remarks

Unicode items

The Unicode items are not supported by Native Informix Connector. We advise you to use text items in Ansi format and to perform the conversion (if necessary) with UnicodeToAnsi.
HCreation will display an error message when creating files containing items in Unicode format.

Configuration

In the parameters for configuring the Informix client layer, the "DELIMIDENT" parameter should be set to "YES".
This setting is required if the names of the tables (or table columns) contain accented characters ("ProductsOrdered" for example.

Searches, filters and queries

No search can be performed and no filter can be defined on an item used in the HAVING clause (HReadSeekxx and HFilter).
Indeed, with Informix, an item cannot be used both in the HAVING clause and in the WHERE clause.

Managing the dates, times and datetime

The following functions are used by Native Informix Connector to format the values of date, time and datetime types in the requests sent to the server:
  • Date: MDY(MM,DD,YYYY)
  • Time: DATETIME(HH:MM) HOUR TO MINUTE
  • Datetime: DATETIME(YYYY-MM-DD HH:MM:SS.ccm) YEAR TO FRACTION
Special case for the Informix servers version 7.23 or earlier
The MDY functions is not supported by these servers. To avoid this limit, Native Informix Connector can exchange the dates as character strings in Y4MD format. In this case, you must define on the client computer the environment variable DBDATE to Y4MD with Setnet32.
Remark: If Native Informix Connector detects that the client version is equal to 7.23 (or earlier), it checks in the registry whether the DBDATE string value is defined to Y4MD at the following location if the DEFAULT_USER_SETTING value is defined to CU:
HKEY_CURRENT_USER\Software\Informix\Environment
otherwise, at the following location:
HKEY_LOCAL_MACHINE\Software\Informix\Environment
Specific features of Native Informix Connector

Analysis options

  • The analysis options regarding the full-text indexes are not supported by the Native Connector.
  • The analysis options regarding the partial indexing of text memos are not supported by the Native Connector.

Identical records

The Native Informix Connector cannot differentiate between two identical records (which means with identical values for all items, excluding memo items).
When a record is modified or deleted, all the identical records will be modified or deleted.

Forcing the automatic identifier

The hForceIDAuto constant cannot be used with HModify. This constant can only be used with HAdd.

INSERT queries and automatic identifier

The automatic identifiers are not supported by the INSERT queries (created through programming or in the query editor). To use an automatic identifier, call HAdd on the table.

Locks

The locks CANNOT be used with the HFSQL functions in this version.

Unsupported types

The ROW, MULTISET and LIST items are not supported by the Native Informix Connector.

Restoring memos

The memos are not restored when HRestorePosition is used in the queries and in the reports.
Consequence: In a Table control based on a query, the memos no longer appear:
  • when clicking a row of the Table control,
  • when moving the scrollbar in the Table control.

Links

  • HListLink is not supported in this version.
  • The links between tables are not supported in this version.

Alias and accented characters

In this version, the aliases (for names of tables and/or table columns) that contain an accented character are not supported.

Generic search

A generic search performed on a character string that contains the "*" character may fail. A "General Error" is displayed by the Informix driver.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/14/2024

Send a report | Local help