Varcharmapping & browse

From: "Lew" <lew@xxxxxxxxxxx>
Date: Sun, 27 Aug 2006 15:46:09 -0400

I see there's a problem when updating a varchar field during a browse. The
effective field length seems to be fixed as per the original data entry.
Attempting to work around this by setting varcharmapping off during the
browse and then turning it on again when I'm done produces the opposite
problem: any trailing spaces I happen to leave become part of the data until
I do a replace xx with trim(xx), etc... I suppose one way to solve this
problem is to turn varchar mapping off before the browse, have an update
trigger tidy up the data and then turn mapping back on. This seems tedious.
Is there a simpler way?
-Lew.

.

Prev by Date: Re: Fields on a form or a pageframe
Next by Date: xml text
Previous by thread: Fields on a form or a pageframe
Next by thread: xml text
Index(es):
- Date
- Thread

Relevant Pages

Char vs. Varchar
... Inserting and updating a varchar field is slightly slower ... as it needs to allocate the bytes to store it. ... >I have one silly doubt on CHAR and VARCHAR. ...
(microsoft.public.sqlserver.programming)
Re: SELECT MAX(...) returns 0
... How do you define MAX of a VARCHAR Field? ... (telephone directory order). ... Since you use the term "varchar", it sounds like the database engine may not ...
(microsoft.public.vb.database.ado)
Re: varchar sizes
... I believe eachand every varchar column has a 2 byte overhead for storing the ... A low-level page formats are well described in Kalen Delaney's book ... > length of the varchar field is only 6 bits long. ...
(microsoft.public.sqlserver.programming)
Re: Index integer vs. varchar
... I believe it's more space efficient, because an integer will use only 4 ... > is a key of the business and this is a varchar datatype. ... > Several other tables have this primary key in yours fields. ... > varchar field but in the rest of the table only put this ...
(microsoft.public.sqlserver.programming)