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.

update (edit data) WS 2.0 on table with no PK

4 posts in General Discussion Last posting was on 2007-12-14 20:13:00.0Z
Gareth Davies Posted on 2007-12-12 16:42:11.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: update (edit data) WS 2.0 on table with no PK
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
X-Original-NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
Message-ID: <47600f63$1@forums-1-dub>
Date: 12 Dec 2007 08:42:11 -0800
X-Trace: forums-1-dub 1197477731 87.194.125.184 (12 Dec 2007 08:42:11 -0800)
X-Original-Trace: 12 Dec 2007 08:42:11 -0800, 87-194-125-184.bethere.co.uk
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:549
Article PK: 1088232

I've just tried doing an "inline" data update using the "edit data"
feature. My table has no primary key but it does have some unique
indexes defined on it. However, WS2 has ignored those and performed the
update using a seemingly random set of six of the table's columns. The
result is that the update matched 10 rows which could be pretty drastic
in a production system.

Just thought you guys should know.

Gareth


Samir Nigam Posted on 2007-12-12 21:30:22.0Z
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47600f63$1@forums-1-dub>
Subject: Re: update (edit data) WS 2.0 on table with no PK
Lines: 23
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.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: snigamxp.sybase.com
X-Original-NNTP-Posting-Host: snigamxp.sybase.com
Message-ID: <476052ee$1@forums-1-dub>
Date: 12 Dec 2007 13:30:22 -0800
X-Trace: forums-1-dub 1197495022 10.22.85.206 (12 Dec 2007 13:30:22 -0800)
X-Original-Trace: 12 Dec 2007 13:30:22 -0800, snigamxp.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:550
Article PK: 1088227

Gareth,

Thanks for letting us know. Please send me (email address in the post -
replace_dot_ with ".") exact repro steps so we can look into the issue.
Appeciate your time and help.

Regards,
Samir

"Gareth Davies" <gruff@sitemaker.cc> wrote in message
news:47600f63$1@forums-1-dub...
> I've just tried doing an "inline" data update using the "edit data"
> feature. My table has no primary key but it does have some unique indexes
> defined on it. However, WS2 has ignored those and performed the update
> using a seemingly random set of six of the table's columns. The result is
> that the update matched 10 rows which could be pretty drastic in a
> production system.
>
> Just thought you guys should know.
>
> Gareth


Gareth Davies Posted on 2007-12-13 10:47:20.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: update (edit data) WS 2.0 on table with no PK
References: <47600f63$1@forums-1-dub> <476052ee$1@forums-1-dub>
In-Reply-To: <476052ee$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
X-Original-NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
Message-ID: <47610db8@forums-1-dub>
Date: 13 Dec 2007 02:47:20 -0800
X-Trace: forums-1-dub 1197542840 87.194.125.184 (13 Dec 2007 02:47:20 -0800)
X-Original-Trace: 13 Dec 2007 02:47:20 -0800, 87-194-125-184.bethere.co.uk
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:551
Article PK: 1088230

Will do.

BTW, some teething problems aside, I'm really pleased with the product.
It's a big step forward from WS 1.7. You guys have done a great job.

Well done.

G

Samir Nigam wrote:
> Gareth,
>
> Thanks for letting us know. Please send me (email address in the post -
> replace_dot_ with ".") exact repro steps so we can look into the issue.
> Appeciate your time and help.
>
> Regards,
> Samir
>
> "Gareth Davies" <gruff@sitemaker.cc> wrote in message
> news:47600f63$1@forums-1-dub...
>> I've just tried doing an "inline" data update using the "edit data"
>> feature. My table has no primary key but it does have some unique indexes
>> defined on it. However, WS2 has ignored those and performed the update
>> using a seemingly random set of six of the table's columns. The result is
>> that the update matched 10 rows which could be pretty drastic in a
>> production system.
>>
>> Just thought you guys should know.
>>
>> Gareth
>
>


Samir Nigam Posted on 2007-12-14 20:13:00.0Z
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47600f63$1@forums-1-dub> <476052ee$1@forums-1-dub> <47610db8@forums-1-dub>
Subject: Re: update (edit data) WS 2.0 on table with no PK
Lines: 46
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.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: snigamxp.sybase.com
X-Original-NNTP-Posting-Host: snigamxp.sybase.com
Message-ID: <4762e3cc$1@forums-1-dub>
Date: 14 Dec 2007 12:13:00 -0800
X-Trace: forums-1-dub 1197663180 10.22.85.206 (14 Dec 2007 12:13:00 -0800)
X-Original-Trace: 14 Dec 2007 12:13:00 -0800, snigamxp.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:552
Article PK: 1088235

Gareth,

Thanks for your comments. It is very encouraging to hear that and we
certainly hope that more and more customers try out WorkSpace 2.0 and take
advantage of the new features we have added in this release.

We appreciate all your input and feedback.

Regards,
Samir

"Gareth Davies" <gruff@sitemaker.cc> wrote in message
news:47610db8@forums-1-dub...
> Will do.
>
> BTW, some teething problems aside, I'm really pleased with the product.
> It's a big step forward from WS 1.7. You guys have done a great job.
>
> Well done.
>
> G
>
> Samir Nigam wrote:
>> Gareth,
>>
>> Thanks for letting us know. Please send me (email address in the post -
>> replace_dot_ with ".") exact repro steps so we can look into the issue.
>> Appeciate your time and help.
>>
>> Regards,
>> Samir
>>
>> "Gareth Davies" <gruff@sitemaker.cc> wrote in message
>> news:47600f63$1@forums-1-dub...
>>> I've just tried doing an "inline" data update using the "edit data"
>>> feature. My table has no primary key but it does have some unique
>>> indexes defined on it. However, WS2 has ignored those and performed the
>>> update using a seemingly random set of six of the table's columns. The
>>> result is that the update matched 10 rows which could be pretty drastic
>>> in a production system.
>>>
>>> Just thought you guys should know.
>>>
>>> Gareth
>>