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 29 Nov 2017 at 4:34am

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)
500 4 / Create an account to join the discussion.
david.franks
Follow / 10 Oct 2017 at 8:07pm / Toad Data Point Beta Program
Latest post by on 23 Oct 2017 at 7:13pm

Issue with Data Import Export when file is in use

Expand content
I'm on TDP Beta 4.3.0.510 and this issue is also in version 4.2.1.303: If I use the Data Import Export window to import an Excel file that is already open elsewhere on my screen, Toad takes me to...

I'm on TDP Beta 4.3.0.510 and this issue is also in version 4.2.1.303:

If I use the Data Import Export window to import an Excel file that is already open elsewhere on my screen, Toad takes me to a SharePoint List window in which the Cancel button doesn't work (but the X button does work).

Below is my Data Import Export window:

Below is the error message because the file I selected is already in use:

Below is the next window I get.  It's a problem because (1) I wasn't trying to import a SharePoint List, and (2) the Cancel button doesn't do anything.

I know the fix is to close the Excel file before starting the import, but the SharePoint window seems inappropriate for this situation.

Thanks!

Dave

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

Toad Data Point Beta 4.3.0.702 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

58 0 / Create an account to join the discussion.
Leigh Roy
Follow / 4 Sep 2017 at 12:45am / Toad Data Point Beta Program
Latest post by on 2 Oct 2017 at 8:10pm

Current beta version (4.3.0.291) expired

Expand content
Hi, After installing the latest/current beta version 4.3.0.291 it says that the version has already expired. Kind regards, Leigh

Hi,

After installing the latest/current beta version 4.3.0.291 it says that the version has already expired.

Kind regards,

Leigh 

682 12 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.510 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

126 0 / Create an account to join the discussion.
Mike Triplett
Follow / 26 Jul 2017 at 4:52pm / Toad Data Point Beta Program
Latest post by on 25 Sep 2017 at 5:18pm

Toad Data Point Beta 4.3.0.253 (32 bit) - Job Manager does not wo...

Expand content
I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks. I saw a suggest to upgrade to...

I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks.  

I saw a suggest to upgrade to the Beta to see if it fixes my problem.  I've installed Toad Data Point Beta 4.3.0.253 (32 bit) and that does not fix the error.

This is the error I receive when attempting to "Schedule" a "Automation".

Exception: (1,1306):WnfStateChangeTrigger:

I've also tried changing to Task Scheduler 1.0 and that fails also.

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

Toad Data Point Beta 4.3.0.347 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

154 0 / Create an account to join the discussion.
yan2
Follow / 29 Aug 2017 at 3:10pm / Toad Data Point Beta Program

Google BigQuery

Expand content
Any plan on supporting more cloud-based databases like BigQuery or AWS Athena ? Those have REST APIs and dialect is pretty ANSI standard (for autocomplete).

Any plan on supporting more cloud-based databases  like BigQuery or AWS Athena ? Those have REST APIs and dialect is pretty ANSI standard (for autocomplete).

Unanswered 145 0 / Create an account to join the discussion.
N.B.
Follow / 9 Sep 2016 at 6:58pm / Toad Data Point Beta Program
Latest post by on 29 Aug 2017 at 2:56pm

Toad Data Point Beta 4.0.1.670 - Source Control Options

Expand content
Are there any planned updates to the Source Control Options? Here's the original thread regarding TDP 3.8 - nothing changed in 4.0 or in the first 4.0.1 beta release. If there are no planned updates...

Are there any planned updates to the Source Control Options?  Here's the original thread regarding TDP 3.8 - nothing changed in 4.0 or in the first 4.0.1 beta release.

If there are no planned updates to allow the use of other Version/Source control systems, could the language on the associated dialog(s) at least be updated to not be misleading regarding the available options?  I've got management hounding me over putting everything in TFS because they see the options that would indicate that it's available, yet per the thread above it's not - but explaining that doesn't do any good.

993 3 / Create an account to join the discussion.
Chris Barnett

Issue with Automation variables in TDP Beta

Expand content
Hi, I just upgraded my beta to 4.3.0.291 and I'm hitting an issue with the variable handling. Normally, whenever a new version comes out, variables fluctuate between showing up as quote-encapsulated...

Hi, I just upgraded my beta to 4.3.0.291 and I'm hitting an issue with the variable handling.  Normally, whenever a new version comes out, variables fluctuate between showing up as quote-encapsulated and not.  It normally doesn't affect functionality other than sort order and it's a beta, so no big deal.  This time around it's doing something new.

My automation basically sets a variable (#TODAY#)  which generates today's date in YYYY-MM-DD format as a string.   I then use that variable to name my query export and then in my notification emails, I provide a url with the filename for the day.  It's all pretty simple stuff. 

The export now exports the filename without quote-encapsulating the date portion, which is how I'd prefer it.  However, every other step in automation is still using & looking for the quote-encapsulated version, so parts of the job start failing.  I've tried simple things like the copy file action and my email notification action and they all fail.  

E.G.  I'm generated Filename_2017-08-11.xlsx and the rest of the job is looking for Filename_'2017-08-11'.xlsx ,  even though every step refers to the same #TODAY# variable.   

I've tried rebuilding the variable  as Date('YYYY-MM-DD') and to_char(Current_date(), "YYYY-MM-DD') and both behave the same way.    I've also tried setting it as a DateTime variable, which introduced new issues. 

Is there something I'm missing to get this to behave consistently ?  

Thanks,

Chris

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

Toad Data Point Beta 4.3.0.291 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

102 0 / Create an account to join the discussion.
Chris Barnett
Follow / 11 Jul 2017 at 4:29pm / Toad Data Point Beta Program
Latest post by on 14 Jul 2017 at 8:55pm

Issue with Job Manager/Automations in beta 4.3.0.220

Expand content
When trying to access the Job Manager in 4.3.0.220 (Win7 /32-bit Toad Data Point), the following error triggers: System.MissingMethodException Method not found: 'DevExpress.Utils.ImageCollection...

When trying to access the Job Manager in 4.3.0.220 (Win7 /32-bit Toad Data Point), the following error triggers:

System.MissingMethodException
Method not found: 'DevExpress.Utils.ImageCollection Quest.Toad.Util.Global.get_ImageList()'.
Stack Trace:
at Quest.JobManagement.UI.Plugin.ConcoleToad.LoadServers()
at Quest.JobManagement.UI.Plugin.ConcoleToad.initControls()
at Quest.JobManagement.UI.Plugin.ConcoleToad..ctor()
at Quest.JobManagement.UI.Plugin.Analyst.ConcoleToadAnalyst..ctor()
at Quest.JobManagement.UI.Plugin.PluginForm.CreateMainControl()
at Quest.JobManagement.UI.Plugin.PluginForm.StartAll()
at Quest.JobManagement.UI.Plugin.PluginForm..ctor()
at Quest.JobManagement.UI.Plugin.PluginForm.JustShow(Object sender, ITrl[] trls)

The same thing happens when trying to schedule a new automation.   

Downgrading to the last viable beta works, but that expires on 07/16.  Are there any options for getting around this or do I need to wait for a new beta version to be released?

Thanks,

Chris

Unanswered 345 2 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.253 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

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

Toad Data Point Beta 4.3.0.220 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: http://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:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

201 0 / 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?

277 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

293 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.

315 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 351 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

658 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

334 1 / Create an account to join the discussion.