× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
SachinPrakash reported 2012-12-21T18:18:38Z  · aquaclusters.josekibold last modified 2013-01-24T14:11:28Z

Save result set values to a variable


Dev
Fun Fun
funfun
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component App - FluidShell
Version 12.0

We want to provide users the ability to save result set values into fluidshell variables.

Lets take an example:

select col1, col2, col3 from table tableA

I want to save the value of "col1" into var1, "col2" into var2 and "col3" into var3. 

What if the result set returns multiple rows? We will only store the value from the 1st row.

Here's a proposed syntax:

select col1, col2, col3 from table tableA

GO var1=col1 var2=col2 var3=col3

The above is just a proposed syntax. Pls feel free to modify based upon what is a good fit for bash style syntax.

Also, we could optionally let the user specify either column names (as returned in the result set) or column index position

 

Issue #8112

Closed
Fixed
Resolved 2012-12-27T01:27:32Z
 
 
Completion
No due date
Fixed Build trunk/30729, 30742
No time estimate

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