Larry / Bill
Bill, in your system do they have to type everything in
by hand?
I use a eep to build my text, I am using a note field now
but was wanting to change it to varchar so would this
eep work with varchar??
So, I guess I would need a var for the varchar field to
hold more than 4k?? and if you can't use varchar in
expressions, I am going to have a problem??
Marc
IF vspcode = '' OR vspcode IS NULL THEN
GOTO spend
ENDIF
SET VAR v1text TEXT = NULL
SELECT spdesc INTO v1text FROM soapcode WHERE spcode = .vspcode
-- Looks up canned text and headings
SET VAR vtext = (SRPL((SRPL((SRPL(.vxtext,'[fname]',.vfname,1)), +
'[heshe]',.heshe,1)),'[himher]',.himher,1))
-- search replace first name....
SET VAR vsubj = (.vsubj + ' ' + .vtext)
.......
......
RETURN
>
> You should be aware that there are some substantial limitations on VARCHAR
> columns. In particular, they cannot be used in expressions. That means
that
> you can't "build" the text in a VARCHAR column like this:
>
> UPDATE Table SET VarColumn = (VarColumn & 'Case discount applied.') +
> WHERE PackingType = 'Case'
>
> You also can't SRPL or SLOC on them.
>
> In addition, I've had some trouble with the line end character conventions
> being different in NOTE and VARCHAR fields.
>
> In general, VARCHAR is great if the primary access to the data will be
through
> bound controls on forms. If you want to use the data as maleable text
values,
> however, you may be better off sticking with NOTE fields.
> --
> Larry
>
>
