Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
The weirdest bug I've seen
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.
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