>Ok thanks all, the bug isn't resolved i will rewrite all the app and see what happen. Is not the annoying?
Hector,
We bet it's a VFP string limitation problem. Did you try to simplify this SQL:
1) Use aliases instead of long Table Names
2) Remove Table alias at all, if the field name is unique
3) Remove all unnecessary conditions (like Sergey showed you).
Does it run after all?
If it's not broken, fix it until it is.
My Blog