Return code of DW update with stored procedure in PB 7

I have a datawindow with stored procedure for UPDATE, DELETE & INSERT.
After I issue dw.update( ) method, I want to check whether it is success or
not. However, the return value is alway 1.

1. Is it the same way in checking the return value for datawindow with /
without stored procedure  ?
2. Is there any other way to check whether the execution of stored procedure
is Ok or not ?





0
Vincent
9/27/2000 3:03:45 AM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

3 Replies
552 Views

Similar Articles

[PageSpeed] 3

What driver are you using?  We had a similar problem with OLEDB.

--
Simon Caldwell
Get Real Systems Ltd
Holtby Manor, Stamford Bridge Road, York, YO19 5LL
Tel 01904 481999 Fax 01904 481666
Visit us at www.getrealsystems.com

Specialists in e-Procurement and supply chain technology


"Vincent Yeung" <vincent@famplan.org.hk> wrote in message
news:NO0CmEDKAHA.286@forums.sybase.com...
> I have a datawindow with stored procedure for UPDATE, DELETE & INSERT.
> After I issue dw.update( ) method, I want to check whether it is success
or
> not. However, the return value is alway 1.
>
> 1. Is it the same way in checking the return value for datawindow with /
> without stored procedure  ?
> 2. Is there any other way to check whether the execution of stored
procedure
> is Ok or not ?
>
>
>
>
>


0
Simon
9/27/2000 9:19:12 AM
I am using "SYC Sybase SQL Server 10.x & 11.x" driver
Do you know how to solve the problem ?

Simon Caldwell <simonDOTcaldwellATgetrealsystemsDOTcom> wrote in message
news:0FY10XGKAHA.251@forums.sybase.com...
> What driver are you using?  We had a similar problem with OLEDB.
>
> --
> Simon Caldwell
> Get Real Systems Ltd
> Holtby Manor, Stamford Bridge Road, York, YO19 5LL
> Tel 01904 481999 Fax 01904 481666
> Visit us at www.getrealsystems.com
>
> Specialists in e-Procurement and supply chain technology
>
>
> "Vincent Yeung" <vincent@famplan.org.hk> wrote in message
> news:NO0CmEDKAHA.286@forums.sybase.com...
> > I have a datawindow with stored procedure for UPDATE, DELETE & INSERT.
> > After I issue dw.update( ) method, I want to check whether it is success
> or
> > not. However, the return value is alway 1.
> >
> > 1. Is it the same way in checking the return value for datawindow with /
> > without stored procedure  ?
> > 2. Is there any other way to check whether the execution of stored
> procedure
> > is Ok or not ?
> >
> >
> >
> >
> >
>
>


0
Vincent
9/28/2000 1:27:08 AM
No, sorry, we're using MS SQL7, so it must be a different problem.
S.

--
Simon Caldwell
Get Real Systems Ltd
Holtby Manor, Stamford Bridge Road, York, YO19 5LL
Tel 01904 481999 Fax 01904 481666
Visit us at www.getrealsystems.com

Specialists in e-Procurement and supply chain technology


"Vincent Yeung" <vincent@famplan.org.hk> wrote in message
news:8GimnzOKAHA.201@forums.sybase.com...
> I am using "SYC Sybase SQL Server 10.x & 11.x" driver
> Do you know how to solve the problem ?
>
> Simon Caldwell <simonDOTcaldwellATgetrealsystemsDOTcom> wrote in message
> news:0FY10XGKAHA.251@forums.sybase.com...
> > What driver are you using?  We had a similar problem with OLEDB.
> >
> > --
> > Simon Caldwell
> > Get Real Systems Ltd
> > Holtby Manor, Stamford Bridge Road, York, YO19 5LL
> > Tel 01904 481999 Fax 01904 481666
> > Visit us at www.getrealsystems.com
> >
> > Specialists in e-Procurement and supply chain technology
> >
> >
> > "Vincent Yeung" <vincent@famplan.org.hk> wrote in message
> > news:NO0CmEDKAHA.286@forums.sybase.com...
> > > I have a datawindow with stored procedure for UPDATE, DELETE & INSERT.
> > > After I issue dw.update( ) method, I want to check whether it is
success
> > or
> > > not. However, the return value is alway 1.
> > >
> > > 1. Is it the same way in checking the return value for datawindow with
/
> > > without stored procedure  ?
> > > 2. Is there any other way to check whether the execution of stored
> > procedure
> > > is Ok or not ?
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>


0
Simon
9/28/2000 9:00:31 AM
Reply:

Similar Artilces:

