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 editor

8 posts in General Discussion Last posting was on 2008-03-11 08:23:42.0Z
Andreas Gerats Posted on 2008-03-03 09:30:48.0Z
Sender: 78ed.47cbc26b.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: column editor
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47cbc548.7920.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Mar 2008 01:30:48 -0800
X-Trace: forums-1-dub 1204536648 10.22.241.41 (3 Mar 2008 01:30:48 -0800)
X-Original-Trace: 3 Mar 2008 01:30:48 -0800, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:604
Article PK: 1088238

Hi,

when creating a new table within Workspace the column editor
opens and when I add a new column which is not part of
primary key (editing the name of the column), it is annoying
that the focus switches back to column name, marking the
whole column name on using <TAB>-key. With every keystroke
the column name will be deleted and I have to type column
name again.
I have to type <TAB> twice to set the input focus to the
next editable field.

I am using Workspace version: 2.0.0 Build id: 20070807185618

Andreas


Hung Hsi Posted on 2008-03-05 03:16:50.0Z
From: "Hung Hsi" <hhsi@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47cbc548.7920.1681692777@sybase.com>
Subject: Re: column editor
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ce10a2@forums-1-dub>
Date: 4 Mar 2008 19:16:50 -0800
X-Trace: forums-1-dub 1204687010 10.22.241.152 (4 Mar 2008 19:16:50 -0800)
X-Original-Trace: 4 Mar 2008 19:16:50 -0800, vip152.sybase.com
X-Authenticated-User: wsctp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:607
Article PK: 1088273

Andreas,

To avoid column name ieing deleted with every keystoke, at the beginning you
need to make cell editable by double clicking or pressing any key on the
cell. Then you can press 'TAB' or 'SHIFT TAB' to traverse to the next or
previous cell.

Of course, if the current cell is not editable, pressing any key on the cell
will input the key value into the cell.

Please let me know if you have any problems and thanks a lot for your
feedback!

Regards,

Hung

<Andreas Gerats> wrote in message
news:47cbc548.7920.1681692777@sybase.com...
> Hi,
>
> when creating a new table within Workspace the column editor
> opens and when I add a new column which is not part of
> primary key (editing the name of the column), it is annoying
> that the focus switches back to column name, marking the
> whole column name on using <TAB>-key. With every keystroke
> the column name will be deleted and I have to type column
> name again.
> I have to type <TAB> twice to set the input focus to the
> next editable field.
>
> I am using Workspace version: 2.0.0 Build id: 20070807185618
>
> Andreas


Andreas Gerats Posted on 2008-03-05 16:46:46.0Z
Sender: b1e.47cc3996.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Re: column editor
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47cece76.67ef.1681692777@sybase.com>
References: <47ce10a2@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Mar 2008 08:46:46 -0800
X-Trace: forums-1-dub 1204735606 10.22.241.41 (5 Mar 2008 08:46:46 -0800)
X-Original-Trace: 5 Mar 2008 08:46:46 -0800, 10.22.241.41
Lines: 69
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:610
Article PK: 1088278

Hi Hung,

thank you very much for your reply, but I still receive the
same problem:
First item in the list is the checkbox for primary key
candidate, second the column name. I do not want add this
column to primary key, so I click in column name and edit
this name. After editing the name I will use <TAB> to get to
the next item in the editor (datatype), but the focus
switches for a moment to checkbox for primary key and then
back to column name. Since I am editing quite fast, I expect
the cursor to be in column datatype but it is still in
column name with column name marked and so when I try to
type the datatype, the column name is overwritten.

Furthermore: Is there a possibility to add a nullable column
to an existing table within the editor (without using a
default)? Table has no data in it, so there should be no
problem to add a nullable column to an existing table.
On trying to use a default: I cannot edit a default
manually, I must create a UDT first. To me that seems very
formal and time-consuming.

Workspace "hangs up" and never comes back, when dropping and
recreating a table outside Workspace e.g. in SQL Advantage
and opening table again in Workspace.

Best regards
Andreas

> Andreas,
>
> To avoid column name ieing deleted with every keystoke, at
> the beginning you need to make cell editable by double
> clicking or pressing any key on the cell. Then you can
> press 'TAB' or 'SHIFT TAB' to traverse to the next or
> previous cell.
>
> Of course, if the current cell is not editable, pressing
> any key on the cell will input the key value into the
> cell.
>
> Please let me know if you have any problems and thanks a
> lot for your feedback!
>
> Regards,
>
> Hung
>
> <Andreas Gerats> wrote in message
> news:47cbc548.7920.1681692777@sybase.com...
> > Hi,
> >
> > when creating a new table within Workspace the column
> > editor opens and when I add a new column which is not
> > part of primary key (editing the name of the column), it
> > is annoying that the focus switches back to column name,
> > marking the whole column name on using <TAB>-key. With
> > every keystroke the column name will be deleted and I
> > have to type column name again.
> > I have to type <TAB> twice to set the input focus to the
> > next editable field.
> >
> > I am using Workspace version: 2.0.0 Build id:
> 20070807185618 >
> > Andreas
>
>


