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 ...