StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Capturing the OUTPUT from an Insert Sproc

RE: Capturing the OUTPUT from an Insert Sproc

StrataFrame Team — Thu, 17 Jan 2008 09:12:04 GMT

[quote]I have to consider just taking the framework out of the equation alltogether and just write the insert code by hand and then reload back.[/quote]

I think that's what you're going to have to do... without some significant changes to the framework, there is no way for us to retrieve only one field of a compound primary key value when that one field is auto-incremented.

Capturing the OUTPUT from an Insert Sproc

Clayton Hoyt — Thu, 17 Jan 2008 09:12:04 GMT

Hi Folks

The insert stored procs created by the DDT return the SCOPE_IDENTITY value. How do I capture this using the .SAVE() method?

Thanks!

Clay

RE: Capturing the OUTPUT from an Insert Sproc

Wil Cantrell — Wed, 16 Jan 2008 18:32:58 GMT

Any advice? I have to consider just taking the framework out of the equation alltogether and just write the insert code by hand and then reload back.

RE: Capturing the OUTPUT from an Insert Sproc

Wil Cantrell — Wed, 09 Jan 2008 13:47:51 GMT

How? What do you write in the stored proc?

Here is a brief example of the stored proc I'm using. Where do I get the value of @AutoIncrementField in my BO if it's not in the mapped field after a Save()?

[codesnippet]ALTER PROCEDURE [x].[myProc]
    @AutoIncrementField INT OUTPUT,
    @foreignkeyfield UNIQUEIDENTIFIER,
    @value1 INT,
@value2 INT
AS
INSERT INTO [X].[myTable]
(
    foreignkeyfield
    value1,
    value2
)
VALUES
(
    @foreignkeyField,
    @value1,
    @value2
)
SET @AutoIncrementField = @@IDENTITY[/codesnippet]

RE: Capturing the OUTPUT from an Insert Sproc

Alagarsamy Rajamannar — Tue, 01 Jan 2008 13:27:48 GMT

Hi,

I had this same issue. But I solved it by using stored procedures, where you can return values through output parameters.

RE: Capturing the OUTPUT from an Insert Sproc

Wil Cantrell — Sun, 30 Dec 2007 17:27:18 GMT

Lets say we have a composite primary key and one of the fields is auto increment, how do we get the value back from SQL? I can not set PrimaryKeyIsAutoIncrementing to true with a composite key.

RE: Capturing the OUTPUT from an Insert Sproc

Trent L. Taylor — Wed, 15 Nov 2006 10:54:56 GMT

Is this a trick question? :D Once saved, the BO will contain this value in each of the rows that were updated in the Primary Key field. This is done automatically (by default) when the PrimaryKeyIsAutoIncrementing property is set to True on a BO.