Hello



since 2 days i had a problem with my Database.



I was changing the Sorting mechanism from German_TelefonBook__ to Latin_general_Bin2



Since this time all BO has problems with Upper and Lowercase with the Fieldnames of

the tables.



If i change the fieldname in table to exactly same string as it is in BO then it works.

But i think there should be another way to avoid this stange behavior.



I hope you can help me.



Thanks



Rainer

Hi,

A couple of thoughts:

1) Regenerate your all your BO's.

2) Try going into Project Propereties > Compile > Option Compare - set to Text.

Cheers, Peter

I agree with Peter, I would rebuild your partials first and recompile to see if the problem persists.

Hi,



Thanks for the tips, but they don't work.



It happens also with SF-Own BO



When i Call this :





Public Sub OpenSecurityDialog()

Using loDialog As New SecurityDialog(False, False)

loDialog.ShowDialog()

End Using



End Sub



then i got following error :



When i check table (SFSROLES) in Database field is defined as "rl_Role"



If i change rl_Role to rl_role then it works.





It seems i had changed something on Database which i can't remember. but for my opinion

i changed only sort order.







SqlException

Ungültiger Spaltenname 'rl_role'.



Source : .Net SqlClient Data Provider



Stack Trace:

bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

bei System.Data.SqlClient.SqlDataReader.get_MetaData()

bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)

bei MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)

bei MicroFour.StrataFrame.Security.BusinessObjects.SFSRolesBO.FillAll(Int32 ProjectPK)

bei MicroFour.StrataFrame.Security.SecurityDialog.RolesBO_ParentFormLoading()

bei MicroFour.StrataFrame.Business.BusinessLayer.raise_ParentFormLoading()

bei MicroFour.StrataFrame.Business.BusinessLayer.OnParentFormLoading()

bei MicroFour.StrataFrame.Business.BusinessLayer.RaiseParentFormLoadingEvent()

bei MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.InitializeFormLoadObjects()

bei MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.OnLoad(EventArgs e)

bei System.Windows.Forms.Form.OnCreateControl()

bei System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

bei System.Windows.Forms.Control.CreateControl()

bei System.Windows.Forms.Control.WmShowWindow(Message& m)

bei System.Windows.Forms.Control.WndProc(Message& m)

bei System.Windows.Forms.ScrollableControl.WndProc(Message& m)

bei System.Windows.Forms.ContainerControl.WndProc(Message& m)

bei System.Windows.Forms.Form.WmShowWindow(Message& m)

bei System.Windows.Forms.Form.WndProc(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)

bei System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)



I hope somebody does know i trick to fix this strange behaviour.



thanks again



Rainer

It looks like your structures are not up to date or your connection string within your app is not point to a database with the security tables.  If this is happening across the board, then that should be a pretty clear indication that your data structures or environment are one of the following:

1. Not up to date
2. Connection string pointing to the wrong database or location
3. You are running with out of date BO assemblies

There is a 99.9% chance it is one of these things.

Hello Trent



Thanks for the reply



I will testing again your advices and then

report whats happen.



I am still now by customer for rest of week.

so it will takes some times...







thanks again

Rainer