[RBG7-L] - Re: DB Memo Object on Form

[Sharon Lima]

Thanks David,
I had fallen a little behind with reading the posts
and that information is useful when all fields are NOTE.
However my situation has the following twists:
1. Neither the lookup value nor the position I want it to go is
a NOTE field; both are TEXT fields.  The reason I want
to use the "DB Memo" object on the form is that I need the
text to WRAP.
2. Also notice that there is no TEXTVALUE
property listed for the DB Memo object.
Sharon Lima
Sharetech
753 Warren St
Westfield, NJ 07090
(908) 232-5286 (P)
(908) 349-3118 (F) - New
[EMAIL PROTECTED]
http://www.sharetech.net
----- Original Message ----- 
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <rbg7-l@rbase.com>
Sent: Thursday, February 24, 2005 11:18 AM
Subject: [RBG7-L] - Re: DB Memo Object on Form


Sharon
This very question was asked last week. Here are two replies that I saved:
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.
Select someVarCharData  into vVarAsNote ind Vin0 from SomeTable wher
SomeWhereClause
Won't produce the desired result if the Varchar data has quotes in it.. It
Truncates at the first quote.
Mike B
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
----- Original Message ----- 
From: "Sharon Lima" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <rbg7-l@rbase.com>
Sent: Thursday, February 24, 2005 12:56 AM
Subject: [RBG7-L] - DB Memo Object on Form


Hello All,
I have used the following command in an On Entry EEP
to propagate a default value into a column assigned
as a DB Edit object and it works great.
PROPERTY ID_Dep TEXTVALUE .vDep
What I need is the ability to do the same if the column is
placed on the form as a DB Memo object.
It seem like TEXTVALUE is not an available Property for
DB Memo.  Is there a different way to get the default
editable value into the DB Memo field?
Sharon Lima
Sharetech
753 Warren St
Westfield, NJ 07090
(908) 232-5286 (P)
(908) 349-3118 (F) - New
[EMAIL PROTECTED]
http://www.sharetech.net
--- RBG7-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to rbg7-l@rbase.com
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to rbg7-l@rbase.com
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to rbg7-l@rbase.com
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to rbg7-l@rbase.com
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================