Larry - Here's another possible approach - instead of just getting the value of the VARCHAR into a variable, can you do a PROJECT TEMP table with the VARCHAR column along with the PK column and have the field from the temp table on your form for editing?
Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Sunday, February 20, 2005 8:51 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: How to get VARCHAR value from DB Memo field > SET VAR vVarCharAsNote NOTE > SELECT VarCharField INTO vVarCharAsNote INDIC ivVarCharAsNote + > FROM tablename WHERE ... > > Then you can manipulate this value any way you wish, including > the option of using PROPERTY <componentID> TEXTVALUE .varname This will definitely get me started. However, I don't think I will be able to put my value into the second DB Memo using TEXTVALUE (at least, I couldn't find such a property for that control either in the online property manual or by testing the control). I did try using a second control, an invisible DB Edit, to read and write the TEXTVALUE, but reading it only produced "(Blob)" in my variable. It sounds like you're suggesting that writing to it will produce the desired effect? Thanks for the help -- I will be looking at this in the next few days and will report back how far I am able to get. -- Larry
