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.

HTML Datawindow and Stored Procedures

3 posts in General Discussion (old) Last posting was on 2000-02-28 00:40:47.0Z
Warren Dosch Posted on 2000-02-26 02:40:26.0Z
Newsgroups: sybase.public.easerver
From: "Warren Dosch" <wdosch@cableregina.com>
Subject: HTML Datawindow and Stored Procedures
Date: Fri, 25 Feb 2000 20:40:26 -0600
Lines: 11
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: ip160.net247251.cr.sk.ca 24.72.51.160
Message-ID: <347_S1m9zNAg$GA.274@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27759
Article PK: 159116

Does the HTML Datawindow support "Stored Procedure Update"? This was a new
feature in PB 7.

When I use "Stored Procedure Update" my datawindow works fine in
PowerBuilder. When I put it on a Web page and deploy it does not work. It
returns -1 and says something about rolling back the transaction. If I
change the datawindow to use "Update Properties" and specify a table to
update etc... it works fine.


Jim O'Neil [Sybase] Posted on 2000-02-27 02:21:08.0Z
Newsgroups: sybase.public.easerver
Date: Sat, 26 Feb 2000 21:21:08 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: HTML Datawindow and Stored Procedures
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 28
NNTP-Posting-Host: nomad6-48.sybase.com 157.133.176.48
Message-ID: <347_38B88A14.1712183@sybase.com>
References: <347_S1m9zNAg$GA.274@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27729
Article PK: 159088


Warren Dosch wrote:

> Does the HTML Datawindow support "Stored Procedure Update"? This was a new
> feature in PB 7.
>
> When I use "Stored Procedure Update" my datawindow works fine in
> PowerBuilder. When I put it on a Web page and deploy it does not work. It
> returns -1 and says something about rolling back the transaction. If I
> change the datawindow to use "Update Properties" and specify a table to
> update etc... it works fine.

I don't see why this shouldn't work, it's just a PB component doing the
update, so if it's working from 'normal' PB it should work with the Web DW. I
do know there were some issues earlier on with stored procedure update,
though. Can you provide a bit more information about where it's failing, what
database interface you are using, and more specifics on the error messages in
the srv.log. You could also turn on tracing on the Web DW, by setting the
appropriate property on the DataWindow/HTMLGenerator component (I think it's
com.sybase.datawindow.trace=yes).

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Warren Dosch Posted on 2000-02-28 00:40:47.0Z
Newsgroups: sybase.public.easerver
From: "Warren Dosch" <wdosch@cableregina.com>
Subject: Re: HTML Datawindow and Stored Procedures
Date: Sun, 27 Feb 2000 18:40:47 -0600
Lines: 45
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: ip30.net247251.cr.sk.ca 24.72.51.30
Message-ID: <347_iaHIXUYg$GA.202@forums.sybase.com>
References: <347_S1m9zNAg$GA.274@forums.sybase.com> <347_38B88A14.1712183@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27700
Article PK: 159061

Thanks for replying so quickly.
The problem turned out to that I did not specify "Update Properties" for the
datawindow. In the datawindow painter everything works OK without the update
properties as long as you have filled in "Store Procedure Update" window. In
the preview window you can change something and the update works. It does
not work when you deploy it. After reading your message I went back to
confirm what I had done. When I went into the update properties and clicked
on "Allow Updates" the "Table to Update" field was automatically filled in
with "Stored Procedure". I picked the fields to update, hit OK & saved it
and it works.

Jim O'Neil [Sybase] wrote in message <38B88A14.1712183@sybase.com>...
>Warren Dosch wrote:
>
>> Does the HTML Datawindow support "Stored Procedure Update"? This was a
new
>> feature in PB 7.
>>
>> When I use "Stored Procedure Update" my datawindow works fine in
>> PowerBuilder. When I put it on a Web page and deploy it does not work. It
>> returns -1 and says something about rolling back the transaction. If I
>> change the datawindow to use "Update Properties" and specify a table to
>> update etc... it works fine.
>
>I don't see why this shouldn't work, it's just a PB component doing the
>update, so if it's working from 'normal' PB it should work with the Web DW.
I
>do know there were some issues earlier on with stored procedure update,
>though. Can you provide a bit more information about where it's failing,
what
>database interface you are using, and more specifics on the error messages
in
>the srv.log. You could also turn on tracing on the Web DW, by setting the
>appropriate property on the DataWindow/HTMLGenerator component (I think
it's
>com.sybase.datawindow.trace=yes).
>
>--
>Jim O'Neil
>Senior Technical Support Engineer
>Sybase, Inc
>
>