|
| | | 
StrataFrame Novice
 
Group: StrataFrame Users
Last Login: 2 days ago @ 8:24:55 PM
Posts: 90, Visits: 157 |
| Hi
I use the RichTextBox control in one form, is bounded to a nvarchar(max) field by the BO. The property is set to RFT.
Works great with text, but for testing I add a picture to the RTF, this because the also have a RichTextBoxToolStrip tah has an Image insert function.
The image is added corrctly and can be showed without problems, but if I try to delete the image or make any chaneg to the text I get this error:
BusinessLayerException
An error occurred while saving an the data to the server.
DataLayerSavingException
String or binary data would be truncated.
The statement has been terminated.
SqlException
String or binary data would be truncated.
The statement has been terminated.
Source : MicroFour StrataFrame Business
Stack Trace:
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
en System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
en System.Data.SqlClient.SqlDataReader.get_MetaData()
en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
en System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
en System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
en System.Data.Common.DbCommand.ExecuteReader()
en MicroFour.StrataFrame.Data.DbDataSourceItem.InternalExecuteReader(DbCommand Command, Boolean IsTransactional, String TransactionKey)
en MicroFour.StrataFrame.Data.SqlDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler, Boolean RecreateCommand)
en MicroFour.StrataFrame.Data.DbDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler)
en MicroFour.StrataFrame.Data.DataLayer.UpdateDataTableThread(Object ThreadParams)
en MicroFour.StrataFrame.Data.DataLayer.UpdateDataTable(DataTable TableToUpdate, Boolean Transactional, String TransactionKey)
en MicroFour.StrataFrame.Data.DataLayer.SaveByForm(DataTable TableToSave, Boolean Transactional, String TransactionKey)
en MicroFour.StrataFrame.Business.BusinessLayer.SaveByForm(Boolean Transactional, String TransactionKey)
en MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save(Boolean Transactional, String TransactionKey)
en MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save()
en MicroFour.StrataFrame.UI.Windows.Forms.MaintenanceFormToolStrip.cmdSave_Click(Object sender, EventArgs e)
en System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
en System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
en System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
en System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
en System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
en System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
en System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ScrollableControl.WndProc(Message& m)
en System.Windows.Forms.ToolStrip.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
en System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Hope you can help me in how to use this?
Regards
 Everything is possible, just keep trying... |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 6:26:12 PM
Posts: 4,901, Visits: 4,887 |
| | Hmmm....the message that is occuring has nothing to do with the image, but rather the size of the text being saved back to the server and what the SQL things is the size limit of the field. First, what version of the framework are you running? Second, ensure that your field is properly setup and mapped and you may want to place the Data source in debug mode so that you can actually see exactly what is going back to the server: MicroFour.StrataFrame.Data.DataBasics.DataSources("").SetDebugOn(...) |
| |
| | |
StrataFrame Novice
Group: StrataFrame Users
Last Login: 2 days ago @ 8:24:55 PM
Posts: 90, Visits: 157 |
| | Hi Trent I'm using last version 1.6.5.3 of StrataFreme. The field is VarCharMax. And in the form is value is RTF. I read in other place that if a RTF is going to have images, should be BinaryMax the field, is this correct? Regards
Everything is possible, just keep trying... |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 6:26:12 PM
Posts: 4,901, Visits: 4,887 |
| I read in other place that if a RTF is going to have images, should be BinaryMax the field, is this correct? Well, that would be the first thing you might try. It is possible that the image being inserted is causing the issue. You might try and insert a small test image (other than the one you have been inserting) and see if the problem persists. Really, you should be able to use an NVarChar(MAX) field as the binary data is placed into a Unicode format when saving. So NVarChar(MAX) should work and is in fact what we use (and images work ). Try placing the data source in debug mode as mentioned above and see if you can tell if there is something going on with the UPDATE. |
| |
| | | 
StrataFrame Novice
Group: StrataFrame Users
Last Login: 10/12/2008 10:41:53 AM
Posts: 69, Visits: 1,282 |
| | Hello, could it have something to do with how the 'UpdateConcurrencyType' at the BO is set? If I recall it correctly, using 'OptimisticAllFields' would lead to this type of error. I hope, my guess is right? Friendly greetings, Ralph
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 6:26:12 PM
Posts: 4,901, Visits: 4,887 |
| | That is a good suggestion and could very well cause a problem. Good thinking, Ralph! Ralphs is talking about how StrataFrame manages concurrency exceptions by default. So if you are using the AllFieldsOptimistic (by default this is the settings) then you could get this error. You would want to use a Row Version or Time Stamp for concurrency checking instead. |
| |
| | |
StrataFrame Novice
Group: StrataFrame Users
Last Login: 2 days ago @ 8:24:55 PM
Posts: 90, Visits: 157 |
| | Ralph, Trent Thanks, changing the concurrency type all works without problems. Regards
Everything is possible, just keep trying... |
| |
| | |
StrataFrame Novice
Group: StrataFrame Users
Last Login: 2 days ago @ 8:24:55 PM
Posts: 90, Visits: 157 |
| Ralph, Trent
Thanks, changing the concurrency type to RowVersion or TimeStamp let save and remove images from the RichTextBoxField.
I take a look about this but as I does not have the experience to create code to manage concurrency for RowVersion or TimeStamp, I need let SF handles concurrency (the window that opens when a concurrency exception hapens is great), maybe in some time I can create code for handle the colisions.
So, I just hide from code the Image button in the RichTextBoxToolStrip and limit the characters to 40000 (the maximum number of characters that can be handled in concurrency optimistic).
Thanks a lot for your help.
Everything is possible, just keep trying... |
| |
| | |
|