Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Column name completion

3 posts in General Discussion Last posting was on 2008-02-27 08:58:03.0Z
mpeppler Posted on 2008-02-22 11:46:35.0Z
Sender: 7e7b.47be9ecc.1804289383@sybase.com
From: mpeppler@peppler.org
Newsgroups: sybase.public.workspace.general
Subject: Column name completion
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47beb61a.7ffc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Feb 2008 03:46:35 -0800
X-Trace: forums-1-dub 1203680795 10.22.241.41 (22 Feb 2008 03:46:35 -0800)
X-Original-Trace: 22 Feb 2008 03:46:35 -0800, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:599
Article PK: 1088300

Hi,

In the SQL Editor the column name completion doesn't appear
to work correctly (or at all) in the SELECT clause, in
particular if you use table aliases. The column completion
does work in the WHERE clause, though.

Another tool that I use (SQL Browser) does this correctly
once you've typed the FROM clause, so if you know which
tables you want to select from you simply type SELECT and
then FROM and the table names, then go back to the SELECT
portion and add the columns as necessary.

Just a suggestion :-)

Michael


Samir Nigam Posted on 2008-02-26 18:54:18.0Z
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47beb61a.7ffc.1681692777@sybase.com>
Subject: Re: Column name completion
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47c4605a$1@forums-1-dub>
Date: 26 Feb 2008 10:54:18 -0800
X-Trace: forums-1-dub 1204052058 10.22.241.152 (26 Feb 2008 10:54:18 -0800)
X-Original-Trace: 26 Feb 2008 10:54:18 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:601
Article PK: 1088322

Michael,

This is classical forward referencing and multi-pass parsing related
problem. It is slightly difficult problem to solve considering the parser
will have to implement a full statement lookahead to get aliases used in the
current statement (deal with nested queries, scoping, etc.). Performance of
the parser could be impacted as well which may impact SQL Editor
responsiveness.

Still I have created a bug fix request (492676) to look into this request.

Regards,
Samir

<mpeppler@peppler.org> wrote in message
news:47beb61a.7ffc.1681692777@sybase.com...
> Hi,
>
> In the SQL Editor the column name completion doesn't appear
> to work correctly (or at all) in the SELECT clause, in
> particular if you use table aliases. The column completion
> does work in the WHERE clause, though.
>
> Another tool that I use (SQL Browser) does this correctly
> once you've typed the FROM clause, so if you know which
> tables you want to select from you simply type SELECT and
> then FROM and the table names, then go back to the SELECT
> portion and add the columns as necessary.
>
> Just a suggestion :-)
>
> Michael