|
|
|
|
|
- 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
Native Progress Connector: Specific features and remarks
Available only with this kind of connection
The following paragraphs present the main aspects and specific features of the Native Progress Connector. Required versions Caution: This version of the Native Progress Connector is only supported in WINDEV and/or WEBDEV SaaS. 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|