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.

procedure editor

4 posts in General Discussion Last posting was on 2008-04-11 08:37:10.0Z
Andreas Gerats Posted on 2008-04-10 10:51:29.0Z
Sender: 7786.47f9d975.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: procedure editor
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47fdf131.5705.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Apr 2008 03:51:29 -0700
X-Trace: forums-1-dub 1207824689 10.22.241.41 (10 Apr 2008 03:51:29 -0700)
X-Original-Trace: 10 Apr 2008 03:51:29 -0700, 10.22.241.41
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:671
Article PK: 1088349

Hi,

on doubleclicking on a procedure within Enterprise Explorer
the procedure editor opens (a little database symbol top
left). When I edit this procedure I need to save it to an
ascii text file. Rightclicking in the procedure source code
and pointing to Save as ... leads to the save dialog.

So far so good, but two issues now:
1. The dialog suggests the procedure name as default for
saving to ascii file and not the real physical name of this
ascii file (e.g. p_checkDependencies, which is the procedure
name).

2. When saving has finished, the sql file editor (a little
booklet symbol top left) opens automatically with the
correct physical file name (e.g. c_d_p_checkDependencies) so
that the same procedure is opened in both windows with
different names.
This is confusing. Furthermore there is no automatic update
of the second source code when editing the first one and
vice versa.

Is it possible to use always the physical file name as
default when saving to disk?
Is it really necessary to open a second editor on saving to
disk? Or is there a preference where I can switch this off?

Thx and best regards
Andreas


Samir Nigam Posted on 2008-04-10 22:19:23.0Z
Reply-To: "Samir Nigam" <samir_dot_nigam@sybase.com>
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47fdf131.5705.1681692777@sybase.com>
Subject: Re: procedure editor
Lines: 57
Organization: Sybase, Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47fe926b$1@forums-1-dub>
Date: 10 Apr 2008 15:19:23 -0700
X-Trace: forums-1-dub 1207865963 10.22.241.152 (10 Apr 2008 15:19:23 -0700)
X-Original-Trace: 10 Apr 2008 15:19:23 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:674
Article PK: 1088355

Andreas,

The behavior that you see is by design. We have different editors when you
work directly on stored procedure in database or code that is in file. So
when a stored procedure is saved in a file, we consider that as an event to
save the code and open it in the editor for convienence.

As for the confusion about two editors open, if you put mouse over the title
tab, it should show you which is from database and which is from file.

There is no automatic update between two open editors since the changes are
happening in two separate resources with no knowledge of each other. We
don't want to automatically sync the file behind the scenes for backup and
other reasons.

I will create a CR to investigate if there is way to remember the file where
a particular procedural object (sp, trigger, etc. belonging to a specific
connection profile) was saved previously. Also, will request adding a
preference to enable/disable "file open" after save.

Regards,
Samir

<Andreas Gerats> wrote in message
news:47fdf131.5705.1681692777@sybase.com...
> Hi,
>
> on doubleclicking on a procedure within Enterprise Explorer
> the procedure editor opens (a little database symbol top
> left). When I edit this procedure I need to save it to an
> ascii text file. Rightclicking in the procedure source code
> and pointing to Save as ... leads to the save dialog.
>
> So far so good, but two issues now:
> 1. The dialog suggests the procedure name as default for
> saving to ascii file and not the real physical name of this
> ascii file (e.g. p_checkDependencies, which is the procedure
> name).
>
> 2. When saving has finished, the sql file editor (a little
> booklet symbol top left) opens automatically with the
> correct physical file name (e.g. c_d_p_checkDependencies) so
> that the same procedure is opened in both windows with
> different names.
> This is confusing. Furthermore there is no automatic update
> of the second source code when editing the first one and
> vice versa.
>
> Is it possible to use always the physical file name as
> default when saving to disk?
> Is it really necessary to open a second editor on saving to
> disk? Or is there a preference where I can switch this off?
>
> Thx and best regards
> Andreas


Samir Nigam Posted on 2008-04-10 22:30:17.0Z
Reply-To: "Samir Nigam" <samir_dot_nigam@sybase.com>
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47fdf131.5705.1681692777@sybase.com> <47fe926b$1@forums-1-dub>
Subject: Re: procedure editor
Lines: 64
Organization: Sybase, Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47fe94f9$1@forums-1-dub>
Date: 10 Apr 2008 15:30:17 -0700
X-Trace: forums-1-dub 1207866617 10.22.241.152 (10 Apr 2008 15:30:17 -0700)
X-Original-Trace: 10 Apr 2008 15:30:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:675
Article PK: 1088353

CR is 497357.

"Samir Nigam" <samir_dot_nigam@sybase.com> wrote in message
news:47fe926b$1@forums-1-dub...
> Andreas,
>
> The behavior that you see is by design. We have different editors when you
> work directly on stored procedure in database or code that is in file. So
> when a stored procedure is saved in a file, we consider that as an event
> to save the code and open it in the editor for convienence.
>
> As for the confusion about two editors open, if you put mouse over the
> title tab, it should show you which is from database and which is from
> file.
>
> There is no automatic update between two open editors since the changes
> are happening in two separate resources with no knowledge of each other.
> We don't want to automatically sync the file behind the scenes for backup
> and other reasons.
>
> I will create a CR to investigate if there is way to remember the file
> where a particular procedural object (sp, trigger, etc. belonging to a
> specific connection profile) was saved previously. Also, will request
> adding a preference to enable/disable "file open" after save.
>
> Regards,
> Samir
>
> <Andreas Gerats> wrote in message
> news:47fdf131.5705.1681692777@sybase.com...
>> Hi,
>>
>> on doubleclicking on a procedure within Enterprise Explorer
>> the procedure editor opens (a little database symbol top
>> left). When I edit this procedure I need to save it to an
>> ascii text file. Rightclicking in the procedure source code
>> and pointing to Save as ... leads to the save dialog.
>>
>> So far so good, but two issues now:
>> 1. The dialog suggests the procedure name as default for
>> saving to ascii file and not the real physical name of this
>> ascii file (e.g. p_checkDependencies, which is the procedure
>> name).
>>
>> 2. When saving has finished, the sql file editor (a little
>> booklet symbol top left) opens automatically with the
>> correct physical file name (e.g. c_d_p_checkDependencies) so
>> that the same procedure is opened in both windows with
>> different names.
>> This is confusing. Furthermore there is no automatic update
>> of the second source code when editing the first one and
>> vice versa.
>>
>> Is it possible to use always the physical file name as
>> default when saving to disk?
>> Is it really necessary to open a second editor on saving to
>> disk? Or is there a preference where I can switch this off?
>>
>> Thx and best regards
>> Andreas
>
>