Native Progress Connector: Specific features and remarks

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Native Connectors/Native Accesses

Native Progress Connector

Native Progress Connector: Specific features and remarks

Overview

Main remarks

Specific features of Native Progress Connector

See also

Native Progress Connector for WINDEV and WEBDEV

Native Progress Connector: Specific features and remarks

Available only with this kind of connection

Overview

The following paragraphs present the main remarks and specific features of the Native Progress Connector (also called "Native Progress Access").

Main remarks

Required versions

Caution: This version of Native Progress Connector operates with WINDEV 24 and/or WEBDEV 24.

Using WLanguage commands in the SQL queries

The WLanguage commands cannot be used in the SQL queries.

Unicode items

Unicode items are not supported by Native Progress 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 data files containing items in Unicode format are created.

Required table

The "sysprogress.systables" table must be accessible in read mode to the connected user. Otherwise, an error ("Version of Progress not supported") is displayed.

UPDATE query on a memo

Progress does not allow you to perform an UPDATE query on a Memo item (LVARBINARY). However, WINDEV and WEBDEV give you the ability to update the memo by using HModify (the record is deleted then added).

Inserting more than 100 records with a memo

Inserting more than 100 records containing a memo item triggers the error #9799. This error is referenced beside Progress (reference P26935).

To avoid this error, close the connection before the 100th record, then re-open the connection.

Text memo and binary memo

In a Progress database, all the memos are binary memos. However, a text can be saved in the binary memos.

Specific features of Native Progress Connector

Analysis options

The analysis options regarding 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.

Queries

No search, filter or sort (ORDER BY) can be performed on aggregate columns (Min, Max, etc.).

Memo

The memos exceeding 2 MB cannot be inserted.
SQLGetMemo or SQLGetTextMemo cannot be used to retrieve a memo in a text string. You must use HExtractMemo. This problem will be fixed in a forthcoming version.

Closing the connection and transaction

If the transaction was not ended, a General Protection Fault may occur when closing the connection. This problem will be fixed in a forthcoming version.

Accented characters in the aliases

If an alias contains accented characters, you must:

enclose the alias in double quotes,
use the hQueryWithoutCorrection constant when running a query that is using this alias.

HFSQL lock

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