Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Is Dir_emp the LAST column in the selection section? Try to move it
from the end to the middle (or make another column the last). I suspect
that you may have a problem with the last column running into the FROM
clause.
Just a guess, but worth a try...
>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.
Précédent
Suivant
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