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.

Preferences and editing source files

7 posts in General Discussion Last posting was on 2008-05-13 08:25:04.0Z
Andreas Gerats Posted on 2008-05-08 12:51:11.0Z
Sender: 64f2.4822bdc7.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Preferences and editing source files
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4822f73f.6faf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 May 2008 05:51:11 -0700
X-Trace: forums-1-dub 1210251071 10.22.241.41 (8 May 2008 05:51:11 -0700)
X-Original-Trace: 8 May 2008 05:51:11 -0700, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:696
Article PK: 1088376

Hi,

is there a preference to define the format for saving *.sql
files to hard disk? (e.g. Unix or DOS format) After saving I
have to explicitly transfer them from DOS to UNIX format at
the moment which is time-consuming and error-prone since you
can easily forget about this step and source code with
notorious ^M is not runnable under Unix resp. isql under
Unix.

Second question: is it possible to set correct indentation
when editing a source file? If you use smart insert mode and
type 'begin' <Enter>, the 'end' statement is generated and
cursor position has the correct indentation (one indent more
than the 'begin' statement). But if you are typing other
source code and hit <Enter>, cursor position is always at
the beginning of the new line with no dependency to
indentation of the last line.
At least I guess I am not the only one who would prefer to
set the same indentation to a new line as indentation was in
the last line typed.
As far as I can see at the moment this is true to all
editors within WorkSpace.

Thanks and best regards
Andreas


Michael Peppler Posted on 2008-05-09 05:28:23.0Z
From: Michael Peppler <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Preferences and editing source files
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2008.05.09.05.28.22.645668@peppler.org>
Newsgroups: sybase.public.workspace.general
References: <4822f73f.6faf.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 8 May 2008 22:28:23 -0700
X-Trace: forums-1-dub 1210310903 10.22.241.152 (8 May 2008 22:28:23 -0700)
X-Original-Trace: 8 May 2008 22:28:23 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:697
Article PK: 1088373


On Thu, 08 May 2008 06:51:11 -0700, wrote:

> Hi,
>
> is there a preference to define the format for saving *.sql
> files to hard disk? (e.g. Unix or DOS format) After saving I
> have to explicitly transfer them from DOS to UNIX format at
> the moment which is time-consuming and error-prone since you
> can easily forget about this step and source code with
> notorious ^M is not runnable under Unix resp. isql under
> Unix.

Under the File menu there is an option to change the line delimiters -
that might do what you want.

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html


Andreas Gerats Posted on 2008-05-09 08:17:21.0Z
Sender: 3d50.48240550.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Re: Preferences and editing source files
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48240891.3d98.1681692777@sybase.com>
References: <pan.2008.05.09.05.28.22.645668@peppler.org>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 May 2008 01:17:21 -0700
X-Trace: forums-1-dub 1210321041 10.22.241.41 (9 May 2008 01:17:21 -0700)
X-Original-Trace: 9 May 2008 01:17:21 -0700, 10.22.241.41
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:700
Article PK: 1088378

Hi Michael,

thanks for this hint. That seems to be the correct
preference to transfer source code to Unix format (<File>
<Convert Line Delimiters To>).
But it looks like as if it is a setting only for the recent
file, since it is found under the <File> menu.

Maybe it will be more feasible as a general setting?

Thanks and best regards
Andreas

> On Thu, 08 May 2008 06:51:11 -0700, wrote:
>
> > Hi,
> >
> > is there a preference to define the format for saving
> > *.sql files to hard disk? (e.g. Unix or DOS format)
> > After saving I have to explicitly transfer them from DOS
> > to UNIX format at the moment which is time-consuming and
> > error-prone since you can easily forget about this step
> > and source code with notorious ^M is not runnable under
> > Unix resp. isql under Unix.
>
> Under the File menu there is an option to change the line
> delimiters - that might do what you want.
>
> Michael
> --
> Michael Peppler - Peppler
> Consulting SaRL mpeppler@peppler.org -
> http://www.peppler.org Sybase DBA/Developer -
> TeamSybase: http://www.teamsybase.com Sybase on Linux FAQ
> - http://www.peppler.org/FAQ/linux.html
>


mpeppler Posted on 2008-05-09 07:22:30.0Z
Sender: 3c6f.4823fa03.1804289383@sybase.com
From: mpeppler@peppler.org
Newsgroups: sybase.public.workspace.general
Subject: Re: Preferences and editing source files
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4823fbb5.3c96.1681692777@sybase.com>
References: <4822f73f.6faf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 May 2008 00:22:30 -0700
X-Trace: forums-1-dub 1210317750 10.22.241.41 (9 May 2008 00:22:30 -0700)
X-Original-Trace: 9 May 2008 00:22:30 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:699
Article PK: 1088374


> Second question: is it possible to set correct indentation
> when editing a source file? If you use smart insert mode
> and type 'begin' <Enter>, the 'end' statement is generated
> and cursor position has the correct indentation (one
> indent more than the 'begin' statement). But if you are
> typing other source code and hit <Enter>, cursor position
> is always at the beginning of the new line with no
> dependency to indentation of the last line.

Agreed.

One thing that other Eclipse editors have that I think is
missing in the SQL Editor is the ability to shift a block of
code left/right.

Michael


