>Hi all,
>
>I have few Qs on the above. In our development environment, we are using VFP8 and ODBC to connect SQLServer 2K. We use views for screens and in some of the processing codes we resort to SQLPassThrough.
>
>My 1st Q is for the SQLPassThrough, do we always establish the connection handle when we start our app or when we want to use it, we create and close the handle? Or is it we can use the view connection to do this?
>
>My 2nd Q is in view parameters, I use a lot of LIKE but 1 of my colleague said we should use >= which perform faster. Is it true?
>
>Thanks in advance.
1) You can open and close or you can use view's connection handle.
2)I don't see a correlation between like and >=. Maybe you meant = and like. It wouldn't matter much IMHO. myField like 'A%' is partially optimizable and myField = 'A' is fully optimizable(ANSI is off - having same result). I prefer = too whenever I can.
Cetin