StrataFrame Forum / StrataFrame Application Framework / Issues

URGENT: Cannot activate license

Greg McGuffey — Wed, 07 May 2008 15:55:53 GMT

I'm attempting to install and activate SF on terminal server (windows 2003). The program bombs immediately. I deactivated my license(s) before attempting this (my dev machine and my backup dev machine both took a dive). See attached error dialog...

Designer error on a form

Edhy Rijo — Tue, 06 May 2008 14:54:02 GMT

Hi,

I have a form which works fine but after debugging the application, when returning back to VS2008 IDE if this form was open, I will not be able to view the designer controls in the form and get the error attached in the image.

By closing the form and openig it again, I am able to keep working in this form. This does not happens with my other forms and I am affraid the form may get corrupted and loose it.

Is there anything I can do?

edit a varchar(max) value give me a "String or binary data would be truncated" error

Fabian R Silva, - — Mon, 05 May 2008 16:07:08 GMT

I have a "Valor" field (varchar(max)) on a "configuraciones" table, I can save the first time some data, but when I try to edit this same data (I find it with a seek and then edit the data and save it), I get an error "String or binary data would be truncated"

I try to alter this with a empty "" string and save it and it give me error anyway

I set debugon on the datasource and I see this:

[Deleted print out --- killed the page :)]

I not sure if this are a bug, I save some new data (aprox 30000 bytes, with a base64 string from a memorystream of a devexpress grid savelayout method), edit this with some value and the "truncate" error happen :/

I will try with a text field and a fixed varchar value (something like 50000)

Additionally to this when I used the method "SetDebugOn" on my datasource with the 2nd parameter on true (overwritefile) If the file not exist it give me an error. (I not sure if the method have to create the file if it not exist)

Thanks for the great support.

-Fabian

Installation Error for the lastest beta version?

Michael Reese — Thu, 01 May 2008 17:04:04 GMT

I am getting an error installing the latest version. It seems that the first installation failed with an Add-In-manager error similar the the "80070002" experienced by someone else. Then I tried to reinstall the version and got a .Net Framework Installation Utility error with the following error

EventType : clr20r3 P1 : installutil.exe P2 : 2.0.50727.1433
P3 : 471ebfbb P4 : mscorlib P5 : 2.0.0.0 P6 : 471ebc5b P7 : 1295
P8 : 14 P9 : system.io.filenotfoundexception

Everthing is stuck now?

Visual Studio 2005 does not start

Denis Gavrkov — Sun, 04 May 2008 08:43:02 GMT

Hi,

I have a problem, I install StartFrame (Try it) and after that my Visual Studio 2005 does not start any more.. splash screen appears with VS2005 Professiona edition and process hang ... what can I do?

Thanks

Denis

Errors populating combo boxes using the PopulationDataSourceSettings/PopulationType properties

jjp — Thu, 01 May 2008 11:04:16 GMT

Hi Strataframe Team,

I made some simple changes to some forms and I rebuilt a new exe and redistribute it to the clients machines. The application runs fine on my development machine. But when I try to run it on the client machines it gives me the errors below. From what I can tell through additional testing, the errors are occuring for ALL combo boxes I am populating using the BO with the PopulationDataSourceSettings/PopulationType properties. What is really strange is all of these forms and combo boxes and BOs have been working fine for a long time!?!? Help?

