Difference: Appx550FeaturesAppDesign (12 vs. 13)

Revision 132020-05-07 - JeanNeron

Line: 1 to 1

META TOPICPARENT	name="Main.Appx550Features"

APPX 5.5.0 Features - Application Design

Line: 215 to 215

Although it looks like the results will replace the permanent disk DMO PROSPECT file, APPX only updates the cached version of the file and opens it for you. The BEG READ statement will use the cached version. This approach allows you to use the name of existing files to get results instead of creating new files just for that purpose.

Added:

>
>

You can send any SQL statement, including UPDATE or INSERT INTO, etc. If you update a table you need to do a explicit commit using (COMMIT statement) afterward.

If you send a statement with no reply, such as an UPDATE statement, the SQL statement will still open a cached version of the indicated file. In this case, a READNEXT on the file would fail but the SQL statement still gets executed. If you do a commit you should see your changes in the database.

The SQL statement can only operate on files stored in a RDBMS, and only indexed files can be stored there, so memory, one record and consecutive files wil not work with this command.

The SQL statement uses the FMS group associated with the named file to connect to the RDBMS.

Currently, APPX ignores errors or returned values from server. Make sure your SQL is valid when using this command.

New API’s

A number of new APIs have been added:

View topic | History: r20 < r19 < r18 < r17 | More topic actions...