StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » I am trying to use GetByPrimaryKey() in my Function but having problems

I am trying to use GetByPrimaryKey() in my Function but having problems

Robert Carl Johnson — Mon, 25 Jun 2007 14:51:03 GMT

Hi all. I have a login form that has a combo box that lists users. When the user selects himself his ID ( a primary key value in the table) is loaded in lnValue and sent to my function GetEmployeeByID. The idea is to get the execute the query and return the one record based on the ID value using the GetByPrimaryKey Method. For some reason no matter what value is sent thru ID the return is always from the first record with a ID value of 1. I have used the debugger to check values of ID to the function and it is 2 that is being sent but when I get back to my form the password in the dataset is from record 1. Clear as mud? In other words I'm asking for record 2 and am getting record 1. So,is my code correct or have I not understood your example of how to use the GetByPrimaryKey? BWT, ID is the primary key for this table.

Regards,

Robert

---CODE FROM MY FORM------
Dim lnValue as Integer
'-- Get the ID from the selected name in the combo box
lnValue = CType(txtFullName.SelectedValue, Integer)

'-- Send the ID to the Function that will get the Password from the DB of the selected user
Me.EmployeeBO1.GetEmpoyeeByID(lnValue)

---CODE FROM MY EMPOYEEBO1-------
Public Function GetEmpoyeeByID(ByVal ID As Integer)

Return Me.GetByPrimaryKey(ID)

End Function

RE: I am trying to use GetByPrimaryKey() in my Function but having problems

Trent L. Taylor — Mon, 25 Jun 2007 14:51:03 GMT

No problem at all :) This is exactly why this forum exists :)

RE: I am trying to use GetByPrimaryKey() in my Function but having problems

Robert Carl Johnson — Mon, 25 Jun 2007 13:49:40 GMT

Rock n' Roll. I'm getting there.. lol.

Thanks guys. I appreciate the patience with a newbie to .Net I spent a lot of years in another language so this stuff is quite new to me but I'm getting my head around it.

Robert

RE: I am trying to use GetByPrimaryKey() in my Function but having problems

Trent L. Taylor — Mon, 25 Jun 2007 13:02:17 GMT

Correct :)

RE: I am trying to use GetByPrimaryKey() in my Function but having problems

Robert Carl Johnson — Mon, 25 Jun 2007 09:28:59 GMT

Ben, thanks for the reply. So to recap, I am going to use your suggested method because I already have a dataset and I want to view another record from it, correct? I would only use GetByPrimaryKey(Pk) when I need to get another dataset.

Regards,

Robert

RE: I am trying to use GetByPrimaryKey() in my Function but having problems

StrataFrame Team — Mon, 25 Jun 2007 09:00:06 GMT

It looks like your problem is that you're using the GetByPrimaryKey() instead of FillByPrimaryKey() within the GetByEmployeeID() method. If the business object is already filled, and you call GetByPrimaryKey(), it won't change anything within the business object... it will just return a new DataTable containing the information you requested rather than filling the business object with the data that you want. So, when you check Me.EmployeeBO1, it's data isn't going to change when you call GetByEmployeeID(). What you want to do is change the GetByEmployeeID() to a Sub and change the "Return Me.GetByPrimaryKey(ID)" to "Me.FillByPrimaryKey(ID)" (there's nothing to return since it takes the requested data and puts it inside the business object.