Daniel Huang Posted on 2008-03-07 08:32:52.0Z
Reply-To: "Daniel Huang" <lihuang@sybase.com>
From: "Daniel Huang" <lihuang@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47ce10a2@forums-1-dub> <47cece76.67ef.1681692777@sybase.com>
Subject: Re: column editor
Lines: 96
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: <47d0fdb4@forums-1-dub>
Date: 7 Mar 2008 00:32:52 -0800
X-Trace: forums-1-dub 1204878772 10.22.241.152 (7 Mar 2008 00:32:52 -0800)
X-Original-Trace: 7 Mar 2008 00:32:52 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:612
Article PK: 1088276

Hi Andreas,

1. For the first issue, I tried ASE table creation wizard and couldn't
reproduce it. Here is my steps:
a. Open ASE table creation wizard.
b. Input table name.
c. Double click column name and input the value.
d. Press 'TAB' to the next cell. Don't find this issue.
But if I first delete a row, then add a row to input table name and press
'TAB'. This issue will happen. And if you continue to add a row and do the
same steps, you will not come into this issue again. I'm not sure if this is
your case.

2. To add a nullable column, you can check 'Nullable' in column editor of
ASE table creation wizard.

3. I can't reproduce this issue 'Workspace "hangs up" and never comes back'.
I drop and recreate a table in SQL Advantage and open it in WorkSpace. It
works well. Can you give me more details for this issue? Thanks.

Daniel Huang

<Andreas Gerats> wrote in message
news:47cece76.67ef.1681692777@sybase.com...
> Hi Hung,
>
> thank you very much for your reply, but I still receive the
> same problem:
> First item in the list is the checkbox for primary key
> candidate, second the column name. I do not want add this
> column to primary key, so I click in column name and edit
> this name. After editing the name I will use <TAB> to get to
> the next item in the editor (datatype), but the focus
> switches for a moment to checkbox for primary key and then
> back to column name. Since I am editing quite fast, I expect
> the cursor to be in column datatype but it is still in
> column name with column name marked and so when I try to
> type the datatype, the column name is overwritten.
>
> Furthermore: Is there a possibility to add a nullable column
> to an existing table within the editor (without using a
> default)? Table has no data in it, so there should be no
> problem to add a nullable column to an existing table.
> On trying to use a default: I cannot edit a default
> manually, I must create a UDT first. To me that seems very
> formal and time-consuming.
>
> Workspace "hangs up" and never comes back, when dropping and
> recreating a table outside Workspace e.g. in SQL Advantage
> and opening table again in Workspace.
>
> Best regards
> Andreas
>
>
>> Andreas,
>>
>> To avoid column name ieing deleted with every keystoke, at
>> the beginning you need to make cell editable by double
>> clicking or pressing any key on the cell. Then you can
>> press 'TAB' or 'SHIFT TAB' to traverse to the next or
>> previous cell.
>>
>> Of course, if the current cell is not editable, pressing
>> any key on the cell will input the key value into the
>> cell.
>>
>> Please let me know if you have any problems and thanks a
>> lot for your feedback!
>>
>> Regards,
>>
>> Hung
>>
>> <Andreas Gerats> wrote in message
>> news:47cbc548.7920.1681692777@sybase.com...
>> > Hi,
>> >
>> > when creating a new table within Workspace the column
>> > editor opens and when I add a new column which is not
>> > part of primary key (editing the name of the column), it
>> > is annoying that the focus switches back to column name,
>> > marking the whole column name on using <TAB>-key. With
>> > every keystroke the column name will be deleted and I
>> > have to type column name again.
>> > I have to type <TAB> twice to set the input focus to the
>> > next editable field.
>> >
>> > I am using Workspace version: 2.0.0 Build id:
>> 20070807185618 >
>> > Andreas
>>
>>


Andreas Gerats Posted on 2008-03-07 12:41:12.0Z
Sender: 1976.47d13303.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Re: column editor
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47d137e8.19f8.1681692777@sybase.com>
References: <47d0fdb4@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Mar 2008 04:41:12 -0800
X-Trace: forums-1-dub 1204893672 10.22.241.41 (7 Mar 2008 04:41:12 -0800)
X-Original-Trace: 7 Mar 2008 04:41:12 -0800, 10.22.241.41
Lines: 125
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:615
Article PK: 1088280

Hi Daniel,