PB 7 DW with Stored Procedure update
Does a dw based completely on stored procedures (including the update) create Update, Insert and Delete SQL statements based on the stored procedures? Or does it PASS the data to the procedures themselves? There is a bit of a debate going on here about how PB is handling this. We are very soon not going to allow ANY client side SQL calls other than those that execute procedures and functions. If anyone can offer any insight it would be appreciated. On Mon, 3 Jan 2000 14:10:20 -0500, in powersoft.public.powerbuilder.datawindow Joe Cairns <jcairns@nospam.fast.net> wrote...

PB 7 DW Stored Procedure Update Problems
Please help me with this problem. I am using PB 7.0 Build 7021, PFC and MS SQL Server 7. I have an updatable datawindow that I have defined an insert, update, and delete stored procedure through the DW Painter Rows - Stored Procedure Update. The stored procedures are executing fine, inserting, updating and deleting, unless a user defined error condition is encountered in the procedure. In this case, the procedure calls the following RAISERROR statement: RAISERROR( 50001, 1 , 1 , @error_parm1,@error_parm2 ) WITH SETERROR The value of @@error after the raiserror statement is 500...

About Datawindow
Hi, I have created a datawindow from a stored procedure created in MSSQL 7.0. I am passing arguments to the stored procedure. When I retrieve data for the datawindow I pass valid values for the arguments, but the datawindow prompts for the arguments again for the second time then shows the result. When it prompts second time for the arguments if I say cancel it still retrieves the data. This happens in the preview mode as well as through the script. What is going wrong ? Thanks in advance. Sorry Guys , I found the problem. Don't worry about it! LNN wrote in messag...

PB 7.0 DataWindows and MS SQL Server 7.0 Stored Procedures
I'm having some problems with creating a datawindow from a stored procedure. I have migraited a PB 5.0.4 application to PB 7.0 with no difficulties. This app has datawindows that are running off of stored procs. But, when I try to create a new tabular datawindow fromscratch (I also tried this using a stored proc that is being used to power other datawindows) I get the following message: Cannot create DataWindow 'Data-conversion resulted in overflow' If any one knows what I am doing wrong I'd appreciate the help. BTW, I am connecting with the native MS SQL Ser...

PB 7.0 DataWindows and MS SQL Server 7.0 Stored Procedures
I'm having some problems with creating a datawindow from a stored procedure. I have migraited a PB 5.0.4 application to PB 7.0 with no difficulties. This app has datawindows that are running off of stored procs. But, when I try to create a new tabular datawindow fromscratch (I also tried this using a stored proc that is being used to power other datawindows) I get the following message: Cannot create DataWindow 'Data-conversion resulted in overflow' If any one knows what I am doing wrong I'd appreciate the help. BTW, I am connecting with the native MS SQL Serv...

