|  | January 2000
| More Information About The Magic Gateway for Oracle Versions 8.20-8.10 |
| Dear Developer, We are happy to introduce The Magic Gateway for Oracle Version 8.20-8.10. This version is a QCR-fix release for Magic Versions 8.20 and above. We hope you will find working with our product enjoyable and fruitful. |
| Changes in the current release: 8.10 QCR 766464 - Convert is not activated when changing the picture of a column in Magic. 8.9 QCR 777157 – After importing from Magic 7, direct SQL program to execute stored procedure with output parameter type CHAR does not display field. QCR 972338 - Working C\S using the Storage Unsigned Integer and inserting values to the field, in the log file it appears as zero (0) instead of the actual value that was entered in the field. 8.8 QCR 764129 – Numeric values are also sorted when using NLSSORT. Random crashes in Direct SQL. 8.7 QCR 2266 – Magic crashes when using NLSSORT=Y in the database properties, running a program that opens many tables. QCR 771777 – Wrong default value is shown in the table properties, getting definition of a table with default values. QCR 754856 - Connection failure trying to connect using an Oracle 8 client with Oracle 7.3 gateway at the first trial, while the second trial succeeds. 8.6 QCR 428387 - When using two different connections to Oracle (two database entries in the database repository), the commit is sent to the first connection instead of to the current connection . QCR 938132 - Magic crashes, giving "Internal transaction error" when connecting to two different Oracle databases, and executing a batch task that performs Rollback in the task level. NLSSORT support NLSSORT lets applications perform string matching that follows alphabetic conventions. Normally, character strings in a WHERE clause are compared using the character's binary values. Using NLSSORT in the WHERE clause lets users use a foreign-language Oracle client while sorting by the alphabetic order in their own language. To use this feature, add the following flag in the Database Properties\SQL\Database Information field in the Database repository: NLSSORT=Y This flag adds the NLSSORT function to all the WHERE clauses Magic sends to the DB as follows: NLSSORT (value) comparison_operator NLSSORT(column) Note: Using this flag may cause performance problems because Oracle sorts the index according to the new order. In addition, this flag causes case insensitivity of the data stored in the database. |
| Thank you, The Magic Version 8 Team |