Hi Javier and Dawn I am trying to convert a Note system that I have been using for years in 6.x but have never figured out how to do the same thing in 7.x.
Basically, I look a paragraph of text and place it into a note field (I would love to use a varchar). I want to be able to do this several times so I can build letters with several paragraphs. So, the property command PROPERTY vci_your_column TEXTVALUE .vyour will not work unless I load the current paragraphs into the var first then append the new text to the end of the letter, then place the new letter into the note field. I think I may need to set a var = to the column. I will try that, I forgot all about this. I remember something like the below but can't remember what it was for and why it was suggested. colA = vcolA vcolA = colA I may have the order of them backwards. I will give that a try, thanks for the thought. thanks again Marc > Marc: > If you want to update a column in the current row with a variable use the > following command: > PROPERTY vci_your_column TEXTVALUE .vyour_variable > Where vci_your_column is the Component ID for the columns you want to update > and vyour_variable contains the value with which you want to upgrade the > column. > Now, if you want to set a variable to the same value as a column, use > "Variable>Add/Edit variables" on the Top Menu Bar to define a variable > v_your_variable equal to the column; now, the value of v_your_variable will > always be that of the column you selected for the current record. > I am not exactly sure which one you wanted. > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc > Sent: Thursday, November 10, 2005 9:23 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Fw: Update current row > > > Sorry I hit send instead of Spell Check and I didn't finish the post. > > Hi > > I thought there was a way to update the current row without > having to list specific columns. > > I want to be able to update the current row without using columns > in the where clause and I would like to be able to set a var = to > a column on the current row. > > Thanks, sorry for the 1/2 post > Marc > >
