ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Native Connectors/Native Accesses / Native Progress Connector
  • Overview
  • Main remarks
  • Required versions
  • Using WLanguage commands in SQL queries
  • Unicode items
  • Required table
  • UPDATE query on a memo
  • Inserting more than 100 records with a memo
  • Text memo and binary memo
  • Specific features of Native Progress Connector
  • Analysis options
  • Queries
  • Memo
  • Closing the connection and transaction
  • Accented characters in the aliases
  • HFSQL lock
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 Progress Connector: Specific features and remarks
Native Connectors (Native Accesses)Available only with this kind of connection
Overview
The following paragraphs present the main aspects and specific features of the Native Progress Connector.
Main remarks

Required versions

Caution: This version of the Native Progress Connector is only supported in WINDEV and/or WEBDEV 2024.

Using WLanguage commands in SQL queries

WLanguage commands cannot be used in 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 08/29/2023

Send a report | Local help