Something really basic is not working correctly in the StrataFrame code.  When there is only 1 record in a table and that record is deleted using the Delete button on a standard Maintenance Form, an unhandled BusinessLayerException occurs.

Sam Tenney

Hi Ivan,

I am using SQL 2008 Express, but I agree with you that I don't think there could be a problem there.  In Visual Studio when I click on the StrataFrame / Version menu option, all the assemblies show version 1.7.3.1.  Where else can I look for old DLL's?

Sam Tenney

Telonics, Inc.

Try using Windows Explorer and searching from your C:\ by "MicroFour StrataFrame Business.dll"

Were you able to test it on a different environment?

Hi Ivan,

Good News!  By trial and error I have found what seems to be causing the problem.  I am using Visual Studio 2008 and I like to step thru the SF framework code.  When I downloaded and ran the source code file and tried to build the various SF solutions to create the necessary *.PDB files, I was getting build errors.

On 9/4/2010 in post #28428 on this forum you provided instructions on how to modify the SF solution and project files with Notepad to allow Visual Studio 2008 to build correctly.  I followed those instructions and was successful in building the SF solutions.  Since then I have been able to step thru the framework source code with no apparent problems.  So I think the SF DLL files I am actually using are from the source code I downloaded and modified per your instructions.  I think I am not actually using the "normal" SF installation DLL files.  Both the source code file and the installation file that I downloaded were originally dated 8/31/2010.

As a test today I renamed the source code folder so that I would not be using those DLL files.  I ran my sample application and did not receive an exception.  I then downloaded the source code file fresh and ran it.  I then carefully modified the solution and project files per your instructions and then built the solutions.  I ran my sample application again and the exception returned.

I have no idea why this is happening, I just know it is happening.  I'm sure you can figure out why.

Sam Tenney

Well, I will stick to the "good news" part of it all.

Good to know you found a possible issue. Guess you will be fine, since you won't distribute the DLLs in a debug mode, so the users won't face the issue. I will get this on the list to have a look in a near future and see if we can think of what might be. The strange part is that I am also running the DLLs on debug mode, so I compiled the source code too.

Anyway, glad you got it going.

Hi Ivan,

Remember, I am running Visual Studio 2008 not 2010 and I made the changes to the solution and project files that you instructed me to do.  Could those be the differences between my DLL's and yours?

Sam Tenney

I am not sure. I haven't got any machine with VS2008 installed anymore, so I am not able to test this scenario at the moment. Have you tried putting a break point in the BeforeDelete and step through the source code to check it?