Exactly..... On 23 January 2012 12:07, Dan Covill <dcov...@san.rr.com> wrote: > On 01/23/12 06:50, Sytze de Boer wrote: >> It gives me the 1 record I want >> BUT >> I also need to combine the memodetails into this same single record Can this >> be done ? > > There's no way VFP can automatically concatenate those memo fields for > you (much less do anything with a Blob field). > > I'd suggest the following: > 1. Do your select, without the sum(), into a cursor. > 2. Scan the cursor, concatenating the memo fields into a string. > 3. Run your sum() on the cursor, creating your single record. > 4. Stuff your concatenated string into the memo field. > > Dan > [excessive quoting removed by server]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAAJXvaOs+82ojCDQGcPACOaD-UpQt6=781uuwtxlfysuxvq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