PB 7 Stored Procedures & DW
I create a datawindow using a stored procedure residing on ASE 11.9.2. Now, with PB 7, I am able to insert, update or delete from the database using stored procedures (inside dw), nice. But, if I forget from which stored procedure the datawindow was created, what am I going to do. (We have stored proc dw's migrated from PB 6 and unfortunately no documentation) How can I see the source of the datawindow (the stored procedure) ? Thank you in advance... Make sure that you have the Column Specifications view enabled. Then right-click on it and you'll see Stored Procedure....

PB 7 and Stored Procedure Update problem
Hi How to configure stored procedure update in PB 7? Look under Rows | Stored Procedures Update in the menu. For each type of update (update, insert, delete) you can specify the stored proc to use and how to use the column values in the dw. To actually perform the update, just call dw.Update(). HTH, steve [TeamSybase] Marcin Wasikowski wrote: > > Hi > How to configure stored procedure update in PB 7? ...

Stored Procedure Update in PB 7.x
Hi, I am using stored procedure for update,delete and insert. I am binding the stored procedure with the datawindow itself. In the stored procedure I am returning the code which is auto generated after update. I am using in/out parameter for the code. Passing the column name as in parameter. Now the problem is I want to get this value after successful updation. How to achieve this? TIA You can't if you are using dw.Update() because the function swallows all that stuff. You would have to bypass using dw.Update() and code the stored proc calls yourself. ...

PB 7.0.1 Datawindow and Stored Procedure
I trying to use stored procedures in a datawindow with MS SQL 7.0 1. Once I create the datawindow I cannot go back to the datasource and edit the parameters. How do you modify this? 2. Using Stored procedures to Update/Insert/Delete the Update procedure field names become corrupted. Does PB 7.0.2 fix these problems. Is 7.0.2 a EBF or a maintenance release? Can I donwload it? ...

Return values from DW Update's Stored procedures
Hi, I have problem with the DW Update's Stored procedures. Following, description of the situation. A DW must have one row (free form presentation) for the user, but the record in the database may not exists. When the user clear one of the required columns the record must be deleted instead of updated. Following, one scenario : => DW.retrieve() => 1 Row from DB => User set the required colomn to NULL => DW.update() ==> execute DW Update stored procedure => the Update stored procedure test the required colomn and DELETE the record instead of UPDATING =&...

PB 7.0 & Stored Procedure as DataWindow Source
I have tried to set the StripParmNames parameter to true, as was suggested, but that didn't work. I also tried to set the following at the top of the proc: SET ANSI_WARNINGS OFF SET NOCOUNT ON I saw a similar issue in this group so I tried it, but this did not work either. I mistakenly posted this on the powerbuilder.easerver newsgroup and was asked to post the issue here. I have an application that uses a stored procedure as its datasourse. I am using PowerBuilder 7.0 Enterprise, going against SQL Server 7.0. The error I keep getting is: "Select E...

Return values from DW Update's Stored procedures
Environment : PB 8.0.1 9066 MSSQL 6.5 (Native driver) I have a datawindow with Update stored procedures (Insert and Update). When the DW perform an UPDATE, the SP may perform DELETE statement if a specific colomn is null. I'm using input/ouput parameters to update the others columns to NULL. The problem is : for edit (varchar) column nothing change for dddw (long) column a number appears in the colomn (that is not a Database ID because it is too big) <snip> /* Model of Update SP */ CREATE PROCEDURE DW_nameofdw_U @PKID_ORIGIN integer , -- Original PKID ...

PB 7.0 & Stored Procedure as DataWindow Source
I have an application taht needs to use a stored procedure as its datasourse. I am using PowerBuilder 7.0 Enterprise, going against SQL Server 7.0. The error I keep getting is "Select Error: SQLSTATE = 22005 [Microsoft][ODBC SQL Server Driver] Invalid character value for cast specification" The stored Proc is as follows: CREATE procedure sp_co_efresh( @last_efresh_dt datetime, @inlist varchar(250) ) as begin tran EXEC(' select c_in, c_name, c_title, c_website, c_address_1, ...

PB7 & MSSQ 7 DataWindow Update, Insert with Stored Procedures
Every time I try to Update or insert a row with DataWindow Stored Procedures I get the following message: Row changed between retrieve and update No changes made to database execute dbo.sp_insert What am i doing wrong? HELP!! Thanks Adrian ...

Web resources about - Return code of DW update with stored procedure in PB 7 - sybase.powerbuilder.datawindow

Invasiveness of surgical procedures - Wikipedia, the free encyclopedia
There are three main categories which describe the invasiveness of surgical procedures . These are: non-invasive procedures , minimally invasive ...

Procedure is more a snap than a snip
A QUEENSLAND doctor is bidding to set an unusual world record by performing the highest number of vasectomies in one day, with the help of fellow ...

Will Paul Ryan Make His Mark As Speaker By Instituting Impeachment Procedures Against President Obama ...
Wisconsin Ayn Rand devotee Paul Ryan just started his new job as Speaker of the dysfunctional House Republicans. And he's already headed for ...

Are patients charged drastically different prices for the same medical procedure? - Videos - CBS News ...
Patients are often charged drastically different prices for the same medical procedures and research may link later bedtimes with gaining weight. ...

Vin Scully To Miss Dodgers Postseason After Medical Procedure
... , who has been calling Dodgers games since the Truman administration, will miss the team’s playoff run as he recovers from a medical procedure. ...

FDA finds flaws in Theranos' nanotainers and quality control procedures
... to Theranos' blood testing technology comes from the US Food and Drug Administration, which found flaws in the company's quality control procedures. ...

'Daily Show' Host Trevor Noah Hospitalized for Emergency Procedure
'Daily Show' Host Trevor Noah Hospitalized for Emergency Procedure

Hall Of Fame Broadcaster Vin Scully Has Medical Procedure, Will Miss All Of 2015 Postseason
While the Dodgers will be in the 2015 MLB postseason, their Hall of Fame broadcaster, won't. Here's details on Vin Scully.

US AIRPORT SECURITY CONCERNS DHS to heighten procedures in light of Russian jet bombing theory, poor ...
US AIRPORT SECURITY CONCERNS DHS to heighten procedures in light of Russian jet bombing theory, poor test performances by TSA screeners

Concession: Ryan promises Freedom Caucus he’ll delay discussion of reforming procedure for removing the ...
Compromise. Like I said this morning, it sounds like they did a little horse-trading at their summit. Ryan wants them to give up their right ...

Resources last updated: 12/1/2015 4:30:11 AM