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 but never got even an abbreviated version to 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: [email protected] >cc: >Subject: Re: Simplest form of SQL? > >On Sun, Feb 15, 2009 at 10:35 AM, Joe Yoder <[email protected]> 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 I'm afraid it >> will need to work before I really understand it. >------------------ > >What version of VFP are you using? That code should only work with VFP9. > > > >-- >Stephen Russell >Sr. Production Systems Programmer >First Horizon Bank >Memphis TN > >901.246-0159 > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.

