Re: [Squirrel-sql-users] A bug in Sybase plugin?

[Alexandre P. <Ale...@ei...>]

Thank you!  It works!
--
Alexandre Peshansky
Senior Bioinformatics Analyst, ICTR/RIC
Albert Einstein College of Medicine of Yeshiva University
(718) 430-2440 (Mo, We, Fr)  (718) 920-4885 (Tu & Th)

From: Robert Manning [mailto:rob...@gm...]
Sent: Thursday, March 17, 2011 3:49 PM
To: Alexandre Peshansky
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] A bug in Sybase plugin?

That behavior is configurable (with some caveats).  See this bug report for details:

https://sourceforge.net/tracker/?func=detail&atid=393414&aid=3209074&group_id=28383

Rob
On Thu, Mar 17, 2011 at 12:23 PM, Alexandre Peshansky <Ale...@ei...<mailto:Ale...@ei...>> wrote:
Hi all,
Anyone noticed that in Sybase the result of a query picks up an original column name instead of the alias?
E.g., in a query

SELECT myid, ptptr AS pointer FROM amp_ctrphids

The result (under Results tab) has columns "myid" and "ptptr".  The analogous query in Oracle produces expected results (with column names specified in the query).

Environment: SQuirreL SQL v 3.2.1 on Windows 7 SP1 64 bit.  Sybase diver: jConnect-7_0 class com.sybase.jdbc4.jdbc.SybDataSource from jconn4.jar; Oracle driver oracle.jdbc.OracleDriver from ojdbc5.jar
--
Alexandre Peshansky
Senior Bioinformatics Analyst, ICTR/RIC
Albert Einstein College of Medicine of Yeshiva University
(718) 430-2440<tel:%28718%29%20430-2440> (Mo, We, Fr)  (718) 920-4885<tel:%28718%29%20920-4885> (Tu & Th)




------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users