Information générale
Catégorie:
West Wind Web Connection
It's all in the mindset. I just spent about 20 minutes trying to figure out how I could structure a query, or set of queries to get information out of a table that wouldn't choke on version 8 syntax later. The problem was that I couldn't include a memo field in a group by clause, nor could I aggragate a memo field. The field I needed for a key into another table wasn't unique in this one. My mindset was on the new group by changes and I couldn't get away from it.
It was driving me nuts, so I got up and walked away from my desk to get a drink of water, and when I came back, I slapped myself upside the head, and used a Select distinct clause that works just fine.
Mindset. It's all in the mindset.
Alan
>>>>One other thing he's complaining about is VFP's supposed limitation on nested queries -- I guess levels past 2 aren't permitted?
>>>>
>>>>Do you know anything about this? For my part at least, I've never had to go past one level, and frankly have very seldom even had to do that.
>>>
>>>Jeff:
>>>
>>>Can you define "nested queries"?
>>>
>>>Tom
>>
>>Tom, my guess is something like:
>>
>>Select x from table1 where x in (select y from table2 where y in (select z from table3)))
>>
>>Alan
>
>Alan;
>
>That could well be the case. So you just use cascading select statements and build what you require. I have one that works on ten select statements with over 20 tables, until you get the data set desired. It is fast and does its job.
>
>Tom
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement