Cindy,
I guess, you're right. This is very important question, so keep it for DevCon, please.
For my deepest regret, I will not come to DevCon this year :(
>Nadya,
>
>I wonder if internally VFP changes the IN () to INLIST() and runs into the limit there. Maybe some MS VFP person could answer. Guess I'll save that one for DevCon!
>
>My Oracle Rdb database seems to take any ANSI SQL-92 construct where IN (a long list of values) is allowed. I think I ran into a limit on one of my SPT queries but it may have been a list of 200 elements and I think I just divided it up.
>
>Will I meet you at DevCon? Did I tell you I grew up in Wakefield, MA and my father grew up in the Polish neighborhood in Lynn? My mother's family was in Gloucester.
>
>>Cindy,
>>
>>Ok, that's what I wanted to confirm and what Ed Pikman warned me about.
>>
>>
IN with long lists of codes doesn't work with VFP tables.>>
>>Can we consider it as a bug of VFP? From Help I don't have an impression, what this syntax is prohibited...
If it's not broken, fix it until it is.
My Blog