thanks for your answer which was partially very helpful. I
am not sure if we use the same build of Workspace. At the
moment I use 30 day trial version taken from Download.

1. Open an existing table for adding a column --
double-click in
Column Name -- editing the column name -- using <TAB> --
focus is always set back again to Column Name. Only when I
first check the box for primary key and then editing the
column name, focus switches with <TAB> to the next column
(datatype)

2. On trying to add a not null column to existing table
(without any data in it) I receive the message: 'ALTER TABLE
'dbo.pm_process_inst_config' failed. Default clause is
required in order to add non-NULL column 'testcolumn'.'

3. I tried again with a test table and could not reproduce
problem myself. Maybe there were some issues within our
database server when I received the problem. Sorry for
posting this.

Best regards
Andreas

> Hi Andreas,
>
> 1. For the first issue, I tried ASE table creation wizard
> and couldn't reproduce it. Here is my steps:
> a. Open ASE table creation wizard.
> b. Input table name.
> c. Double click column name and input the value.
> d. Press 'TAB' to the next cell. Don't find this issue.
> But if I first delete a row, then add a row to input table
> name and press 'TAB'. This issue will happen. And if you
> continue to add a row and do the same steps, you will not
> come into this issue again. I'm not sure if this is your
> case.
>
> 2. To add a nullable column, you can check 'Nullable' in
> column editor of ASE table creation wizard.
>
> 3. I can't reproduce this issue 'Workspace "hangs up" and
> never comes back'. I drop and recreate a table in SQL
> Advantage and open it in WorkSpace. It works well. Can
> you give me more details for this issue? Thanks.
>
> Daniel Huang
>
>
> <Andreas Gerats> wrote in message
> news:47cece76.67ef.1681692777@sybase.com...
> > Hi Hung,
> >
> > thank you very much for your reply, but I still receive
> > the same problem:
> > First item in the list is the checkbox for primary key
> > candidate, second the column name. I do not want add
> > this column to primary key, so I click in column name
> > and edit this name. After editing the name I will use
> > <TAB> to get to the next item in the editor (datatype),
> > but the focus switches for a moment to checkbox for
> > primary key and then back to column name. Since I am
> > editing quite fast, I expect the cursor to be in column
> > datatype but it is still in column name with column name
> > marked and so when I try to type the datatype, the
> column name is overwritten. >
> > Furthermore: Is there a possibility to add a nullable
> > column to an existing table within the editor (without
> > using a default)? Table has no data in it, so there
> > should be no problem to add a nullable column to an
> > existing table. On trying to use a default: I cannot
> > edit a default manually, I must create a UDT first. To
> > me that seems very formal and time-consuming.
> >
> > Workspace "hangs up" and never comes back, when dropping
> > and recreating a table outside Workspace e.g. in SQL
> > Advantage and opening table again in Workspace.
> >
> > Best regards
> > Andreas
> >
> >
> >> Andreas,
> >>
> >> To avoid column name ieing deleted with every keystoke,
> at >> the beginning you need to make cell editable by
> double >> clicking or pressing any key on the cell. Then
> you can >> press 'TAB' or 'SHIFT TAB' to traverse to the
> next or >> previous cell.
> >>
> >> Of course, if the current cell is not editable,
> pressing >> any key on the cell will input the key value
> into the >> cell.
> >>
> >> Please let me know if you have any problems and thanks
> a >> lot for your feedback!
> >>
> >> Regards,
> >>
> >> Hung
> >>
> >> <Andreas Gerats> wrote in message
> >> news:47cbc548.7920.1681692777@sybase.com...
> >> > Hi,
> >> >
> >> > when creating a new table within Workspace the column
> >> > editor opens and when I add a new column which is not
> >> > part of primary key (editing the name of the column),
> it >> > is annoying that the focus switches back to column
> name, >> > marking the whole column name on using
> <TAB>-key. With >> > every keystroke the column name will
> be deleted and I >> > have to type column name again.
> >> > I have to type <TAB> twice to set the input focus to
> the >> > next editable field.
> >> >
> >> > I am using Workspace version: 2.0.0 Build id:
> >> 20070807185618 >
> >> > Andreas
> >>
> >>
>
>


Aryeh Silverberg <asilverberg Posted on 2008-03-09 07:54:20.0Z
From: Aryeh Silverberg <asilverberg@silverbergs_dot_com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: column editor
References: <47d0fdb4@forums-1-dub> <47d137e8.19f8.1681692777@sybase.com>
In-Reply-To: <47d137e8.19f8.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47d397ac@forums-1-dub>
Date: 8 Mar 2008 23:54:20 -0800
X-Trace: forums-1-dub 1205049260 10.22.241.152 (8 Mar 2008 23:54:20 -0800)
X-Original-Trace: 8 Mar 2008 23:54:20 -0800, vip152.sybase.com
Lines: 123
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:618
Article PK: 1088284

