, Ricardo Aráoz wrote:
>
>Date: Mon, 16 Feb 2009 06:32:26 -0300
>From: Ricardo Aráoz
>To: profoxt...@leafe.com
>cc:
>Subject: Re: Simplest form of SQL?
>
>Joe Yoder wrote:
>> Actually, the approach I used in the original example with an
>> intermediate cursor is probab
On Mon, Feb 16, 2009 at 2:01 PM, MB Software Solutions General Account
wrote:
>
> I hear that the SQL for Dummies by Joe Celko is a great book.
>
Close but no cigar:
http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/1558609202
A+
jml
(recommended reading though)
__
Joe Yoder wrote:
> Actually, the approach I used in the original example with an
> intermediate cursor is probably simpler that any scheme that does it all
> in one statement. I am simply trying to improve my understanding of SQL
> queries.
> Thanks - Joe
I hear that the SQL for Dummies by Joe C
Joe Yoder wrote:
> Actually, the approach I used in the original example with an
> intermediate cursor is probably simpler that any scheme that does it all
> in one statement. I am simply trying to improve my understanding of SQL
> queries.
> Thanks - Joe
>
Joe, have you tried correcting the
Joe Yoder wrote:
> Actually, the approach I used in the original example with an
> intermediate cursor is probably simpler that any scheme that does it all
> in one statement. I am simply trying to improve my understanding of SQL
> queries.
> Thanks - Joe
>
Joe, have you tried correcting the
:
>
>Date: Sun, 15 Feb 2009 20:25:00 -0600
>From: Stephen Russell
>To: profoxt...@leafe.com
>cc:
>Subject: Re: Simplest form of SQL?
>
>On Sun, Feb 15, 2009 at 6:11 PM, Joe Yoder wrote:
>> When executed in VFP 9 SP2, Foxpro highlites the fourth line (SELECT *
>&g
On Sun, Feb 15, 2009 at 6:11 PM, Joe Yoder wrote:
> When executed in VFP 9 SP2, Foxpro highlites the fourth line (SELECT *
> ;) and reports "Syntax error". I tried putting the code back into one
> line and other modifications based on my limited experience. I ended up
> with different errors b
complete.
Joe
On Sunday, February 15, 2009 5:05 PM, Stephen Russell wrote:
>
>Date: Sun, 15 Feb 2009 16:05:07 -0600
>From: Stephen Russell
>To: profoxt...@leafe.com
>cc:
>Subject: Re: Simplest form of SQL?
>
>On Sun, Feb 15, 2009 at 10:35 AM, Joe Yoder wrote:
>> Tha
On Sun, Feb 15, 2009 at 10:35 AM, Joe Yoder wrote:
> Thanks Ricardo - The code you suggest gives me some ideas of how to
> approach the combined statement. Unfortunately there are apparently some
> errors in the code that I have not been able to correct. I like the way
> you broke up the stateme
Joe Yoder wrote:
> Thanks Ricardo - The code you suggest gives me some ideas of how to
> approach the combined statement. Unfortunately there are apparently some
> errors in the code that I have not been able to correct. I like the way
> you broke up the statement to make it understandable but
will need to work before I really understand it.
Thanks again - Joe
On Saturday, February 14, 2009 11:23 PM, Ricardo Aráoz wrote:
>
>Date: Sun, 15 Feb 2009 01:23:08 -0300
>From: Ricardo Aráoz
>To: profoxt...@leafe.com
>cc:
>Subject: Re: Simplest form of SQL?
>
>Joe Yoder wr
Joe Yoder wrote:
> Here is the code I've been trying to reduce to a single SQL select. It works
> fine as is but I'm trying to understand if there is a way to do it in a
> single statement. Perhaps this is already the simplest approach?
>
> TIA - Joe Yoder
>
> CREATE CURSOR Family (Id I)
>
Here is the code I've been trying to reduce to a single SQL select. It works
fine as is but I'm trying to understand if there is a way to do it in a single
statement. Perhaps this is already the simplest approach?
TIA - Joe Yoder
CREATE CURSOR Family (Id I)
CREATE CURSOR Members (Parent
13 matches
Mail list logo