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?

Did you try:

Me.FillByPrimaryKey(User)?

Ben

I think in C## it would be:



this.FillByPrimaryKey(user);

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?

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"

 

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

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:



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

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.

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.

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

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

Have a good one