PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Main remarks
  • Required versions
  • Using WLanguage commands in the 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 Access
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Native Progress Access: Specific features and remarks
Native AccessesAvailable only with this kind of connection
Overview
The following paragraphs present the main remarks and the specific features of Native Progress Access.
Main remarks

Required versions

Caution: This version of Native Progress Access operates with WINDEV 23 and/or WEBDEV 23.

Using WLanguage commands in the SQL queries

The WLanguage commands cannot be used in the SQL queries.

Unicode items

The Unicode items are not supported by the Native Progress Access. 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.

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 Access

Analysis options

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

Queries

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

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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment