#1330 Plugin SQLReplace does not function in second SQL Worksheet

[Pete K.]

Snapshot-20171121_2249
macOS 10.13.2
Java runtime: Oracle 1.8.0_151-b12

I opened a connection, have a query in the main SQL Worksheet that uses SQL Replace. It runs fine.

I then open a new SQL Worksheet (Control-N) and run a similar query with the same SQL Replace variables. It fails because the variables have not been substituted.

Example:

SQLReplace set up as:

TCREATOR = KIDWELL

TNAME = MY_TABLE

Main SQL Worksheet has:
SELECT * FROM #TCREATOR.#TNAME -- works fine, presents contents of KIDWELL.MY_TABLE

SQL Worksheet 2 has:
SELECT COUNT(*) FROM #TCREATOR.#TNAME -- fails with SQL code -204 because there is no table called "#TCREATOR.#TNAME"

Expected result: SQL Worksheet 2 should also translate #TCREATOR.#TNAME to KIDWELL.MY_TABLE, same as the main SQL Worksheet.

[Gerd Wagner]

Fixed in our GIT repository. Will be available in future snapshots and versions.

[Pete K.]

Still doesn't work in snapshot 20180206_2232. Should it have been included? Or next one?

[Pete K.]

In snapshot 20180216_1933, this actually got worse. The SQLReplace function does not work in any panel now, not even in the initial primary SQL worksheet.

[Gerd Wagner]

I found a new error concerning the second worksheet. I'm just uploading a new snapshot that fixes this. Sorry for the inconvenience.

On the other hand I'm not able to reproduce the problem that the Plugin isn't working at all. Could you please check if the Plugin is installed.

[Pete K.]

Right, never mind, with the new snapshot it's all working fine. Thanks!