#11133: CREATE and DROP script is generated for Tables in MS Excel database when we select multiple tables.

VikramPacharne(*) reported 2013-12-23T06:56:08Z · last modified 2013-12-30T18:54:51Z

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Excel
Version	15.0

Aqua Data Studio 15.0.0-dev-56

Build #: 35304

Built on: 2013-Dec-20 07:02:58 AM

O.S. : Windows 8.1(64 bit)

Database: MS Excel

Steps to Reproduce :

1]Go to database tree node of MS Excel.

2]Connect and Expand tree node of MS Excel.

3]Expand Databases tree node.

4]Expand Database(e.g. MSExcel) and Schema tree node.

5]Expand Tables folder.

6]Select multiple Tables, Right Click on it and Select option "Script Object to Window As/New Window As".

7]Click on CREATE/DROP option.

Now you will observe that, CREATE/DROP script is generated.

Since this Database only support Select statement, CREATE and DROP options should be disabled.

All Comments (2) Change History

VikramPacharne(*) 2013-12-24T09:51:48Z

Verified in ADS 15.0.0-dev-57

tariqrahiman 2013-12-30T18:54:51Z

Verified in 15.0.0-dev-59