Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Solving a SQL problem with community
Message
De
26/06/2007 10:39:01
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01235659
Message ID:
01235668
Vues:
15
>Hello Tamar,
>
>This past weekend I was banging my head (figuratively) against a particularly gnarly SQL SELECT statement that denormalizes poorly normalized FP/DOS data for a VFP9 report cursor. Thanks to Chapter 4, I was able to take a bit of knowledge gained from your presentation at a Chicago FUDG meeting last year, and lock in the proper use of a sequential LEFT JOIN with three tables. The real gem (page 47) was figuring out that one of the WHERE conditions was filtering out records from the two JOINed tables that I really wanted - moving the condition to the ON clause fixed the problem; and there was great rejoicing at the keyboard!
>
>Morals of the story: Attend User Group meetings.- Buy the books - Attend a conference. It all really makes a difference in development.
>
>Thanks very much for your contributions to the community,

I agree wholeheartedly.
Unfortunately we don't have user groups:(
It's very hard to get those books. In my life I could only have 2 VFP related books. The first one was "Hacker's Guide to VFP3.0" by Tamar and Ted. I had to wait nearly a month after purchasing and paid a lot (shipping international) but it is worth every penny.
Despite what Tamar says in foreword, I read it literally from cover to cover:) Thanks to Tamar and Ted once again for such a great book which made my transition to VFP from fox2x much easier.
Second was Cindy Winegarden's "Study Guide" which she kindly gifted one to me signed during 2002 Devcon (so both attending a conference and book was accomplished:)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform