StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » FillByPrimaryKey problem

FillByPrimaryKey problem

Joseph-Carl Theodat — Tue, 30 Jan 2007 20:41:26 GMT

Hi,

My BO is well configured and the DB ids fine. I want to add a custom fill method :

public void FillAllByID( int user)

{

FillByPrimaryKey(user);

}

I'm having a SqlException saying " Invalid object name .." with the name of the table. The table name is good. Since the framework take care of the connection, am I missing something?

RE: FillByPrimaryKey problem

Trent L. Taylor — Tue, 30 Jan 2007 20:41:26 GMT

Glad you got it going :)

RE: FillByPrimaryKey problem

Joseph-Carl Theodat — Tue, 30 Jan 2007 17:35:32 GMT

I reset my desktop and it work... Anyway.. thanks guys...!!

Have a good one

RE: FillByPrimaryKey problem

Joseph-Carl Theodat — Tue, 30 Jan 2007 17:21:29 GMT

Hi,

I tried before a SQL Fill data table and the same result. I know how to make a basic sql statement and there is somehow there is something wrong ...

What I did:

1- Add BO to the project

2- Use the BO mapper to configure my project and the BO , build ok

3- Rebuild the solution

4- Drop the BO object on my form

5- Tried several times the fill FillDataTable with SQL string (same error)

The thing is that my SF DB in on server A and my testing DB in on server B. Both connection were created with the Connection Wizard. But, the SqlException shows server A eventhough the BO was created with server B. I think the answer comes from there ... Any idea?

Note:

I add 'this' only the guys who replied for my question :D

RE: FillByPrimaryKey problem

Trent L. Taylor — Tue, 30 Jan 2007 16:38:04 GMT

Setting the Debug on is always a good idea when you run into something like this. When you are using the intrinsic methods, there are some assumptions made by the framework. In the case of the FillByPrimaryKey, we assume that a primary key has been defined on the BO, for example.

As a side note, there is really no need to create a method to call the intrinsic method. You can direcly call the FillByPrimaryKey and pass it the PK value. If you are going to create a custom method, then you might go ahead and call the FillDataTable method and see if you are having the same problems.

I recommend using an SQLDbCommand and parameterized queries, but just for testing purposes, you can just pass a SELECT statement as well.

[codesnippet]this.FillDataTable("SELECT * FROM MyTable WHERE MyPk=123");[/codesnippet]

See if you get the same response in this scenario. But definitely go through the debug mode as well so we can see what the problem is that you are running into.

Note: Just as a side note, you do not have to provide the pre-qualifying location in .NET (Me or this). If you call the FillByPrimaryKey method it is the same as calling this.FillByPrimeryKey.

RE: FillByPrimaryKey problem

Greg McGuffey — Tue, 30 Jan 2007 16:06:56 GMT

As you mentioned, this "should" work. Did you turn on SQL debugging to see exactly what SQL was being generated? That often help you the error.

In AppMain.cs (or whatever is the main app file in C#), at the bottom of the SetDataSources() method, add this:

DataBasics.DataSources("").SetDebugOn("c:\Debug.html",True);

For more info, see the last post on this page:

[url]http://forum.strataframe.net/Topic3442-6-2.aspx?Highlight=SetDebugOn[/url]

RE: FillByPrimaryKey problem

Joseph-Carl Theodat — Tue, 30 Jan 2007 14:25:20 GMT

I tried already ...(calling from the code, not BO) ... no success

RE: FillByPrimaryKey problem

Joseph-Carl Theodat — Tue, 30 Jan 2007 14:20:48 GMT

It's a typo mistake ... in my code it's written this.FillByPrimaryKey(user)

I am still having the SqlException "invalid object name with TABLENAME"

RE: FillByPrimaryKey problem

Greg McGuffey — Tue, 30 Jan 2007 13:59:34 GMT

Have you tried to just calling FillByPrimaryKey(user) from code (not in the BO, but from some other code)? Do you get the exception then?

RE: FillByPrimaryKey problem

Greg McGuffey — Tue, 30 Jan 2007 13:57:49 GMT

I think in C## it would be:

this.FillByPrimaryKey(user);

RE: FillByPrimaryKey problem

Ben Kim — Tue, 30 Jan 2007 13:54:58 GMT

Did you try:

Me.FillByPrimaryKey(User)?

Ben