Jim, something along these lines should work. SET VAR vNewText TEXT = (CTXT(.#DATE) & 'This is my new note') UPDATE <table> SET <noteField> = (Notefield & .vNewText) + WHERE <don't forget this or you'll update all rows!>
"Jim Van Dillen" <[EMAIL PROTECTED]> wrote: > >I am trying to come up with a way to have a command file automatically >add text to existing text in a note field. > >The command file would automatically add today's date and a text string >based on the particular command file being run. > >I believe I did something similar years ago with a concantination >command of some type but I can't find anything about it in the current >"documentation" and I can't find the old code. > >The group's help has been outstanding in helping this non-programmer in >overcoming various small problems in streamlining our office system >which controls the dockets, etc. �By the way this system was first >originally written in RBase some 15 years ago and has been serving us >well with occasional tweaks and improvements ever since. > >Thanks in advance for your always helpful suggestions. > > >JIM VAN DILLEN >Attorney at Law >1505 S. Big Bend Blvd. >St. Louis, MO. 63117 >(314)645-8008; Fax (314)645-8016 >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
