Re: Vfp and sql

Author: desmond.lloyd@gmail.com

Posted: 2012-01-22 at 22:05:45

Make the cursor readwrite and stuff the detail memo contents in the one?

Regards,

Desmond

Sent via BlackBerry by AT&T

-----Original Message-----

From: Sytze de Boer <sytze.kiss@gmail.com>

Sender: profox-bounces@leafe.com

Date: Mon, 23 Jan 2012 15:43:19

To: profox<profox@leafe.com>

Reply-To: ProFox Email List <profox@leafe.com>

Subject: Vfp and sql

I hope my question does not meet with too much derision .......

I can do the following and end up with desired result

select client,sum(invvalue) as invttl, desc, ordnum, memodetails from

mytable into table newtable group by client,ordnum

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 ?

--

Regards

Sytze de Boer

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

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/CAG1nNy8ZA_97=qe4NPundA6+LZmGKnsFGxFQBtepGUvc4RLRnA@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.

_______________________________________________

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/1049690791-1327287945-cardhu_decombobulator_blackberry.rim.net-1744163429-@b4.c13.bise6.blackberry

** 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.

©2012 desmond.lloyd@gmail.com