Sharon, OK. You haven't missed anything - I can't get it to work reliably either this morning?? This is what I have so far:
1. DBMemo object mapped to TEXT data field custname, component id memocust 2. DBEdit object mapped to same field, component id custname. PROPERTY custname TEXTVALUE .vcustname works (vcustname defined in form variables list) PROPERTY memocust TEXTVALUE .vcustname works as long as custname db edit is on the form. SET VAR vmemocust VARCHAR = .vcustname PROPERTY memocust TEXTVALUE .vmemocust also works as long as custname db edit is on the form. I tried giving component id custname to a different text field from the table as a test. That DID NOT work. So it isn't just the component id, it is necessary for the custname db edit to be on the form. PROPERTY custname VISIBLE 'FALSE' in the on after start eep on the form hides the db edit. Since it is still on the form, the property command on the db memo works. The db memo is still editable and the data saves properly. I'm not sure what other ramifications there would be by having two of the same data fields on a form (with one hidden.) So with the db edit not visible, in the on exit eep from the customer id field I have: SET VAR vmemocust VARCHAR = .vcustname PROPERTY memocust TEXTVALUE .vmemocust PROPERTY custname TEXTVALUE .vcustname (even with the field not visible, it appears this is needed - as soon as I removed it from my eep, the db memo property didn't work??) That's the only workaround I've come up with that works every time. Dawn -----Original Message----- From: Sharon Lima [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 5:16 PM To: RBG7-L Mailing List 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. >> ================================================ >> >> > >
