[RBG7-L] - Re: How to get VARCHAR value from DB Memo field

[A. Razzak Memon]

At 10:41 AM 2/20/2005, Larry Lustig wrote:

Can anyone suggest how I can get hold of the VARCHAR value under
program control, then pop it into a different DB Memo field?

Here's one way.

In an EEP or any relevant procedure:

SET VAR vVarCharAsNote NOTE
SELECT VarCharField INTO vVarCharAsNote INDIC ivVarCharAsNote +
FROM tablename WHERE ...

Resulting vVarCharAsNote variable will include the data from
VARCHAR you are looking for.

Then you can manipulate this value any way you wish, including
the option of using PROPERTY <componentID> TEXTVALUE .varname

Very Best R:egards,

Razzak.