Andreas Gerats Posted on 2008-05-09 08:21:24.0Z
Sender: 3d50.48240550.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Re: Preferences and editing source files
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48240984.3da8.1681692777@sybase.com>
References: <4823fbb5.3c96.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 May 2008 01:21:24 -0700
X-Trace: forums-1-dub 1210321284 10.22.241.41 (9 May 2008 01:21:24 -0700)
X-Original-Trace: 9 May 2008 01:21:24 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:701
Article PK: 1088381

You're right, Michael. That would be very convenient too.
Sometimes my associates are asking me about that funny video
game I am playing when in fact I have to indent e.g. 30
lines of source code separately :-)

> > Second question: is it possible to set correct
> > indentation when editing a source file? If you use smart
> > insert mode and type 'begin' <Enter>, the 'end'
> > statement is generated and cursor position has the
> > correct indentation (one indent more than the 'begin'
> > statement). But if you are typing other source code and
> > hit <Enter>, cursor position is always at the beginning
> > of the new line with no dependency to indentation of the
> last line.
>
> Agreed.
>
> One thing that other Eclipse editors have that I think is
> missing in the SQL Editor is the ability to shift a block
> of code left/right.
>
> Michael


Daniel Huang Posted on 2008-05-13 01:18:02.0Z
Reply-To: "Daniel Huang" <lihuang@sybase.com>
From: "Daniel Huang" <lihuang@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <4823fbb5.3c96.1681692777@sybase.com> <48240984.3da8.1681692777@sybase.com>
Subject: Re: Preferences and editing source files
Lines: 52
Organization: Sybase
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.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4828ec4a@forums-1-dub>
Date: 12 May 2008 18:18:02 -0700
X-Trace: forums-1-dub 1210641482 10.22.241.152 (12 May 2008 18:18:02 -0700)
X-Original-Trace: 12 May 2008 18:18:02 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:702
Article PK: 1088379

Hi, Andreas:

Thank you for your feedbacks!

The first question was answered by Micheal Peppler. And if you want to make
line delimiter as the general setting, go to Window --> Preferences -->
General --> WorkSpace and change the setting in the group 'New text file
line delimiter'.

CR523700 was created for the second question. We will consider to support it
in the next release.


--
Thanks and regards,

Daniel Huang

Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Email: lihuang@sybase.com

<Andreas Gerats> wrote in message
news:48240984.3da8.1681692777@sybase.com...
> You're right, Michael. That would be very convenient too.
> Sometimes my associates are asking me about that funny video
> game I am playing when in fact I have to indent e.g. 30
> lines of source code separately :-)
>
>> > Second question: is it possible to set correct
>> > indentation when editing a source file? If you use smart
>> > insert mode and type 'begin' <Enter>, the 'end'
>> > statement is generated and cursor position has the
>> > correct indentation (one indent more than the 'begin'
>> > statement). But if you are typing other source code and
>> > hit <Enter>, cursor position is always at the beginning
>> > of the new line with no dependency to indentation of the
>> last line.
>>
>> Agreed.
>>
>> One thing that other Eclipse editors have that I think is
>> missing in the SQL Editor is the ability to shift a block
>> of code left/right.
>>
>> Michael


Andreas Gerats Posted on 2008-05-13 08:25:04.0Z
Sender: 7fbc.48294ced.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Re: Preferences and editing source files
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48295060.147.1681692777@sybase.com>
References: <4828ec4a@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 May 2008 01:25:04 -0700
X-Trace: forums-1-dub 1210667104 10.22.241.41 (13 May 2008 01:25:04 -0700)
X-Original-Trace: 13 May 2008 01:25:04 -0700, 10.22.241.41
Lines: 64
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:703
Article PK: 1088380

Hi Daniel,

thanks a lot for your hint to the first point. That helps me
a lot to save time and discard one potential error source
and saving time will be also a fact for the second issue
once implemented.

Best regards
Andreas

> Hi, Andreas:
>
> Thank you for your feedbacks!
>
> The first question was answered by Micheal Peppler. And if
> you want to make line delimiter as the general setting,
> go to Window --> Preferences --> General --> WorkSpace
> and change the setting in the group 'New text file line
> delimiter'.
>
> CR523700 was created for the second question. We will
> consider to support it in the next release.
>
>
> --
> Thanks and regards,
>
> Daniel Huang
>
> Sybase Software (China) Co., Ltd
> Room 1202-1203, Building One,
> Zhangjiang Semiconductor Industry Park
> 3000 Longdong Avenue
> Pudong, Shanghai 201203
> Email: lihuang@sybase.com
>
>
> <Andreas Gerats> wrote in message
> news:48240984.3da8.1681692777@sybase.com...
> > You're right, Michael. That would be very convenient
> > too. Sometimes my associates are asking me about that
> > funny video game I am playing when in fact I have to
> > indent e.g. 30 lines of source code separately :-)
> >
> >> > Second question: is it possible to set correct
> >> > indentation when editing a source file? If you use
> smart >> > insert mode and type 'begin' <Enter>, the 'end'
> >> > statement is generated and cursor position has the
> >> > correct indentation (one indent more than the 'begin'
> >> > statement). But if you are typing other source code
> and >> > hit <Enter>, cursor position is always at the
> beginning >> > of the new line with no dependency to
> indentation of the >> last line.
> >>
> >> Agreed.
> >>
> >> One thing that other Eclipse editors have that I think
> is >> missing in the SQL Editor is the ability to shift a
> block >> of code left/right.
> >>
> >> Michael
>
>