====================================================================================================================================================
Type 'CMPR.LocationsViewBO' could not be found in the referenced assemblies.
Exception (Exception): Source="MicroFour StrataFrame Base"; Target=null; Tag=null;
Message = "Type 'CMPR.LocationsViewBO' could not be found in the referenced assemblies."
InnerException (FileNotFoundException): Source="mscorlib"; Target=null; Tag=null;
Message = "Could not load file or assembly 'DevExpress.XtraReports.v8.1, Version=8.1.1.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1' or one of its dependencies. The system cannot find the file specified."
StackTrace =
" at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(AssemblyName assemblyRef)
at MicroFour.StrataFrame.Tools.Common.GetTypeFromReferencedAssemblies(String TypeName)"
FileName = "DevExpress.XtraReports.v8.1, Version=8.1.1.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1"
FusionLog =
"WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
"
Environment: ThreadIdentity="" DateTime=["2008-05-01 11:41:17.099"] ThreadName=null WindowsIdentity="STRUSS\JPagley" ThreadId="1" DomainName="cmpr.exe" OSVersion=["Microsoft Windows NT 5.0.2195 Service Pack 4"] MachineName="INVENTORY"
UserName="JPagley"
Remaining Stack Trace - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
at MicroFour.StrataFrame.Tools.Common.GetTypeFromReferencedAssemblies(String TypeName)
at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateComboFromBusinessObject(IListControl lstControl, Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateCombo(Control lstControl, Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.PopulateCombo(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.Requery()
at MicroFour.StrataFrame.UI.Windows.Forms.DevEx.ComboBoxEdit.InitializeObject()
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.InitializeFormLoadObjects()
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Error occur when pressing delete key to clear the date value of the datetimepicker control

jjp — Tue, 29 Apr 2008 15:47:17 GMT

Hi Strataframe Team,

After I upgraded to the 1.6.5, I get the error below when I press the delete key to clear the date value of the datetimepicker control which is bound to a date field of a business object. Although I get this error, the database is being updated properly. Why is this error is occurring?

=======================================================================

Object reference not set to an instance of an object.
Exception (NullReferenceException): Source="MicroFour StrataFrame UI"; Target=null; Tag=null;
Message = "Object reference not set to an instance of an object."
Environment: ThreadIdentity="" DateTime=["2008-04-29 16:31:15.908"] ThreadName=null WindowsIdentity="STRUSS\JPagley" ThreadId="10" DomainName="CMPR.vshost.exe" OSVersion=["Microsoft Windows NT 5.1.2600 Service Pack 2"] MachineName="1LPJPAGLEY"
UserName="JPagley"
Remaining Stack Trace - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
at MicroFour.StrataFrame.UI.Windows.Forms.DateTimePicker.CreateManualCaret()
at MicroFour.StrataFrame.UI.Windows.Forms.DateTimePicker.OnGotFocus(EventArgs e)
at System.Windows.Forms.Control.WmSetFocus(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.DateTimePicker.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Migrating SF Projects

Jason Seidell — Tue, 29 Apr 2008 15:56:26 GMT

I need to know how to migrate SF data from one database to another on a project level. I know I can backup the database and restore on another machine, but I want to be able to selectively copy projects from one machine to another for two reasons.

First, another developer and I both started using SF and just setup local DBs, and as I've learned this causes some problems when trying update each other's projects, and with two more developers soon joining the picture the idea of four different DB's that projects are tied to, and trying to manage permissions and apply SF updates unilaterally seems like too much work. So I want to merge all our SF projects into one SF DB.

Secondly, I would like to be able to copy the source code and the project DB files to a jump drive and work on code from home without having to VPN into work to get to the SF DB, and then when I'm done import the changes back into the work SF DB.

Maybe this has been explained somewhere else and I've just missed it. I've looked through the tables and it seems to complex for me to just blindly stab at trying to write an import/export program.

Any help is greatly appreciated.

PS. This post really applies to all the SF products, application framework, DDT, and role based security. Should this maybe placed in requested features forum instead??

Thanks,
Jason Seidell

Bug in FillByParent()

fparker — Thu, 01 Mar 2007 15:08:07 GMT

If a business object calls its FillByParent() method and the parent's CurrentView contains no rows, the SQL statement that is built will not be properly formatted and a SQLException will be thrown ("incorrect syntax..."). If the parent business object's CurrentDataTable has at least one row, the problem can be worked around by blanking out the RowFilter property of the parent's CurrentView before calling FillByParent() and then reestablishing it after FillByParent() completes. If you have any questions, let me know.

Have trashed my 1.66 install and need to reinstall clean

Charles R Hankey — Sat, 26 Apr 2008 17:26:45 GMT

Hi guys –

I did a baaad thing. Decided to unpack the source code just to see what was under the hood.

Opened the project in VS 2008 - very interesting. I may have hit build at some point early in – though I don’t believe I had changed anything.

Close VS

Now any attempt to open VS blows up as it tries to load SF .:crying:

Tried reinstalling 1.66 twice. Modify and repair. Didn’t get any errors until I say yes to open samples console after install

FileNotFoundException

Could not load file or assembly 'MicroFour StrataFrame Business, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7' or one of its dependencies. The system cannot find the file specified.

[codesnippet] Source : SFSampleConsole
Stack Trace:
at SFSampleConsole.AppMain.InitApplication(InitializingApplicationEventArgs e)
at MicroFour.StrataFrame.Application.StrataFrameApplication.Raise_InitializingApplication(InitializingApplicationEventArgs e)
at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()
at SFSampleConsole.AppMain.Main()
[/codesnippet]

Completely uninstall and reinstalled – same error

Obviously I made it mad and somehow trashed the business assembly and it is not being overwritten on a reinstall.

Guidance for this .NET idiot greatly appreciated

See you in Amarillo this summer – hope to be slightly less clueless by then – and a *lot* less clueless afterward …

Charles

Error working with Business Object Mapper

Rainer Kempf, RK — Fri, 25 Apr 2008 05:02:31 GMT

Hi i have following Problem :

I create new Project

and add new item (BusinessObject) to Project

Then go to menu Strataframe

there i call there Businessobject Mapper

and then allways get this error :

SqlException
Ungültiger Objektname 'DTEprojects'.

Source : .Net SqlClient Data Provider

Stack Trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)
at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)
at MicroFour.StrataFrame.AddIns.DTEprojectsBO.FillProjects(String[] ProjectPaths)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.ᜀ(ᜏ A_0)

As active Dataconnection I use StrataFrameSample
In Dataexplorer i have full access to Database.

So what is wrong ?

My main Problem is
i am absolutley NewBie in DotNet.:hehe:

Thanks for your help

Rainer

ThemedContainer title not updating

Greg McGuffey — Thu, 30 Nov 2006 13:05:51 GMT

I have a ThemedContainer that I'm changing the title when the body is hidden/shown. The title is updated correctly, but the new title and the change in the chevron doesn't update the display, unless the user moves the mouse over the title bar of the themed container. Do I need to do something to get the title to update? I tried the Update() method but that didn't seem to work.

E.g.

When themed container is hidden the title says: "Process Info: {0}" ({0} replaced by the process name)
When themed container is shown the title says: "Proces Info"

What happens:

The container is initially shown.
The user clicks the chevron to hide it.
The body is hidden, title is unchanged, chevron is unchanged.
The user moves mouse over chevron (not clicking, just moving)
The title and chevron change.

Do I need to uninstall trial edition after ordering?

Aaron Young — Fri, 18 Apr 2008 09:47:15 GMT

I have just ordered SF. Do I need to completely uninstall the trial edition and download SF Setup or is it as simple as deactivating my trial license and activating my order license?

I know the source code is available as a separate download, just wondering whether I have to install the framework again.

Licence activation error, post installation

Emre Ozer — Wed, 16 Apr 2008 06:18:23 GMT

We've been seriously evaluating several application frameworks, and now came down to installing and playing with strataframe.

However, we have a trouble activating the product, while running the Activate.exe, a runtime exception is generated.

Could it be something related to regional options? The machine is XP SP2 with Intel processor.

Note that this is not .net framework exception, and the first installation phase had gone smoothly.

Also, some other strata related exceptions are being thrown in various sample applications. I've also attached one of those. While playing with the CRM sample application, after clicking customers, an error is generated

Regards,

Emre

Source Code Project Version

Michael Reese — Wed, 16 Apr 2008 17:12:32 GMT

Not a big deal for me but was the SF source code updated in VS2008? I tried to open in VS2005 then had to open in VS2008. Also, are you recommending that we manage our projects in VS2008?

Thanks

Michael

error add-in manager failed to load

Mark — Wed, 02 Apr 2008 15:39:44 GMT

After installation, upon starting VS 2005, I get:

Error message 80070002

I've read and tried the suggestions on the following posts with no success.

http://forum.strataframe.net/FindPost211.aspx

http://forum.strataframe.net/FindPost14308.aspx

thanks,

Mark

ThemedContainer cause rendering slow

Chan — Mon, 14 Apr 2008 17:55:38 GMT

Hi,
I have implemented MDIWindowListItem to my application. I am having problem that, ThemedContainer rendering is very slow during design time. I can see ThemContainer rendering look like freeze when I switch between application. It also cause diffifcutly while editing menu toolstripitem at MDI form as well.

Any ideas how to solve it?

Thank you

Adding SF to new VS2008 installation

Larry Tucker — Mon, 14 Apr 2008 13:28:32 GMT

I've been using the current SF release (1.6.5) in VS2005 and just installed VS2008.

I see these older instructions for manually adding SF to VS2008.

http://forum.strataframe.net/Topic12892-22-1.aspx

Is this the best way to go now, or is there a more current or automated method?

TIA,

Larry

Having a problem deactivating from Laptop

Geoff Hirst — Thu, 10 Apr 2008 10:37:40 GMT

Chaps,

Keep getting this error when I try and de-activate on my laptop.

UnauthorizedAccessException
Access to the path 'C:\Program Files\MicroFour\StrataFrame\License\MicroFour License.dll' is denied.

Source : mscorlib

Stack Trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.Delete(String path)
at MicroFour.Licensing.ActivationClient.UninstallLicenseFile()
at MicroFour.Licensing.ActivationClient.RequestDeactivation(Boolean isExpired)
at MicroFour.Licensing.ActivationClient.RequestDeactivation()

Please advise.

thanks

Geoff Hirst

A change in the behaviour of MyBO.Save()

Peter Denton — Thu, 27 Mar 2008 02:01:22 GMT

G'day

I've just spent a considerable amount of time debugging a form that wasn't working. I finally tracked it down to the following code:

[codesnippet]

If Me.BoGRS1.MoveFirst Then

Me.BoGRS1.GRSNew = False

Me.BoGRS1.Save()

Loop While Me.BoGRS1.MoveNext

End If

[/codesnippet]

This just loops continuously. Once I found it, I very easily fixed it as follows:

[codesnippet]

If Me.BoGRS1.MoveFirst Then

Me.BoGRS1.GRSNew = False

Loop While Me.BoGRS1.MoveNext

Me.BoGRS1.Save()

End If

[/codesnippet]

This is much better anyway, and I've checked our codebase to ensure there were no other instances of the former method.

The reason I'm raising this is that this form had been working (although I'm unsure how recently), the code had been as I found it at least since the start of November 2007 (I haven't checked back any further), and the code would have been executed every time the form was used. The only change that I can relate it to is an update to VS2008 and SF 1.6.5. I'm wondering if this is a deliberate change in behaviour of Save(), an accidental change in behaviour, or behaviour that was always expected and my code used to work by some strage quirk of fate.

I thought you might be interested.

Peter

License Activation Error

Aaron Young — Fri, 04 Apr 2008 14:07:52 GMT

Hi,

I am trying to activate my trial licence on Vista Ultimate 64bit with a wireless adapter. I get a disk space error (copied below) even though I have 45.8gb free.

Can you advise please? Also, your online store states the licence is per developer which normally suggests the developer can have the software installed on a main PC and notebook. However, your activation process appears to tie the licence to a specific machine. Is this correct? If so, does a developer who wants to install on two PCs have to buy two licences?

Thanks in advance,

Aaron

Exception
There is not enough space on the disk.

Source : MicroFour License Base

Stack Trace:
at MicroFour.Licensing.ActivationClient.RequestActivation(String Email, String Password, String Serial, String MacAddress, String ComputerName, List`1 SelectedItems, Boolean InstallLicense)
at Activate.ActivateMain.RequestActivation()

1.6.5 install error when deploying meta-data

Andria Jensen — Mon, 10 Mar 2008 11:34:00 GMT

When running the install package for 1.6.5, it gets past the 'Install Visual Studio Templates' step successfully, but each time it gets about 75% done with 'Build StrataFrame Databases' and I get an error which says "An error occurred while deploying the meta-data to the server. Please help so that I can get the new version installed. Thanks.

BusinessBindingSource Navigated Event

Ertan Deniz — Wed, 05 Mar 2008 09:12:59 GMT

I 'm trying to use Navigated event of Business Object to do business with other business object. But I've found that BusinessBindingSource Navigates internally and so this event is raised for every record of Business Object.

What can I do to cancel or catch this condition to go on doing my business in the navigated event of business object.

Access 2007 & Concurrency

Crones — Tue, 01 Apr 2008 12:54:45 GMT

I need help trying to figure out why the StrataFrame concurrency exception is not thrown when using a Microsoft Access 2007 database.
I've checked and double checked my settings... When I apply the same thing to an SQL Server everything works fine... Any ideas?

Attached is a sample project with the settings I am using.

A few problems post installation

Mike Prager — Sat, 29 Mar 2008 11:43:45 GMT

Hi Guys,

I've had to re-install SF on a windows Vista machine. Just using the sample apps to test the installation throws the exception below everytime. - Any ideas?

Also, I am getting some licensing issues when using SF in VS. I think it maybe that the license was bound to the network card in my laptop but when I'm out at clients (and sometimes back in the office), I use the wireless connection - different MAC address/different IP address - Could this be the issue and is there anyway to get around it?

Thanks in advance

Mike

TargetInvocationException
Exception has been thrown by the target of an invocation.
MissingMethodException
Method not found: 'Void MicroFour.StrataFrame.UI.Windows.Forms.ChildFormDialog.set_ParentForm(MicroFour.StrataFrame.UI.Windows.Forms.BaseForm)'.

Source : mscorlib

Stack Trace:
at SampleCRMApplication.CustomerMaintenance.InitializeComponent()
at SampleCRMApplication.CustomerMaintenance..ctor()
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at SampleCRMApplication.CRMMain.LaunchForm(Type FormType)
at SampleCRMApplication.CRMMain.cmdCustomers_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Missing info in help topic

Greg McGuffey — Fri, 28 Mar 2008 15:49:20 GMT

In the "Using the provided public fill methods" help topic (about business layer), there is a heading for the FillMultipleDataTables() method, but only the word "test" is under it. This looks to be a very cool new feature, so it would probably be nice to actually have some help on it! :blink:

(Between the object browser and the example in the what's new topic, I'm sure I'll figure it out. This is just a notice that you're help file needs to be updated)

Generated SQL not correct with ntext field

Andria Jensen — Fri, 28 Mar 2008 12:31:37 GMT

I am doing a save on one of my BOs which is returning the following exception message:

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

I have looked at the SQL which is being generated and it looks like the problem is that an equals is being used in the SQL to compare an ntext field. I am posting the SQL below. The only ntext fields in the table are Email and SendMsg. There are no text or image data types. It looks like the Email field is the one causing the problem....I have highlighted the part that I believe to be in error.

exec sp_executesql N'UPDATE [dbo].[ReportHdr] SET [ReportType] = @ReportType, [ReportDescr] = @ReportDescr, [NameKey] = @NameKey, [ReqMachine] = @ReqMachine, [ReqUser] = @ReqUser, [ReqDateTime] = @ReqDateTime, [RunMachine] = @RunMachine, [RunDateTime] = @RunDateTime, [Status] = @Status, [ErrMsg] = @ErrMsg, [ScheduleType] = @ScheduleType, [EventType] = EventType, [PeriodicInterval] = @PeriodicInterval, [PeriodicUnit] = @PeriodicUnit, [DayOfWeek] = @DayOfWeek, [WeekOfMonth] = @WeekOfMonth, [WeekOfMonthDay] = @WeekOfMonthDay, [DayOfMonthDay] = @DayOfMonthDay, [Destination] = @Destination, [SendSubject] = @SendSubject, [SendMsg] = @SendMsg, [ClientKey] = @ClientKey, [AcctExec] = @AcctExec, [CliGroup] = @CliGroup, [CliValue] = CliValue, [Office] = @Office, [DebtorKey] = @DebtorKey, [DebGroup] = @DebGroup, [DebValue] = @DebValue, [Email] = @Email, [Fax] = @Fax, [FacilityKey] = @FacilityKey, [CollateralKey] = @CollateralKey WHERE [ReportKey] = @ReportKey AND (([ReportType] = @ReportType_ORG) OR ((@ReportType_ORG IS NULL) AND ([ReportType] IS NULL))) AND (([ReportDescr] = @ReportDescr_ORG) OR ((@ReportDescr_ORG IS NULL) AND ([ReportDescr] IS NULL))) AND (([NameKey] = @NameKey_ORG) OR ((@NameKey_ORG IS NULL) AND ([NameKey] IS NULL))) AND (([ReqMachine] = @ReqMachine_ORG) OR ((@ReqMachine_ORG IS NULL) AND ([ReqMachine] IS NULL))) AND (([ReqUser] = @ReqUser_ORG) OR ((@ReqUser_ORG IS NULL) AND ([ReqUser] IS NULL))) AND (([ReqDateTime] = @ReqDateTime_ORG) OR ((@ReqDateTime_ORG IS NULL) AND ([ReqDateTime] IS NULL))) AND (([RunMachine] = @RunMachine_ORG) OR ((@RunMachine_ORG IS NULL) AND ([RunMachine] IS NULL))) AND (([RunDateTime] = @RunDateTime_ORG) OR ((@RunDateTime_ORG IS NULL) AND ([RunDateTime] IS NULL))) AND (([Status] = @Status_ORG) OR ((@Status_ORG IS NULL) AND ([Status] IS NULL))) AND (([ErrMsg] = @ErrMsg_ORG) OR ((@ErrMsg_ORG IS NULL) AND ([ErrMsg] IS NULL))) AND (([ScheduleType] = @ScheduleType_ORG) OR ((@ScheduleType_ORG IS NULL) AND ([ScheduleType] IS NULL))) AND (([EventType] = @EventType_ORG) OR ((@EventType_ORG IS NULL) AND ([EventType] IS NULL))) AND (([PeriodicInterval] = @PeriodicInterval_ORG) OR ((@PeriodicInterval_ORG IS NULL) AND ([PeriodicInterval] IS NULL))) AND (([PeriodicUnit] = @PeriodicUnit_ORG) OR ((@PeriodicUnit_ORG IS NULL) AND ([PeriodicUnit] IS NULL))) AND (([DayOfWeek] = @DayOfWeek_ORG) OR ((@DayOfWeek_ORG IS NULL) AND ([DayOfWeek] IS NULL))) AND (([WeekOfMonth] = @WeekOfMonth_ORG) OR ((@WeekOfMonth_ORG IS NULL) AND ([WeekOfMonth] IS NULL))) AND (([WeekOfMonthDay] = @WeekOfMonthDay_ORG) OR ((@WeekOfMonthDay_ORG IS NULL) AND ([WeekOfMonthDay] IS NULL))) AND (([DayOfMonthDay] = @DayOfMonthDay_ORG) OR ((@DayOfMonthDay_ORG IS NULL) AND ([DayOfMonthDay] IS NULL))) AND (([Destination] = @Destination_ORG) OR ((@Destination_ORG IS NULL) AND ([Destination] IS NULL))) AND (([SendSubject] = @SendSubject_ORG) OR ((@SendSubject_ORG IS NULL) AND ([SendSubject] IS NULL))) AND (([SendMsg] LIKE @SendMsg_ORG) OR ((@SendMsg_ORG IS NULL) AND ([SendMsg] IS NULL))) AND (([ClientKey] = @ClientKey_ORG) OR ((@ClientKey_ORG IS NULL) AND ([ClientKey] IS NULL))) AND (([AcctExec] = @AcctExec_ORG) OR ((@AcctExec_ORG IS NULL) AND ([AcctExec] IS NULL))) AND (([CliGroup] = @CliGroup_ORG) OR ((@CliGroup_ORG IS NULL) AND ([CliGroup] IS NULL))) AND (([CliValue] = @CliValue_ORG) OR ((@CliValue_ORG IS NULL) AND ([CliValue] IS NULL))) AND (([Office] = @Office_ORG) OR ((@Office_ORG IS NULL) AND ([Office] IS NULL))) AND (([DebtorKey] = @DebtorKey_ORG) OR ((@DebtorKey_ORG IS NULL) AND ([DebtorKey] IS NULL))) AND (([DebGroup] = @DebGroup_ORG) OR ((@DebGroup_ORG IS NULL) AND ([DebGroup] IS NULL))) AND (([DebValue] = @DebValue_ORG) OR ((@DebValue_ORG IS NULL) AND ([DebValue] IS NULL))) AND (([Email] = @Email_ORG) OR ((@Email_ORG IS NULL) AND ([Email] IS NULL))) AND (([Fax] = @Fax_ORG) OR ((@Fax_ORG IS NULL) AND ([Fax] IS NULL))) AND (([FacilityKey] = @FacilityKey_ORG) OR ((@FacilityKey_ORG IS NULL) AND ([FacilityKey] IS NULL))) AND (([CollateralKey] = @CollateralKey_ORG) OR ((@CollateralKey_ORG IS NULL) AND ([CollateralKey] IS NULL)));', N'@ReportType nvarchar(32),@ReportDescr nvarchar(102),@NameKey nvarchar(102),@ReqMachine nvarchar(22),@ReqUser nvarchar(14),@ReqDateTime smalldatetime,@RunMachine nvarchar(22),@RunDateTime smalldatetime,@Status smallint,@ErrMsg nvarchar(102),@ScheduleType smallint,@EventType nvarchar(22),@PeriodicInterval smallint,@PeriodicUnit smallint,@DayOfWeek nvarchar(9),@WeekOfMonth nvarchar(7),@WeekOfMonthDay smallint,@DayOfMonthDay smallint,@Destination smallint,@SendSubject nvarchar(52),@SendMsg ntext,@ClientKey int,@AcctExec nvarchar(14),@CliGroup nvarchar(12),@CliValue nvarchar(22),@Office nvarchar(22),@DebtorKey int,@DebGroup nvarchar(12),@DebValue nvarchar(22),@Email nvarchar(52),@Fax nvarchar(22),@FacilityKey int,@CollateralKey int,@ReportKey int,@ReportType_ORG nvarchar(32),@ReportDescr_ORG nvarchar(102),@NameKey_ORG nvarchar(102),@ReqMachine_ORG nvarchar(22),@ReqUser_ORG nvarchar(14),@ReqDateTime_ORG smalldatetime,@RunMachine_ORG nvarchar(22),@RunDateTime_ORG smalldatetime,@Status_ORG smallint,@ErrMsg_ORG nvarchar(102),@ScheduleType_ORG smallint,@EventType_ORG nvarchar(22),@PeriodicInterval_ORG smallint,@PeriodicUnit_ORG smallint,@DayOfWeek_ORG nvarchar(9),@WeekOfMonth_ORG nvarchar(7),@WeekOfMonthDay_ORG smallint,@DayOfMonthDay_ORG smallint,@Destination_ORG smallint,@SendSubject_ORG nvarchar(52),@SendMsg_ORG ntext,@ClientKey_ORG int,@AcctExec_ORG nvarchar(14),@CliGroup_ORG nvarchar(12),@CliValue_ORG nvarchar(22),@Office_ORG nvarchar(22),@DebtorKey_ORG int,@DebGroup_ORG nvarchar(12),@DebValue_ORG nvarchar(22),@Email_ORG nvarchar(52),@Fax_ORG nvarchar(22),@FacilityKey_ORG int,@CollateralKey_ORG int', @ReportType = N'BBS.Reports.rptPositionSummary', @ReportDescr = N'RA_Test_Template', @NameKey = N'RATESTTEMPLATE', @ReqMachine = N'BHM_RAYERS', @ReqUser = N'RAYERS', @ReqDateTime = 'Mar 26 2008 3:19PM', @RunMachine = N'BHM_RAYERS', @RunDateTime = 'Mar 26 2008 3:20PM', @Status = 0, @ErrMsg = N'', @ScheduleType = 0, @EventType = N'', @PeriodicInterval = 0, @PeriodicUnit = 0, @DayOfWeek = N'NNNNNNN', @WeekOfMonth = N'NNNNN', @WeekOfMonthDay = 0, @DayOfMonthDay = 0, @Destination = 0, @SendSubject = N'RA_Test_Template', @SendMsg = N'TEST MESSAGE', @ClientKey = 49, @AcctExec = N'RAYERS', @CliGroup = N'', @CliValue = N'', @Office = N'', @DebtorKey = 0, @DebGroup = N'', @DebValue = N'', @Email = N'rayers@baysidebiz.com', @Fax = N'5555555555', @FacilityKey = 159, @CollateralKey = 227, @ReportKey = 153, @ReportType_ORG = N'BBS.Reports.rptPositionSummary', @ReportDescr_ORG = N'RA_Test_Template', @NameKey_ORG = N'RATESTTEMPLATE', @ReqMachine_ORG = N'BHM_RAYERS', @ReqUser_ORG = N'RAYERS', @ReqDateTime_ORG = 'Mar 26 2008 3:19PM', @RunMachine_ORG = N'', @RunDateTime_ORG = 'Mar 26 2008 3:20PM', @Status_ORG = 0, @ErrMsg_ORG = N'', @ScheduleType_ORG = 0, @EventType_ORG = N'', @PeriodicInterval_ORG = 0, @PeriodicUnit_ORG = 0, @DayOfWeek_ORG = N'NNNNNNN', @WeekOfMonth_ORG = N'NNNNN', @WeekOfMonthDay_ORG = 0, @DayOfMonthDay_ORG = 0, @Destination_ORG = 0, @SendSubject_ORG = N'RA_Test_Template', @SendMsg_ORG = N'TEST MESSAGE', @ClientKey_ORG = 49, @AcctExec_ORG = N'RAYERS', @CliGroup_ORG = N'', @CliValue_ORG = N'', @Office_ORG = N'', @DebtorKey_ORG = 0, @DebGroup_ORG = N'', @DebValue_ORG = N'', @Email_ORG = N'rayers@baysidebiz.com', @Fax_ORG = N'5555555555', @FacilityKey_ORG = 159, @CollateralKey_ORG = 227

Deployment, error, are there any other files to deploy?

Ross L. Rooker, Sr. — Fri, 28 Mar 2008 13:10:00 GMT

When deployed I deployed the following dll's:

MicroFour StrataFrame Base.dll, MicroFour StrataFrame Business.dll, MicroFour StrataFrame DBEngine.dll, MicroFour StrataFrame UI.dll.

When the client runs the app, the error appears:

ApplicationException

An error occurred while creating the main form

TargetInvocationException

Exception has been thrown by the target of an invocation.

MissingMethodException

Method not found: 'Void MicroFour.StrataFrame.UI.Windows.Forms.ThemedGroupBox.set_TransparentBackground(Boolean)'.

Source : MicroFour StrataFrame UI

Stack Trace:

at VisualOfficeNET.frmNames.InitializeComponent()

at VisualOfficeNET.frmNames..ctor() in C:\VisualOfficeNET\VisualOfficeNET\frmNames.cs:line 15

at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)

at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)

at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)

at System.Activator.CreateInstance(Type type, Boolean nonPublic)

at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)

at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)

at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()

1.6.5. Heavy form turned slower.

George Nentidis — Thu, 27 Mar 2008 11:54:22 GMT

I can't tell if this is actually an issue, but we have a few Strata forms with a lot of BOs, more than 10, and a BusinessBindingSource connected to each one of them. Each BussinessBindingSource is connected to a grid or a DevExpress Lookup edit. After moving to 1.6.5 these forms take a lot longer to load. There's one that even takes 10 seconds.

Can you think of any change in the framework that might have caused that? Perhaps new events? Can you give me any hints of what might cause that, point me to the right direction?

Any help would be greatly appreciated...

Thanks

Using custom properties to bind report fields

Andria Jensen — Tue, 25 Mar 2008 10:47:02 GMT

I am using DevExpress XtraReports and have been able to make it work using a BusinessBindingSource as a DataSource, and then linking that BBS to a BO which has my report data in it. I have done this many times already and have had no problems thus far. I have been working on a problem for the past few days and haven't been able to figure out a solution.

I have several custom field properties on my BO which I have bound to fields in my report. There are also several "regular" BO properties which link directly to fields in the db table. The custom fields are all showing as blank, but the regular properties are showing as the correct values. I don't think it is even getting to the code for the custom properties since I have set break points in them which are not getting hit. I even tried hardcoding one of them to return a string value which also didnt show up.

Its almost like it doesnt know how to find the custom properties. I thought it was a problem with the binding, but if it can find the non-custom properties then it is binding correctly (I think). Here is an example of one of the custom properties:

<Browsable(False), _
BusinessFieldDisplayInEditor(), _
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
Public ReadOnly Property TransferAmt() As Decimal
Get
Return FixAmt(Me.CurrentRow.Item("TransferAmt"))
End Get
End Property

And I am also adding the custom property descriptors as I am supposed to, like the following:

Protected Overrides Function GetCustomBindablePropertyDescriptors() As MicroFour.StrataFrame.Business.FieldPropertyDescriptor()

Return New MicroFour.StrataFrame.Business.FieldPropertyDescriptor() { _
New MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor("FacilityDescr", GetType(DailyTransactions)), _
New MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor("DisburseAmt", GetType(DailyTransactions)), _
New MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor("PaymentAmt", GetType(DailyTransactions)), _
New MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor("StmtAmt", GetType(DailyTransactions)), _
New MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor("FeePostAmt", GetType(DailyTransactions)), _
New MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor("TransferAmt", GetType(DailyTransactions))}

End Function

Any advice, ideas, suggestions, etc? Thanks! I'm really stuck on this one.

BrowseDialog Freezes when shown immediately

Ben Dornis — Wed, 26 Mar 2008 00:23:18 GMT

I'm having trouble with previous functionality.

Sub Form_Load()
BrowseDialog.ShowDialog
End Sub

We used to do that, however, with the recent updates the browse dialog does show but freezes upon search. If I click cancel and then open the browse dialog again or i don't show the dialog and show it manually everything works perfectly. Is there any changes we need to be aware of or methods we could employ to keep the functionality we previously had?

QueryInformation Usage and Extension

Ertan Deniz — Thu, 20 Mar 2008 03:37:18 GMT

I'm trying to use QueryInformation Class to store some template queries.

I wonder WhereStatement class requires fields and values (these are array) but one WhereStatementTypeOptions (Equals,Greaterthan,LessThan etc). Why ?

Please explain the general process of building Where clause from WhereStatementCollection.

And I need Dbcommand object build from the QueryInformationClass ? How can I get this ?

VS2008 and SF 1.6.5 - System.OutOfMemoryException - In IDE

Geoff Hirst — Sun, 09 Mar 2008 12:14:20 GMT

Guys,

Have you any experience of the above exception occurring in the above configuration? I get this numerous times a day, and the only way out is to quit VS and restart.

It usually happens if I have a particular form open, just after a build. The application continues to run. I have 4GB ram in this system and I know it's not running out of memory. However as it seems to happen after a while, there is something somewhere that isn't releasing all it should. It only happens in the IDE, my app is fine.

It's just annoying.

thanks in advance for any ideas.

Geoff

Problem with Stratframe ASP.Net Web Example

John Davies — Tue, 11 Mar 2008 18:22:38 GMT

Hi,

I wonder if you can help ... I was working through your Web sample ... and now I keep getting the error below when I click on a page that access the Strataframe database, Remote connections are enabled. Can you help ? I have SQL 2000 installed and SQL Express. In my global asax file I added the connection string

DataLayer.DataSources.Add(new SqlDataSourceItem("", "Server = ./SqlExpress;Database=StrataFrameSample;Integrated Security=SSPI"));

.... although I don't believe I need it. I have also successfully connected to the database using the Database connection Tool.

[codesnippet]Error
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 127:Line 128://-- Execute the commandLine 129:Customers.FillDataTable(loCommand);Line 130:Line 131://-- Stop the watch

Source File: e:\Program Files\MicroFour\StrataFrame\CSharp Samples\Web Sample\SearchCustomers.aspx.cs Line: 129

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] [/codesnippet]

Need to Compile Lastest Infragistics Version

Michael Reese — Mon, 17 Mar 2008 09:13:43 GMT

Hi Guys,

I was wondering if a maintenance release on top of 1.6.5 is scheduled real soon? I am thinking about installing the lastest version of Infragistics and would like to recomple the wrappers.

Thanks

Michael

Problems with SharedDataTableKey

Richard Keller — Fri, 14 Mar 2008 12:27:33 GMT

I'm pretty sure that I have isolated a problem with the shared data table key and I have a secondary problem on how the filter is handled. I'll see if I can explain. If you create a BO and specify a SDTK( Shared Data table Key ) then the first time that the BO is instantiated and filled everything is fine. But for some reason if there is a Object or Form that Dispose of the last instance of that class then the SDTK is now a bug and upon the first new instance of the Same BO type then the DataRow Index will be all messed up. It looks like the Finalize of the BO does not removed the SDTK from it's collection for SDTK keys. I'm pretty sure that this bug is the reason for a couple of the SDTK posts.

Second problem with SDTK. Filters. If you are using 2 BO that are bound with a SDTK and you filter one of them the second is filtered. Is there a reason for this? For my thought process is for lookups that rarely get update or automatically notified if DB changes then having a BO with a SDTK would work well and does. Up until one of those BO's are filtered for some reason and then All of the BO's are filtered. This obviously messes up a bunch of things.

Any ideas?

Richard

Problem running CRM Sample

Mike Tomlin — Wed, 12 Mar 2008 06:11:38 GMT

When I try and run the CRM sample (1.6.5) clicking on the products brings up the form but there's no data but on order entry or customers I get an exception...

Source : mscorlib

The database seems to be connected OK to the sample data - any clues?

Thanks

Mike

SF and VS2008

Hugo R. Figueroa — Fri, 11 Jan 2008 16:03:28 GMT

I have a web page with a WebBusinessBindingSource and an Infragistics UltraWebGrid. (2007.3)

When I try to set the grid's Datamember property i get the following message:

Nullreference Exception

Object reference not set to an instance of an object

Source: Microfour Strataframe Extensibility

Stack Trace:

at Microfour.Strataframe.Extensibility.WebBusinnessBindingSource.GetView(String viewName)

After that, everytime I click on the grid I get the same message and have to click on the OK button several times to get rid of it.

1.6.5 - Update security tables

Rogerio Mauri — Sat, 08 Mar 2008 07:14:12 GMT

Olá...

Which the correct procedure for conversion of security tables? Because I had problems after the update of the version.

For example:

1) If I to exclude tables of security of the DDT, the installing package it also excludes in the base destination.

2) If I to recharge tables, the update of the DDT duplicates and gives errors.

1.6.5 version - SFMessagind.exe informs version 1.6.0

Rogerio Mauri — Thu, 06 Mar 2008 19:55:36 GMT

Olá...

I made the update of the program for the new version. However, the SFMessagind.exe informs version 1.6.0.