General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Have you a comma in front of the nrh14000.Dir_Emp
Another problem could be, that you defined Dir_Emp as a constant somewhere
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only