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" <[email protected]> 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 [email protected] > > (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 [email protected] > In the message SUBJECT, put just one word: INTRO > ================================================ > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > ================================================ > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > 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. > ================================================ > >
