Problems with upper and Lowercase in BO

Rainer Kempf, RK — Thu, 13 Nov 2008 10:38:03 GMT

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

RE: Problems with upper and Lowercase in BO

Rainer Kempf, RK — Thu, 13 Nov 2008 10:38:03 GMT

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

RE: Problems with upper and Lowercase in BO

Trent L. Taylor — Wed, 12 Nov 2008 09:12:27 GMT

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:

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

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

RE: Problems with upper and Lowercase in BO

Rainer Kempf, RK — Wed, 12 Nov 2008 01:31:01 GMT

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

RE: Problems with upper and Lowercase in BO

Trent L. Taylor — Tue, 11 Nov 2008 17:24:06 GMT

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

RE: Problems with upper and Lowercase in BO

Peter Jones — Tue, 11 Nov 2008 14:20:12 GMT

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

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Problems with upper and Lowercase in BO

Problems with upper and Lowercase in BO

RE: Problems with upper and Lowercase in BO

RE: Problems with upper and Lowercase in BO

RE: Problems with upper and Lowercase in BO

RE: Problems with upper and Lowercase in BO

RE: Problems with upper and Lowercase in BO