Toad Data Point - Beta Forum - Toad Data Point Beta Program - Toad World

Toad Data Point Beta Program Community

Toad Data Point - Beta Forum

yan2
Follow / 19 Mar 2017 at 3:22am / Toad Data Point Beta Program
Latest post by on 24 Jun 2017 at 1:54am

Azure SQL DB - object MS_Description cannot be displayed

Expand content
There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft...

There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft.com/en-us/library/ms180047.aspx, the green checkmark next to Azure SQL DB is new (since Jan apparently).

e.g. the following statement does not error out anymore - it did last time I tried a few months ago.

EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = 'test description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE',  @level1name = 'mytable' 


Can TDP be updated to act like with SQL Server connections and allow to display the Description, among others,

  • of the columns in the properties tab of a table
  • in the Object Explorer context-menu, Options > Extra Columnazure (in both Tables and Columns panes)
210 3 / Create an account to join the discussion.
joseluis.teixeira
Follow / 29 May 2017 at 10:05am / Toad Data Point Beta Program
Latest post by on 1 Jun 2017 at 7:22pm

Beta Download :: Wrong link/version

Expand content
Hello, I was trying to download latest Beta release, but it seems that something went wrong on download link. On forums announcement we can find this: But when reaching download page http:...

Hello,

I was trying to download latest Beta release, but it seems that something went wrong on download link.

On forums announcement we can find this:

But when reaching download page http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program, this is what is showing:

Can you provide download link for latest release?

100 1 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.128 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

84 0 / Create an account to join the discussion.
joseluis.teixeira
Follow / 29 May 2017 at 10:01am / Toad Data Point Beta Program
Latest post by on 29 May 2017 at 10:09am

Know Issues :: ODBC Progress Openedge

Expand content
Hello, I was reading http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm and found this Defect ID: ST69744 On my last trial I was successfully working on several Openedge...

Hello,

I was reading http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm and found this Defect ID: ST69744

On my last trial I was successfully working on several Openedge Progress databases through Toad Datapoint ODBC connection.

103 1 / Create an account to join the discussion.
tzujeff
Follow / 4 May 2017 at 7:56am / Toad Data Point Beta Program
Latest post by on 18 May 2017 at 12:42pm

Toad Data Point Beta 4.2.0.206- select to file, export options, append...

Expand content
the append rows grayed out when filename with variable, for example Rate#CurrentClass#.xlsx

the append rows grayed out when filename with variable, for example Rate#CurrentClass#.xlsx

Unanswered 104 1 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 14 Apr 2017 at 9:14pm / Toad Data Point Beta Program
Latest post by on 27 Apr 2017 at 7:00pm

Toad Data Point Beta 4.2.0.206 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

292 5 / Create an account to join the discussion.
Butter
Follow / 15 Mar 2017 at 10:54am / Toad Data Point Beta Program
Latest post by on 28 Mar 2017 at 8:14am

restoring defaults does not work

Expand content
I've tried to restore defaults for highlight styles. Without [visible] effects.D:\Documents and Settings\mmotyl1\Pictures\Toad\retore defaults.png -- Butter

I've tried to restore defaults for highlight styles. Without [visible] effects.D:\Documents and Settings\mmotyl1\Pictures\Toad\retore defaults.png

--
 Butter

177 1 / Create an account to join the discussion.
yan2
Follow / 31 Jan 2017 at 4:10pm / Toad Data Point Beta Program
Latest post by on 19 Mar 2017 at 2:56am

Multiple database browser tabs + feedback mechanism

Expand content
Is it possible to open multiple DB browsers ? This is useful when building queries to see (on other screens) as you go the content of the underlying tables. A generic logistic question to Quest: where...

Is it possible to open multiple DB browsers ? This is useful when building queries to see (on other screens) as you go the content of the underlying tables.

A generic logistic question to Quest: where should one best post requests or ideas, and is there a voting mechanism to help set roadmap priorities ?

