Sharon Download Update 80, Release Candidate 2, this morning and check out enhancement #3!
Thanks, Razzak and Dream Team! 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 5:15 PM Subject: [RBG7-L] - Re: DB Memo Object on Form > Dawn, > > Thanks for helping out on this. > I still don't have it working even when I do the following. > I think this what you did. > Have I missed something? > > The following is what I have in the On Exit EEP for the WorkNum field. > xWorkNum is defined as an expression, xWorkNum = WorkNum > This all works great for populating the field MONEY, a DBEdit field. > From the following I still get nothing in the LABDESC unless I also place > that extra DBEdit for LABDESC. > Even then, with vLabDescNote defined as VARCHAR I get '.vLabDescNote' in the > field instead of the value. > I think I am loosing it! > ---------------------------------- > CLEAR VAR vMoney vLabDesc vLabDescNote > SET VAR vMoney REAL vLabDesc TEXT --(I tried defining and not defining > vLabDescNote VARCHAR here) > > SELECT WRATE INTO vMoney INDIC IND1, + > FROM WORKLIST WHERE WorkNum = (.xWorkNum) > > SELECT WORKDES INTO vLabDesc INDIC IND2 + > FROM WORKLIST WHERE WorkNum = (.xWorkNum) > SET VAR vLabDescNote VARCHAR = .vLabdesc > > PROPERTY ID_LABDESC TEXTVALUE .vLabDescNote > > PROPERTY ID_MONEY TEXTVALUE .vMoney > > RETURN > -------------------------------------- > Remember, all my columns are TEXT not NOTE. > > > 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: "Dawn Oakes" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Thursday, February 24, 2005 3:17 PM > Subject: [RBG7-L] - Re: DB Memo Object on Form > > > Well go figure. ...I tried something else. > > Try this (using my example from before) in the on exit eep from custid > field: > > SET VAR vmemocust VARCHAR = .vcustname > PROPERTY dbmemofield TEXTVALUE .vmemocust > > Works! Without the db edit for custname on the form (I just have the db > memo for custname). > > Dawn > > -----Original Message----- > From: Sharon Lima [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 24, 2005 2:50 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: DB Memo Object on Form > > Dawn, > > Now try that form after removing the DBEdit object leaving only the > DBMemo object. > I tried adding the DBEdit and, low and behold, BOTH objects get the > lookup value just as in your sample. > However, when I remove the DBEdit object, the DBMemo no longer gets the > lookup value. > > 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: "Dawn Oakes" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Thursday, February 24, 2005 1:16 PM > Subject: [RBG7-L] - Re: DB Memo Object on Form > > > Sharon > If both are text fields, then it should work, even if the object is a db > memo. I just tried it. > > I placed a DB Memo in an existing form representing customer name (text > 30). I already had a DB Edit for the same and I assigned the same > component id for both (custname). On exit from the customer number field > the eep does PROPERTY custname TEXTVALUE .vcustname. (vcustname is > predefined as custname in custlist whe custno = custno). The customer > name populated both the text field and the db memo. > > Dawn > -----Original Message----- > From: Sharon Lima [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 24, 2005 12:42 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: DB Memo Object on Form > > 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" <[email protected]> > 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" <[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. > >> ================================================ > >> > >> > > > > > >
