>
>Um, yes if you want a fair comparison, how can you make a valid comparison when the processes aren't matched?

Processes should match in requirements not on how they do it.

>>>You really are clutching at straws here, how many time shall we revist this code in order to get it to work how it's supposed to?

This is no different in any language. You shall revisit your code for optimization. Even .NET don't do that magically for you, does it.

>>
>>Oh and it's now in the way it's supposed to be ! It looked like for 'test only' code.
>
>My point was why is it necessary to have such an in-depth knowledge of VFP to get it doing something a little bit faster, when the current implementation fits the bill?

Well to me it looked like a test code. May I ask why are you executing the same SQL over and over in loop if that's your real code.

>
>>
>>Well with data at your hand you should build better :
>>

>>Select Cl_Ref ;
>>  FROM Client ;
>>  where Cl_Sname = "LAWRENCE"  And ;
>>  Pr_Code In (Select Pr_Code From Property) And ;
>>  Cl_Ref In (Select PKey From FoxGUIDS Where FoxGUIDS.Table = 'Client') ;
>>  Into Cursor temp nofilter
>>

>
>Going on past experience using IN I'm not keen on it, however, I'll try it by all means.
>

>I never actually saw you post any results with a small case study.

Oh my. Are you sure you read my msgs in your other thread at all.
Cetin