StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Handling varchar fields

Handling varchar fields

Daniel Essin — Fri, 10 Feb 2006 18:59:45 GMT

I have a database field SendMethod varchar(10).

When I refer to this field after a Fill procedure, for example as:
bo.SendField the contents is "FAX " padded to a length of 10.
I think that for a varchar(10) field, the contents should be "FAX" and for a char(10) the contents should be "FAX ".

If the current behavior is correct then I will have to Rtrim every reference to the field in the BO, which doesn't sound appealing.

RE: Handling varchar fields

Daniel Essin — Fri, 10 Feb 2006 18:59:45 GMT

From the InnerException:
StackTrace = " at MicroFour.StrataFrame.Business.BusinessLayer.SaveBase(Boolean Transactional, String TransactionKey)\r at MicroFour.StrataFrame.Business.BusinessLayer.Save(Boolean Transactional)\r at TEST_FaxSending.Form1.timer_Tick(Object sender, EventArgs e...

It looks like maybe the BusinessLayer.SaveBase is requiring a key name even though Save() and Save(false) imply that the save is not part of a transaction
???

RE: Handling varchar fields

Daniel Essin — Fri, 10 Feb 2006 18:54:36 GMT

You're right. That was an artifact of converting from char to varchar.

I've now gotten to the point of trying to save and update to a Log record. When I execute _Log.Save() I get:
Value cannot be null.
Parameter name: key
System.ArgumentNullException: Value cannot be null.
Parameter name: key
at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.CreateDbParameter(QueryInformation QueryInfo, String FieldName)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.BuildUpdateCommand_NonSP(QueryInformation QueryInfo)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.BuildUpdateCommand(QueryInformation QueryInfo)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler)
at MicroFour.StrataFrame.Data.DataLayer.UpdateDataTableThread(Object ThreadParams)

RE: Handling varchar fields

Trent L. Taylor — Fri, 10 Feb 2006 16:57:29 GMT

Daniel,

I am not sure exactly what you are trying to say. If you have a field typed as a VarChar(x), and you store a value of "FAX", it will only store and retrieve "FAX" however, if you are using a char(x) type, if you store a value of "FAX" SQL Server will return a value of "FAX ". StrataFrame BOs will retrieve the value as it is stored in the database. If you have a VarChar(x) field that has padding on the right, it had to be stored that way. If you store a padded value into a VarChar field, it will respect that padding and keep it in the database.