StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Retrieving the new primary key after executing .NewRow and .Save

Retrieving the new primary key after executing .NewRow and .Save

Jeff Pagley — Tue, 14 Jul 2009 07:38:31 GMT

I could not find the answer on the forum or in the SF Help. How do I retrieve the newly created primary key after executing the following code:

  Using job As New PRJTJobsBO
   With job
    .NewRow()
    .job_Customer = "jeff"
    .job_Name = "Jeff's Job"
    If .Save = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then
     Return ...newly created primary key??????
    End If
   End With
  End Using

Thanks,

Jeff

RE: Retrieving the new primary key after executing .NewRow and .Save

Trent L. Taylor — Tue, 14 Jul 2009 07:38:31 GMT

Thanks, Greg! :)

RE: Retrieving the new primary key after executing .NewRow and .Save

Greg McGuffey — Mon, 13 Jul 2009 14:36:25 GMT

Things are often as easy as they seem with SF. When I don't know how to do something, I'll often just try what might work and it often does. Glad that helped.

RE: Retrieving the new primary key after executing .NewRow and .Save

Jeff Pagley — Mon, 13 Jul 2009 07:01:32 GMT

That was it. I thought about that, but for some reason I was thinking when the BO added a record it reset the cursor to the first record in the BO and I needed to do something special to retrieve the new ID.

Thank You,

Jeff

RE: Retrieving the new primary key after executing .NewRow and .Save

Greg McGuffey — Fri, 10 Jul 2009 14:02:47 GMT

Assuming that the PK is auto incremented, you just access its property:

[codesnippet]Using job As New PRJTJobsBO
  With job
    .NewRow()
    .job_Customer = "jeff"
    .job_Name = "Jeff's Job"
    If .Save = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then
      Return .job_ID '-- if job_ID is the BO property that contains the ID
    End If
  End With
End Using [/codesnippet]