× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2013-04-30T17:13:55Z  · last modified 2013-05-03T00:11:49Z

copy group of cells - Paste to Window > Update Body - update statement using incorrect columns, but correct data


Dev
Kin-Hong Wong
kin-hong
QA swissarmyknife(*)
Priority Low
Complexity Unknown
Component Q Analyzer - Grid Results
Version 13.0

This occurs in 12.0 and 13.0 on all platforms 

 

1. select top 15 * from SQL Server 2000 Northwind Orders table and press enter a few times to make some blank lines in the Query Analyzer, then Execute

2. in the Grid Results drag a selection of cells beginning in row 3 with EmployeeID and ending in row 11 with RequiredDate

3. with all of those cells selected, right click on top of this selection and Copy

4. with those cells still selected, right click again and choose "Paste to Window" > "UPDATE Body"

5. take a look at the resulting Update statement that gets pasted in the Query Analyzer.
Notice that the first column it wants to update is OrderID, even though we didn't select that in the Grid.

6.  It looks like the UPDATE is pulling the data from the cells we selected, but it is using the incorrect column names (it wants to use the very first columns of the Results, not the column headers of our selection from the Grid)

 

see attached

 

1 attachment

Issue #8790

Closed
Fixed
Resolved 2013-05-02T20:59:20Z
 
 
Completion
No due date
Fixed Build 32173
No time estimate

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