Sql Assistant 13 doesn't allow more than 1 Show Table statement

Tools & Utilities
N/A

Sql Assistant 13 doesn't allow more than 1 Show Table statement

I've had this error ever since I upgraded to 13.0 about a month ago.

I can submit a SHOW TABLE <tablename> in Sql Assistant once, but if the answerset is still displayed and I submit another SHOW TABLE statement I get a 'Key already exists' error.    It doesn't matter if it's the same table or not.  If I close the Answerset window it will allow another SHOW Table.  Anyone else heard of this problem?

this is was it writes to the SQLAError.txt file when it happens...

SQLA Version: 13.11.0.2

Driver Version: ODBC 13.10.00.06

System.ArgumentException: Key already exists

Parameter name: Key

   at Infragistics.Shared.KeyedSubObjectsCollectionBase.ValidateKeyDoesNotExist(String key, IKeyedSubObject ignoreObject)

   at Infragistics.Shared.KeyedSubObjectsCollectionBase.ValidateKeyDoesNotExist(String key)

   at Infragistics.Win.UltraWinTabControl.UltraTabsCollection.Add(String key, String text)

   at Teradata.SQLA.AnswerFrm.AddTab(String title, AnswerType typ, String dsn, String language) in F:\ttu1311_efix_snap\tdcli\qman\sqla\AnswerFrm.vb:line 199

   at Teradata.SQLA.MainFrm.GetNewAnswer(AnswerFrm& form, String formTitle, String tabTitle, AnswerType typ, String dsn, String language) in F:\ttu1311_efix_snap\tdcli\qman\sqla\MainFrm.vb:line 182

   at Teradata.SQLA.RunQry.DisplayResults(DbDataReader rdr, String stmt, Int32& rowCnt) in F:\ttu1311_efix_snap\tdcli\qman\sqla\RunQry.vb:line 455

1 REPLY
Enthusiast

Re: Sql Assistant 13 doesn't allow more than 1 Show Table statement

Yes, I too faced the same issue... but I don't think it is specific to version 13.11 ... like Show table we also have issues with EXPLAIN.

There is an work around for this....

Instead of viewing the answerset in the window, you could Export the result into the file without any issues.