Toad for Data Analysts 2.6 works properly with a test .tsm file. In Toad for Data Analysts 3.0 (and 3.1) w these actions no longer performed as in 2.6
I open Toad for Data Analysts 2.6.1.
I connect to a Sybase ASE db. I open a test.tsm file, toadTst.tsm.
Toad for Data Analysts launches the Query Builder with toadTst.tsm opened properly.
I can click on the query tab to show that the query is generated properly.
Doing the same steps in Toad Data Point 3.x, I try to open a test.tsm file, toadTst.tsm. Although he connected, I am prompted again to make the connection. I input the login credentials again and the message is generated:
Toad for Data Analysts:
Cannot open saved querytoadTst.tsm for selected “
I click OK.
The .tsm file is sent to the Editor. I try to save the file as .tsm file. I am not given that file format option in the drop down menu. Instead I send the query by right clicking and bringing up the context menu and selects Send to the Query Builder. This appears to work. However, the parameters in the WHERE clause have been omitted in the Query Builder grid. If I click on the SQL tab, I can see the parameters in the WHERE clause.
If I try to input the parameters in the WHERE clause manually, the constant parameter is set to a COLUMN and not a value in the WHERE condition window.
If I manually input the value, I can see it in the grid; however, it creates an ADDITIONAL sub-clause in the WHERE clause. The original sub-clauses and its parameters are still there.
This issue was fixed in Toad Data Point 3.3. The latest version of Toad Data Point can be downloaded here.