StrataFrame Forum / StrataFrame Application Framework / Issues / edit a varchar(max) value give me a "String or binary data would be truncated" error / Latest Posts

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

Trent L. Taylor — Tue, 06 May 2008 08:47:15 GMT

Fabian,

Please don't think I was upset in any way!!! Absolutely no big deal at all. As for the concurrency, I am glad that you found what you needed...you will be far better off using RowVersion checking versus AllFields anyway!

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

Fabian R Silva, - — Tue, 06 May 2008 08:10:12 GMT

I have to say Sorry 2 times, 1 for the paste of the debug htm (I doesn't known that it can break the page :( ) and another for my lack of knowledge about some topics, one of them that I forgive are concurrency stuff :blush:

I put a int "RowVersion" field, on the BO set UpdateConcurrencyType to "rowversion" and set RowVersionOrTimestampColumn to "RowVersion" and all worked fine :) many thanks.

- Fabian

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

Trent L. Taylor — Mon, 05 May 2008 16:46:11 GMT

The problem is that you are using AllFields for your concurrency checking and have a MAX field. If you want to allow this MAX field to be inclusive of the concurrency checking, then you need to use a row version field or time stamp field...which is far better anyway. You can only take a VarChar(8000) as the max length on concurrency checking for All Fields.

Really if you want to use concurrency checking, you should be using Row Versioning anyway. Create an integer field in the DB, and then specify this field name in the CRUD settings of the BO.

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