for number 2 - That is not a workspace issue. You can not add a non
nullable column to a table (empty or otherwise) without specifying a default

Andreas Gerats wrote:
> Hi Daniel,
>
> thanks for your answer which was partially very helpful. I
> am not sure if we use the same build of Workspace. At the
> moment I use 30 day trial version taken from Download.
>
> 1. Open an existing table for adding a column --
> double-click in
> Column Name -- editing the column name -- using <TAB> --
> focus is always set back again to Column Name. Only when I
> first check the box for primary key and then editing the
> column name, focus switches with <TAB> to the next column
> (datatype)
>
> 2. On trying to add a not null column to existing table
> (without any data in it) I receive the message: 'ALTER TABLE
> 'dbo.pm_process_inst_config' failed. Default clause is
> required in order to add non-NULL column 'testcolumn'.'
>
> 3. I tried again with a test table and could not reproduce
> problem myself. Maybe there were some issues within our
> database server when I received the problem. Sorry for
> posting this.
>
> Best regards
> Andreas
>
>> Hi Andreas,
>>
>> 1. For the first issue, I tried ASE table creation wizard
>> and couldn't reproduce it. Here is my steps:
>> a. Open ASE table creation wizard.
>> b. Input table name.
>> c. Double click column name and input the value.
>> d. Press 'TAB' to the next cell. Don't find this issue.
>> But if I first delete a row, then add a row to input table
>> name and press 'TAB'. This issue will happen. And if you
>> continue to add a row and do the same steps, you will not
>> come into this issue again. I'm not sure if this is your
>> case.
>>
>> 2. To add a nullable column, you can check 'Nullable' in
>> column editor of ASE table creation wizard.
>>
>> 3. I can't reproduce this issue 'Workspace "hangs up" and
>> never comes back'. I drop and recreate a table in SQL
>> Advantage and open it in WorkSpace. It works well. Can
>> you give me more details for this issue? Thanks.
>>
>> Daniel Huang
>>
>>
>> <Andreas Gerats> wrote in message
>> news:47cece76.67ef.1681692777@sybase.com...
>>> Hi Hung,
>>>
>>> thank you very much for your reply, but I still receive
>>> the same problem:
>>> First item in the list is the checkbox for primary key
>>> candidate, second the column name. I do not want add
>>> this column to primary key, so I click in column name
>>> and edit this name. After editing the name I will use
>>> <TAB> to get to the next item in the editor (datatype),
>>> but the focus switches for a moment to checkbox for
>>> primary key and then back to column name. Since I am
>>> editing quite fast, I expect the cursor to be in column
>>> datatype but it is still in column name with column name
>>> marked and so when I try to type the datatype, the
>> column name is overwritten. >
>>> Furthermore: Is there a possibility to add a nullable
>>> column to an existing table within the editor (without
>>> using a default)? Table has no data in it, so there
>>> should be no problem to add a nullable column to an
>>> existing table. On trying to use a default: I cannot
>>> edit a default manually, I must create a UDT first. To
>>> me that seems very formal and time-consuming.
>>>
>>> Workspace "hangs up" and never comes back, when dropping
>>> and recreating a table outside Workspace e.g. in SQL
>>> Advantage and opening table again in Workspace.
>>>
>>> Best regards
>>> Andreas
>>>
>>>
>>>> Andreas,
>>>>
>>>> To avoid column name ieing deleted with every keystoke,
>> at >> the beginning you need to make cell editable by
>> double >> clicking or pressing any key on the cell. Then
>> you can >> press 'TAB' or 'SHIFT TAB' to traverse to the
>> next or >> previous cell.
>>>> Of course, if the current cell is not editable,
>> pressing >> any key on the cell will input the key value
>> into the >> cell.
>>>> Please let me know if you have any problems and thanks
>> a >> lot for your feedback!
>>>> Regards,
>>>>
>>>> Hung
>>>>
>>>> <Andreas Gerats> wrote in message
>>>> news:47cbc548.7920.1681692777@sybase.com...
>>>>> Hi,
>>>>>
>>>>> when creating a new table within Workspace the column
>>>>> editor opens and when I add a new column which is not
>>>>> part of primary key (editing the name of the column),
>> it >> > is annoying that the focus switches back to column
>> name, >> > marking the whole column name on using
>> <TAB>-key. With >> > every keystroke the column name will
>> be deleted and I >> > have to type column name again.
>>>>> I have to type <TAB> twice to set the input focus to
>> the >> > next editable field.
>>>>> I am using Workspace version: 2.0.0 Build id:
>>>> 20070807185618 >
>>>>> Andreas
>>>>
>>