Release Bulletins for PowerScript Migrator

Last Updated: January 2024

This document provides release bulletins for all versions of PowerScript Migrator (including PowerScript.Bridge).

Versioning of PowerScript Migrator and PowerScript.Bridge

PowerScript Migrator is a SnapDevelop plugin. Each version of PowerScript Migrator must be installed on top of the same version of SnapDevelop, so the versioning of PowerScript Migrator follows the versioning of SnapDevelop (2019 R2, 2019 R3, 2021, etc.)

PowerScript.Bridge is the Nuget package that shall be referenced for use with the C# script that you ported from PowerScript and embedded SQLs with PowerScript Migrator. PowerScript.Bridge is versioned by itself and started from version 1.0.0.

Installation of PowerScript Migrator and PowerScript.Bridge

• Run Appeon PowerBuilder Installer to install the desired version of PowerScript Migrator;
• The instructions on how to install, update, and uninstall PowerScript.Bridge are the same as all the other NuGet packages. Please refer to the SnapDevelop documentation at https://docs.appeon.com/snapdevelop2022r3/SnapDevelop_Users_Guide/Chapter2Working_with_solutions_and_projects.html#managing-nuget-packages.

PowerScript Migrator 2022 R3 GA 3289

Version and Build Info

Released in January 2024.

• PowerScript Migrator: Version 2022 R3 build 3289
• PowerScript.Bridge: Version 2.2.0

What's New

• Internal updates only.

PowerScript Migrator 2022 GA 1878

Version and Build Info

Released in September 2022.

• PowerScript Migrator: Version 2022 build 1878
• PowerScript.Bridge: Version 2.0.0

What's New

• Internal updates only.

PowerScript Migrator 2021 MR 1506

Version and Build Info

Released in January 2022.

• PowerScript Migrator: Version 2021 build 1506
• PowerScript.Bridge: Version 1.0.6

What's New

• Internal updates only.

PowerScript Migrator 2021 MR 1311

Version and Build Info

Released in November 2021.

• PowerScript Migrator: Version 2021 build 1311
• PowerScript.Bridge: Version 1.0.5

What's New

• Internal updates only.

PowerScript Migrator 2021 GA

Version and Build Info

Released in July 2021.

• PowerScript Migrator: Version 2021 build 1288
• PowerScript.Bridge: Version 1.0.4

What's New

• Internal updates only.

Known Issues

PowerScript Migrator 2021 has the following known issues:

• The first SQL parameter might fail to be translated when translating dynamic SQL statements.
• Cannot automatically subtract 1 from the index in a DataWindow expression when translating Datastore methods.
• Different PB transactions cannot be translated correctly when a code block contains multiple transaction objects.
• When translating a visual object (such as a window) that contains a DataWindow, use the Translate Entire Document feature to translate the entire document first, otherwise the DataWindow cannot be accurately translated.
• The translation for "elseif" is split into "else" + [comment] + [newline] + "if".
• The row index (row = insertrow(0)) is translated to [row-1] in the SetItem method (setitem(row - 1, "column")).
• Cannot obtain the current row status data (translated to "-1" by default) when translating the getitemstatus or setitemstatus function. The user needs to manually modify the methods to getrowstatus or setrowstatus.
• An additional pair of curly brackets might be added to the ELSE statement block.

Bug Fixes

PowerScript Migrator 2021 has no bug fixes.

PowerScript Migrator 2019 R3 MR

Version and Build Info

Released in April 2021.

• PowerScript Migrator: Version 2019 R3 build 2703
• PowerScript.Bridge: Version 1.0.3

What's New

• Internal updates only.

PowerScript Migrator 2019 R3 GA

Version and Build Info

Released in January 2021.

• PowerScript Migrator: Version 2019 R3 build 2670
• PowerScript.Bridge: Version 1.0.3

What's New

• Internal updates only.

PowerScript Migrator 2019 R2 MR

Version and Build Info

Released in July 2020.

• PowerScript Migrator: Version 2019 R2 build 2353

• PowerScript.Bridge: Version 1.0.2

What's New

• The GetBlocks and SetBlocks methods of DataStoreExtensions have been renamed to GetBlock and SetBlock.
• Extension methods under PbGlobal have been moved, for example, extension methods for string have been moved from PbGlobal to StringExtensions (likewise, BooleanExtensions, DateTimeExtensions, PbBlobExtensions, TimeSpanExtensions).

Bug Fixes

• (Internal bug) The Update method (DataStore extension method) returns a different value from that in PowerBuilder when nothing is updated.

Known Issues

• When a dynamic SQL statement is translated to SqlExecutor.ExecuteNonQuery, the first SQL parameter may be translated incorrectly.
• If a code block contains multiple different transactions, the transactions may be translated incorrectly.
• The "elseif" is incorrectly translated to “else" + comment + newline + "if".
• The row identifier in a For loop is incorrectly translated to ".value" (for example, "i.value").

PowerScript Migrator 2019 R2 GA

Version and Build Info

Released in April 2020.

• PowerScript Migrator: Version 2019 R2 build 2323

• PowerScript.Bridge: Version 1.0.1

What's New

• DataObject has been moved from DwNet.Data to PowerScript.Bridge.

Bug Fixes

• (Bug 4130) Error occurred when executing or evaluating a computed expression containing IN statement.
• (From Community) No matter whether the condition in a conditional expression is true or false, both the true value and false value are executed.