ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Progress Native Connector: Features and notes
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

Attention: This version of the Progress Native Connector only works with WINDEV and/or WEBDEV 2025.

Using WLanguage commands in SQL queries

WLanguage commands cannot be used in SQL queries.

Unicode items

Unicode fields are not managed by the Progress Native 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 by 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 uses 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: 09/21/2024

Send a report | Local help