Walter Meester
HoogkarspelPays-Bas
Walter,
Thanks for the tip.
As it turns out, and I do not recall if I already sent this in, but my problem was placing a condexpr as a WHERE CondExpr not as part of a JOIN ... ON CondExpr1 AND CondExpr2. Why it made all the difference is beyond me but it did.
Thanks,
David
>David,
>
>>WHERE IIF(lcEmplAbbr='ALL',.T.,empl_abbr=lcEmplAbbr)
>
>You could change this in:
>WHERE lcEmplAbbr='ALL' OR empl_abbr=lcEmplAbbr
>
>I figure that lcEmplAbbr is a memory variable. Maybe you can construct your SQL at forehand in a string and leave this WHERE CLAUSE out when lcEmplAbbr='ALL', just speeding up performance.
>
>Succes,
>
>Walter,
Précédent
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