>I have a simple query
>
>SELECT some fields, ... nrh14000.Dir_emp ; <<--- This field is the problem
>FROM nrh10300, nrh10200, nrh14000 ;
>INTO TABLE outrh\Maemp ;
>WHERE nrh10200.Numemp = nrh10300.Numemp ;
>AND nrh14000.Numemp = nrh10300.Numemp ;
>AND (nrh10300.Numemp <> 0 ;
>AND nrh10200.Tarchc = 'S' ;
>AND nrh10300.Tnoemp <> 'J' ;
>AND nrh10300.Tnoemp <> 'P' ;
>AND nrh10300.Tnoemp <> 'B' ;
>AND nrh10300.Numemp IN (SELECT nrh34100.Numemp FROM nrh34100 WHERE nrh34100.Checador <> 0)) ;
>AND &cDepSec ;
>ORDER BY nrh10300.Numemp
>
>When i exec the app it stops in the query with a 'Syntax Error' popup. If I remove that field (nrh14000.Dir_emp) from the query this runs OK. Why? I have anothers fields with the '_' char. I've recompiled, rewrited, reetc the app's method. I've already tried with an alias for that field, but nothing ...
>What could be wrong? This thing it's driving me crazy.
>
>thanks in advance
>Héctor L.
Hector,
Would your query run if you remove another field nrh14000.Telefono, for exapmle?
If it does than you have exceed the allowed size of foxpro command of 8,192 characters.
--sb--