#11924: Automate -> Introduce Select for Excel comes up with WHERE clause which is not supported | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Tariq Rahiman

tariqrahiman reported 2014-04-22T22:57:33Z · last modified 2014-04-28T18:29:28Z

Automate -> Introduce Select for Excel comes up with WHERE clause which is not supported

Dev	tomconrad
QA	NielsGron

Priority	Minor
Complexity	Unknown

Component	DB - Excel
Version	15.0

Version: 15.0.0-dev-247

Build #: 37464

Build Date: 2014-Apr-22 07:36:33 AM

Automate -> Introduce Select for Excel comes up with WHERE clause which is not supported

1. Open a Query Window to MS Excel connection

2. Go to Automate -> Introduce Select Statement

3. For Excel, since we do not support WHERE clause, can you omit the WHERE

2 attachments

Screen Shot 2014-04-22 at 3.51.49 PM.png

2014-04-22T22:57:33Z

62 KB
Screen Shot 2014-04-22 at 3.51.39 PM.png

2014-04-22T22:57:33Z

27 KB

All Comments (2) Change History

saima alvi

saima.alvi(*) 2014-04-25T08:40:39Z

Select query is generated without where clause

Verified in ADS 15.0.0-dev-251

Tariq Rahiman

tariqrahiman 2014-04-28T18:29:28Z

Verified in 15.0.0-dev-253. Automate -> Introduce SELECT now works fine for Excel

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017