We have no idea if someone's feedback is taken into consideration nor do we know what Quest is up to on user's requests - a status like accepted, not considered or under review would help.  

Answered 261 2 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point_Beta_4.2.0.659 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

144 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point_Beta_4.2.0.603 is now available

Expand content
Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release Notes: dev.toadfordataanalyst...

Installer is available on the TDA Community website:

www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes: 
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

174 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point_Beta_4.2.0.562 is now available

Expand content
Toad Data Point_Beta_4.2.0.562 is now available Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can...

Toad Data Point_Beta_4.2.0.562 is now available

Installer is available on the TDA Community website:
www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

171 0 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 16 Jan 2017 at 9:53pm / Toad Data Point Beta Program
Latest post by on 31 Jan 2017 at 11:23pm

Toad Data Point_Beta_4.2.0.495 is now available

Expand content
Toad Data Point_Beta_4.2.0.495 is now available Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can...

Toad Data Point_Beta_4.2.0.495 is now available

Installer is available on the TDA Community website:
www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

299 4 / Create an account to join the discussion.
Butter
Follow / 31 Jan 2017 at 9:27am / Toad Data Point Beta Program

script error

Expand content
Hi, following script is correct [Oracle SQL Dev runs it without any problem] SET SERVEROUTPUT ON DECLARE l_today_date DATE ; BEGIN l_today_date := Sysdate; DBMS_OUTPUT.put_line (to_char(l_today_date...

Hi, 

following script is correct [Oracle SQL Dev runs it without any problem]

SET SERVEROUTPUT ON
DECLARE
 l_today_date DATE ;
BEGIN
 l_today_date := Sysdate; 
 DBMS_OUTPUT.put_line (to_char(l_today_date,'yyyy-mm-dd hh:mm:ss' )); 
 DBMS_OUTPUT.put_line ('----------------------------------');
END;

But TOAD has a problem with it.

ORA-00922: brakująca lub niepoprawna opcja = missing or incorrect option.
--
 Butter

162 0 / Create an account to join the discussion.
john.burgtorf
Follow / 13 Jan 2017 at 4:50pm / Toad Data Point Beta Program
Latest post by on 25 Jan 2017 at 7:58pm

Automation, Loop dataset error when adding the select to file act...

Expand content
Hi, in TDP 4.1.0.56 I receive an error when adding the select to file activity. The Error is System.Argument OutOfRangeException: Index was out of range. Can you verify a simple automation script works...

Hi, in TDP 4.1.0.56 I receive an error when adding the select to file activity.  The Error is System.Argument OutOfRangeException: Index was out of range.  Can you verify a simple automation script works with the system activity loop database and the database activity of select to file?  Thank You, John

318 6 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 9 Dec 2016 at 9:17pm / Toad Data Point Beta Program
Latest post by on 12 Jan 2017 at 12:02am

Toad Data Point_Beta_4.2.0.408 is now available

Expand content
Toad Data Point_Beta_4.2.0.408 is now available Installer is available on the TDA Community website: www.toadworld.com/.../toad_data_point_beta_program The latest list of fixes and enhancements can...

Toad Data Point_Beta_4.2.0.408 is now available

Installer is available on the TDA Community website:
www.toadworld.com/.../toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:
dev.toadfordataanalyst.com/.../ToadforDataAnalystsRNBeta.htm

TDP Development Team

376 4 / Create an account to join the discussion.
kworsham
Follow / 9 Jan 2017 at 1:25am / Toad Data Point Beta Program
Latest post by on 9 Jan 2017 at 1:21pm

Beta Version Upgrade Merry-go-round

Expand content
When I open Toad Data Point Beta 4.2, I get the message that there is a new version and I'm prompted to go to the website to download the latest version. I then download the newest version from the...

When I open Toad Data Point Beta 4.2, I get the message that there is a new version and I'm prompted to go to the website to download the latest version.  I then download the newest version from the website, installation completes and I select to launch the tool when finished.  However, when the tool launches, I am once again given the message that there is a new version and the process starts all over again.  Help!

347 4 / Create an account to join the discussion.
yan2
Follow / 5 Jan 2017 at 5:20pm / Toad Data Point Beta Program

TDP portable ?

Expand content
Is there any way, plan or 3rd party working solution to make TDP portable ? I like to use my personal pro license on clients' engagements, to do initial data discoveries and mining tasks, without...

Is there any way, plan or 3rd party working solution to make TDP portable ?

I like to use my personal pro license on clients' engagements, to do initial data discoveries and mining tasks, without the need to install the software. 

Most of the time I am not a local admin on the laptop loaner so cannot install TDP if I wanted to. Also, not sure how the license would work if I have 2 installs, even if I am the same named user.    

197 0 / Create an account to join the discussion.
yan2
Follow / 21 Nov 2016 at 11:29pm / Toad Data Point Beta Program
Latest post by on 21 Dec 2016 at 1:12am

4.1.0.56 Crashes on Explain Plan in Editor

Expand content
Explain Plan works well if Editor contains one statement only. If multiple statements exist, "Show estimated plan for current statement" actually returns the plans for ALL statements in the...

Explain Plan works well if Editor contains one statement only.

If multiple statements exist, "Show estimated plan for current statement" actually returns the plans for ALL  statements in the Editor pane, and it even crashes on some queries - see below the error.

Expected result: only the plan of current statement (at cursor position) should be returned - this also may limit occurance if not prevent the error.

NullReferenceException
Object reference not set to an instance of an object.

Stack Trace:
at Quest.Toad.SqlServer.SqlServerPlanConverter.ToPlanXML()
at Quest.Toad.SqlServer.SqlServerExplain.ConvertToQExplainXml()
at Quest.Toad.SqlServer.SqlServerConnection.GenerateExplainPlan(String aSql, String currentSchema, Object[] parameters)
at Quest.Toad.ExplainPlan.ExplainPlanControl.DoInternalExplain(ExplainDocumentInfo explainDocumenttInfo)
at Quest.Toad.ExplainPlan.ExplainPlanControl.DoExplain(ISqlDocument isqlDocument, ExplainDocumentInfo explainDocumenttInfo, Boolean bResetExplainPlanInfo)
at Quest.Toad.ExplainPlan.ExplainPlanControl.DoExplain(Object args)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)

342 4 / Create an account to join the discussion.
kanuchris
Follow / 22 Nov 2016 at 6:53pm / Toad Data Point Beta Program
Latest post by on 20 Dec 2016 at 7:08pm

How do I Remove Duplicates using transform and cleanse

Expand content
I have a challenge trying to deduplicate in the transforn and cleanse process. Couple of question on this:- 1. What is the order of removing duplicates in transform and cleanse. Is it from top top bottom...

I have a challenge trying to deduplicate in the transforn and cleanse process. Couple of question on this:-

1. What is the order of removing duplicates in transform and cleanse. Is it from top top bottom or bottom to top or arbitrarly?

My issue is that I have loan numbers with mulitple records due to activities and task performed on the same loan number over time. I will want to remove the duplicates and keep the record with the most current completed task by date. In excel I will sort by New to Old and de-dupe. This keeps the most current date and removes the duplicates below . How can I achieve same with transform and cleanse feature.

Your help will be appreciated

Chris

397 4 / Create an account to join the discussion.
codewarrior
Follow / 15 Dec 2016 at 10:00am / Toad Data Point Beta Program
Latest post by on 20 Dec 2016 at 2:18pm

Increase SQL command timeout in Toad Data Point import wizard

Expand content
How do i increase the SQL command timeout period in the import wizard? (Wizard times out while trying to get preview results for a complex query)

How do i increase the SQL command timeout period in the import wizard? (Wizard times out while trying to get preview results for a complex query)

Unanswered 396 5 / Create an account to join the discussion.