>>>>>>Thank you. Hopefully your preferred code works with both VFP and SQL Server. This will make it easier to maintain the code.
>>>>>>
>>>>>No, you still need to maintain 2 different versions.
>>>>
>>>>I see. Thank you for clarifying.
>>>
>>>You could use Cast(Field as Integer) = 1 in both SQL and VFP.
>>
>>Thank you. I didn't realize this could be done. But I am thinking if CASTing will slow down the SQL Select. Because I already decided that I will have two syntax versions (not very difficult), one for VFP and one for SQL. Your approach, of course, has advantage of just one code.
>
>YOu could leverage OOP: define a property on a fitting structure (CA if used)
>and set it depending on the backend used: if vfp, .t., if MsSQL, Ora,.. 1
>and in code always compare to that property. Depends a lot on the objects you use ;-)
>
>Compiler constants could be used if different versions depending on backend are deployed.
>
>
>regards
>
>thomas
Thank you very much for the suggestion.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham